Dashboard alerts/reports areas loading since 7.1 spring update - overall slowness

[stahly8]

We upgraded to the 7.1 spring update yesterday and on our main dashboard we have about 10+ different Alert Report areas that are just showing the spinning loading icon for about 10 minutes and most of them never load. the server has since been restarted, cpu and memory usage are both below 25%. we are only using the inventory side, not the helpdesk portion at all. i also verified that the scanning queue was empty and not performing any active scans.

[JacobH]

are you able to run SQL Server Management Studio (SSMS) and run the queries in question?

https://stackoverflow.com/questions/6006980/cannot-connect-to-sql-server-express-from-ssms

that has a reference/answer that tells you how to connect SSMS to SQL Express.


if it's still slow, you pinpointed that it's the database and not the service/webservice


SSMS Download:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

[Esben_D]

Whats kind of database are you using? Also it's useful to check how full your database is.

[stahly8]

Database: SQL Compact: C:\Program Files (x86)\Lansweeper\website\..\SQLDATA\lansweeperdb.sdf
Schema Version: 166
Assets: 1737
Size: 287/ 4090 MB

i also have performed the truncate logs, shrink and compact procedures from the maintenance tool.

the slowness isnt just on the dashboard main page either. it seems to crawl pretty much just opening any other page. even if that page is being the only thing opened. where before i could bring up the lansweeper main page, and then open up various reports & they would open up without any kind of delay.

i have also tried other computers and browsers as well. never experienced this till the new update.