There are a ton of Perfmon counters to look at when investigating SQL Server problems. This pdf is a great resource for starting out.
http://www.quest.com/backstage/images/promotions/SQLServer-Perfmonance-Poster.pdf
There is a cool spreadsheet too
http://blogs.msdn.com/b/jimmymay/archive/2008/10/15/perfmon-objects-counters-thresholds-utilities-for-sql-server.aspx
No comments:
Post a Comment