I have SQL Monitor running on many instances. Is there a way to identify the least busy instance?

JamesDye

Trying to determine which instance is best to put new workload.

squigley

Good Morning!
The SQL Monitor Overviews page should at a glance give the performance of each of the server instances
​

You can dig deeper into what going on with each of the monitored servers via the performance diagnostics as mentioned in the below page:

https://documentation.red-gate.com/sm/overview-pages/using-performance-diagnostics

Let me know if you have any other questions or concerns.

Thanks!

JamesDye

The dashboard gives a snapshot of this moment in time.  I was hoping that someone had developed a query/report that would correlate the historical data and show least loaded server over time.

squigley

Thanks for the clarification James!

Unfortunately at this time there isn't a way to setup the SQL Monitor Reports to do that. Apologies for the inconvenience that this brings.

I would highly suggest creating a uservoice request for this so that the developers can see the demand for such a feature.

https://sqlmonitor.uservoice.com/forums/91743-suggestions

Be sure to let me know of any other questions or concerns that you have.

Thanks!