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 LSAgent has forgotten x64 Windows applications
by  thoughtmonkey   Go to last post Go to first unread
Last post: Today at 8:06:40 AM(UTC)
Lansweeper Lsremote "No supported authentication methods!"
by  Duiker  
Go to last post Go to first unread
Last post: Today at 7:52:24 AM(UTC)
Lansweeper Scan Uptime.
by  TimAlex   Go to last post Go to first unread
Last post: Today at 7:32:41 AM(UTC)
Lansweeper Force SNMP?
by  kuku1122  
Go to last post Go to first unread
Last post: Today at 6:54:09 AM(UTC)
Lansweeper Performance scanning - incorrect values
by  Richard_Lan   Go to last post Go to first unread
Last post: Yesterday at 4:26:02 PM(UTC)
Lansweeper Windows firewall rules
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 2:56:52 PM(UTC)
Lansweeper Run outside of our domain?
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 2:53:05 PM(UTC)
Lansweeper Add logic to certain ticket submission
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 1:02:46 PM(UTC)