SQL Server - Performance Counters, Thresholds, etc.

These are normal questions:

  • What counters should I select to monitor my SQL Server instance?
  • What thresholds or values should I use to know when something bad is happening?

Use this webcast to get answers:

TechNet Webcast: SQL Server Performance Counter Guidance

https://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032357640&CountryCode=US

Jimmy May, is sharing an Excel file with some consolidated information about this problematic:

https://blogs.msdn.com/jimmymay/archive/2008/10/15/perfmon-objects-counters-thresholds-utilities-for-sql-server.aspx

Cheers,