Dashboard and Computer action pages load slow

[cweislak]

We are having an issue with the dashboard and the Action page for a computer loading slow. It takes about 25 seconds for them to load. Most other pages or query's take about 2 seconds. We are running Lansweeper on:

Windows 2008R2 server with SQL Express 2008
Lansweeper version 4.0.0.37

It worked great until we upgraded from version 3.5 to 4.0. I installed the latest version in hopes of it improving the performance. It didn't. watching the server when the dashboard is clicked the SQL process hits 40% CPU usage until the page loads. No matter the browser or client that opens the page. Any idea's or help would be welcomed.

[cweislak]

I found the issue. Thank you for pointing me in the right direction. It was a report that I put on the dashboard that was checking all computers event logs for a user id. I deleted the report and it works great.

[Hemoco]

How many reports are in the dashboard and how many records are in each of them?

You can try rebuilding all indexes in the database

SQL script:
"execute psysrebuildallindexes"

(might take a while)