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

JamesDye · March 17, 2020 3:05PM

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

squigley · March 18, 2020 5:54PM

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

Image: https://redgatesupport.zendesk.com/attachments/token/bhEZZHTjlLfEpCwKEqR6p71U3/?name=inline-1241101113.png

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 · March 18, 2020 6:31PM

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 · March 23, 2020 3:42PM

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!

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk