Notification

Icon
Error

SQL Server getting slower - SQL server issues

Posted: Tuesday, February 26, 2019 12:39:55 PM(UTC)
Cristian Blanco

Cristian Blanco

Member Original PosterPosts: 13
0
Like
Good morning, we are having issues in our SQL server. We run server profiler a we are getting thousand of lines. When we disable all scanning targets and stop lansweeper service those lines reduce to 10%, but we are still having problems. Can anyone help us to make lansweeper use less resources and cause less troubles in our SQL server? Any tips?

Thanks you very much,
JacobH
#1JacobH Member Posts: 142  
posted: 2/26/2019 2:09:58 PM(UTC)
Cristian Blanco
#2Cristian Blanco Member Original PosterPosts: 13  
posted: 2/26/2019 2:25:49 PM(UTC)
Thanks Jacob, we´ve just tried that. I will get back to you.
Cristian Blanco
#3Cristian Blanco Member Original PosterPosts: 13  
posted: 3/21/2019 12:59:10 PM(UTC)
Hi JacobH, I tried the steps you gave me, but it is still slow. I am having 43154 Reads in SQL profiler.
Any other idea?
JacobH
#4JacobH Member Posts: 142  
posted: 3/21/2019 1:17:42 PM(UTC)
can you go to configuration > database tables and share SQL version and database sizes? can you share the VM sizing of the SQL server?

you may want to email support@lansweeper.com - they probably can help more than I can - but i'm willing to give it a try



Cristian Blanco
#5Cristian Blanco Member Original PosterPosts: 13  
posted: 3/21/2019 1:50:34 PM(UTC)
APPLICATIONS Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Database: lansweeperdb
Server: localhost
Schema Version: 163
Assets: 3250
Size: 933.63 MB
Unallocated: 187.02 M

I will also contact lansweeper support.
Thanks!!!
JacobH
#6JacobH Member Posts: 142  
posted: 3/21/2019 1:59:52 PM(UTC)
OK - that's an odd one lol

Windows 7 SP1 VM, SQL 2008R2?


there could be a lot of variables at play here - run perfmon or resource monitor and see the metrics (CPU, I/O, etc.)

that's such an odd combination - if I were you, I'd put it on windows server VM, and based on the small number of assets, it's up to you, but I'd use either a higher version of SQL server, or use SQL Express with your current windows 7 setup...

I know you can go from SQL Express to MSSQL, but not sure if you can go backwards...

Cristian Blanco
#7Cristian Blanco Member Original PosterPosts: 13  
posted: 3/21/2019 2:19:47 PM(UTC)
Actually, It is Windows Server 2008 R2 Enterprise SP1 and SQL 2008R2
JacobH
#8JacobH Member Posts: 142  
posted: 3/21/2019 2:44:18 PM(UTC)
That's weird the build number and NT version say windows 7 from Microsoft...

anyhoo... see what support says, but that's still an older setup (as you know).. I skipped SQL 2008 in my career.. and i'm not a DBA per se.

if I think of anything else I'll let you know

Active Discussions

Lansweeper Windows Domain Overview report
by  AZHockeyNut   Go to last post Go to first unread
Last post: 4/19/2019 4:36:26 PM(UTC)
Report Center Internet Explorer Vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: 4/18/2019 4:08:50 PM(UTC)
Lansweeper OS: Not latest Build of Windows 10
by  dussan   Go to last post Go to first unread
Last post: 4/18/2019 9:04:54 AM(UTC)
Report Center Patch Tuesday report, last 3 months
by  Tenacious  
Go to last post Go to first unread
Last post: 4/17/2019 10:46:26 PM(UTC)
Report Center BIOS Type (Legacy or UEFI)
by  manunkind   Go to last post Go to first unread
Last post: 4/17/2019 8:47:42 PM(UTC)
Lansweeper Out of Warranty report with more information
by  Sean m Taylor  
Go to last post Go to first unread
Last post: 4/17/2019 7:32:18 PM(UTC)
Report Center Microsoft Patch Tuesday Report - April 2019
by  joe_user   Go to last post Go to first unread
Last post: 4/17/2019 4:24:50 PM(UTC)
Lansweeper Reporting on a custom Field in Helpdesk
by  Esben.D  
Go to last post Go to first unread
Last post: 4/17/2019 3:11:45 PM(UTC)