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

• 
  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!
  

  
  

  squigley March 18, 2020 17:54

  - 0 +
• 
  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.

  JamesDye March 18, 2020 18:31

  - 0 +
• 
  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!
  

  
  

  
  

  squigley March 23, 2020 15:42

  - 0 +

Add comment

Please sign in to leave a comment.