By jrandol
via beyondrelational.com
Published: Sep 19 2010 / 10:06
I firmly believe a DBA is only as good as how well he/she knows Performance Counters. I have been wanting to blog/learn on them for a long time and thought would start with the list of important counters as listed in Grant Fritchey/Sagal Dam’s great book - 'SQL Server 2008 Performance Tuning Distilled'. This book is a bible for troubleshooting query heavy SQL Servers and has a section devoted to base lining using performance counters. There are two counters listed as important for monitoring Memory – Available Mbytes and Pages/Sec.
Add your comment