SQL Server - Performance Counters, Thresholds, etc.

Blog do Ezequiel
Portuguese PFE SQL Server Team


Latest Updates
10/05/2014 - Latest update on the AdaptiveIndexDefrag procedure v1.5.8. Look for it in the "Ezequiel shortcuts" section on the right or just click HERE.

10/05/2014 - Updates to Maintenance plan deployment scripts available HERE

04/06/2014 - The SQL Swiss Army Knife Series Index

SQL Server - Performance Counters, Thresholds, etc.

Rate This
  • Comments 2

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,

 

Social Media Sharing
|
Leave a Comment
  • Please add 5 and 2 and type the answer here:
  • Post
Page 1 of 1 (2 items)