April 21, 2009 at 7:53 am
Hi All
I'd appreciate some advice as to how to interpret/ use these two counters in perfmon. I've read that they can be a good indication of schema problems .. queries not being paramatised correctly etc
any sort of ball park figures I shopuld be looking for here or do I need to make a correlation with another perfmon counter ?
many thanks
~Simon
April 21, 2009 at 8:29 am
You basically need a baseline to compare against. I'd suggest collecting the information when there are very few users on the system and then when there are lots of users. Then comparing the two will tell you if you have recompile issues.
However, I wouldn't recommend these as a starting point for checking the server. Waits and Queues are the best places to begin gathering information about your server. Then if you find that lots of processes are queueing and the causes for the queue are waits on compiles or recompiles, you can drill down on that issue then. Microsoft has a great white paper on waits and queues that is a must read: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc
"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
April 21, 2009 at 8:33 am
thank you much appreciated... I see its for 2005.. does the bulk of the reading etc still remain relevant for sql 2008 ?
regards
~simon
April 21, 2009 at 9:00 am
Oh yeah. A few details may change, but the basic approach & scope is the same for 2008.
"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
April 22, 2009 at 7:49 am
thank you grant much appreciated... I best go investigate your book methinks "!
~simon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply