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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-03 : 09:04:27
|
| Dave writes "I'm running Perfmon on a SQL 7(sp4) NT 4 server that for the most part appears to be tuned very well (ex: 100% Buffer Cache Hit Ratio, Processor Queue Length of 0, etc) however I am getting an average 'Stolen Page Count' (from the Buffer Manager Object) of 7,000. I know the definition of what a 'Stolen Page Count' is (ie page in buffer cache taken for other server requests), but, how can I determine why my Stolen Page count is so high and who is taking them? Thanks in advance!Dave." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-07-03 : 10:21:04
|
| If you have a lot of queries, using merge or hash joins? Tru to put a LOOP JOIN hint on those, and see if the Stolen Page Count will go down... Here is an article that mentions this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q243588Edited by - izaltsman on 07/03/2002 10:22:29 |
 |
|
|
|
|
|
PerfMon - Stolen Pages