October 31, 2003 at 12:15 pm
I'm monitoring a long running process that is called thru an ASP page. I went thru and added all of the buffer manager objects to a perfmon and everything is optimal except for stolen pages. The stolen pages counter is consistenly climbing upwards slowly,I imagine that it is losing memory to IIS which is also running on the machine.
I guess my question is 'should I be concerned?' I guess I could allocate a min. amount of memory to the server but, this only looks wierd to me, not sure its wrong.
Thanks,
Chris
October 31, 2003 at 12:34 pm
It is the number of pages that were stolen from the buffer cache to satisfy other memory requests.
Quote from KB243588
"If the CPU usage, SQL Compilations/sec, and Free Buffers counters are high, and the Memory Grants Pending and Stolen Page Count counters are low, this indicates that the CPU is the bottleneck. Focus on how to effectively parameterize and reuse query plans to avoid the cost of query plan generation, and see the "Group the SQL Profiler trace by event class" section of this article. If the Free Buffers and SQL Compilations/sec counters are low, and the Stolen Page Count and Memory Grants Pending counters are high, SQL Server is memory-constrained. Focus on finding queries where hash joins are used and can be changed to loop joins, and see the "Group the SQL Profiler trace by duration" section of this article"
http://support.microsoft.com/default.aspx?scid=kb;en-us;243588&Product=sql2k
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply