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).

Peter Aston 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