Before I hit Idera Support with an annoying ticket of "but it's slow" I thought I'd run this past everyone.
My long running install of v10.0 was annoyingly slow when my team would navigate around the tree on the left. Notably as we'd have to scroll to the bottom of our 350 servers everything would just pause while the tree refreshed. Like pause long enough to be a legit annoyance.
This week I finally upgraded to 10.2.3 and this issue is persisting.
Do other people encounter this? If so--did anyone figure out how to fix it? Are there any real world recommendation for workstation specifications for monitoring this many servers?
I only have 40 Servers (but 194 mio rows in the DatabaseStatistics Table), and had a slow console after upgrading to Version 10 in August 2017, too. I then decided to first have a look at it myself.
I could identify 2 Stored Procedures in the repository creating massive load and had a look at them. Modifying them by adding "WITH RECOMPILE", made instantly a huge difference. Possibly because I have all kinds of servers, from tiny to massive and therefore different data that require different execution plans they need to be compiled on every execution. I also tweaked a few indexes and after that the console was responsive as before.
I know, this is not supported, but it works and was quicker than going through the "send me the logs" standard support procedure ;-)
Thanks for the tip.
I'll start looking through the stored procedures and see what might be happening on that front. What 2 did you identify?
In my case it was [p_GetDatabaseCounters] and [p_GetServerSummary].