January 26, 2010 at 4:42 am
when i need to know the threshold for a particular performance counter such as disk queue, page life expectancy etc, i search online and usually find something, but cant find a MS page with rough threshold values.
can anyone advise if such a resource exists?
January 26, 2010 at 7:51 am
There isn't one hard & fast number for most of these values. Almost all of them are dependent on your particular hardware and it's configuration. But, most performance monitoring or tuning articles, blogs or books will provide some baseline numbers along with a set of caveats for applying those numbers to your circumstances.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2010 at 8:08 pm
Every counter has its own guidelines for thresholds, though i would suggest to see the trend and define a baseline for acceptable threshold...even what is suggested online may not exactly suite for your env...
There are lots of article if you search for "perfmon windows sql server" for relevent data with thresholds
Officially I think there are microsoft press books available which talks about perfmon on windows 2003 not sql server, though most of them do not talk about specially for sql server
Try inside series for sql server 2000 that has a chapter for perfmon and sql server counters with recommendation
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply