1

This isn’t a question as such, more a tip! You may, or may not, be aware of changing the Max Degree of Parallelism in SQL SSMS to improve the SCOM console performance:

http://thoughtsonopsmgr.blogspot.co.uk/2014/12/scom-2012x-console-on-steroids-try-mdop.html

When I tried that it didn’t really help that much, but what did make a difference in conjunction with the above was to change the ‘cost threshold for parallelism’ setting as well, in my case from 5 to 50. (Our SQL server is running on VMWare, YMMV etc.)

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-cost-threshold-for-parallelism-server-configuration-option#Recommendations

This appears to have improved my Operations console performance and the speed in which Squared Up displays dashboard data (on top of performance improvements in 3.2.1).

astonpa selected answer
    • How does your vmwaremachine look? How many CPU:s in the virtual machine and on the host itself?
    • "This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician." - Sounds like I need to find a DBA to assist me 🙁
    • @jannep 4 CPUs on the virtual machine, not sure about the host
    • I didn’t even know this was a thing. Thanks for bringing it to my attention. I just did a huge amount of reading on this, made some changes and now things are running much better