I am seeing the same issue. Any update on your problem?
1 of 1 people found this helpful
Have you checked the fragmentation level of the database indexes. You can check this by opening the databse manager on the Orion Primary App Server. Programs/SolarwindsOrion/Advance Features/Database Manager
Once Open click the button that says add default server
Right Click on the Database name and select database details
You can set a flag in the database settings as well to allow the tables to be dfragmented during the nightly DBmaint job
To do so you can Right click on the database name and click new query and type the below statement there and execute.
UPDATE dbo.Settings SET CurrentValue=1 WHERE SettingsID LIKE 'dbm-defragmentation-enabled%'
Hope this helps. You may also want ot check basic things like the perfomance of the App server/ VM resources.
Loop1 Systems: SolarWinds Training and Professional Services