July 25, 2008 at 9:55 pm
I have done perfmon analysis for CPU, DiskIO, Memory and processor counters.
I am looking for some document where I can compare above counters value to do performance analysis.
Can anybody point me to document for comparision?
p.s. I have come across many documents but could not fine one for value comparision.
July 28, 2008 at 2:47 am
You just check with your benchmark (accepted) values. Ideally it is based on the concurrency, Database sizes and h/w efficiency.
July 28, 2008 at 7:05 am
There isn't a "right" number for a lot of these values. It really depends on the system you're on. Simply collecting one set of values is usually not enough. We generally try to collect a set of values from a very low traffic position on the system and a set from a high traffic position. Then, when you collect a third set of values, you have something to compare them to.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply