SQL Server - Performance Counters, Thresholds, etc.

First published on MSDN on Nov 05, 2008

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

http://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:

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

Cheers,