Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Simon_L
Starting Member
32 Posts |
 Posted - 2009-04-21 : 10:01:56
|
| 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 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-21 : 16:08:41
|
| you can correlate them with Batch Requests/sec. The number of compilations should be low compared to that I use <10% for a ballpark. As close to 0% as possible is better, of course. |
 |
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2009-04-22 : 09:41:04
|
| many thanks :-) most helpful ! ~simon |
|
|
|
|
|
|
SQLServer:SQL Stats - SQL compilations & recompila