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 |
|
lcohan
Starting Member
2 Posts |
 Posted - 2011-09-14 : 15:13:18
|
| Buffer Pages Distribution report is showing a very high number of Stolen pages however everything else on the server (including its performance) looks otherwise. Dirty (38526) Free(744)Latched(16) Stolen(611817)If I'm not mistaken the actual counter behind it is "Stolen pages: Number of pages used for miscellaneous server purposes (stolen from the buffer pool) on this node." from SQL Server, Buffer Node Object - http://msdn.microsoft.com/en-us/library/ms345597(v=SQL.100).aspxMy question is - do I need to worry about anything on the actual SQL server as nothing leads me so far to believe there's memmory pressure on the box other than this counter. Page life is high, Target and Total are equal and equal to my max memory limit set on the box - specs below: Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (2008) <X64> (Build 7601: Service Pack 1) AWE is not enabled and the box is a HP server with 8CPU and 65GB RAM |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-15 : 00:45:25
|
| If PLE is high, target = total, and there's no performance issues, I'll ignore it.No need to enable AWE.You HAVE set max memory to leave a few GB for the OS right?I/O counters look ok? |
 |
|
|
lcohan
Starting Member
2 Posts |
Posted - 2011-09-15 : 11:41:19
|
| That's what I thought as well - thanks!Yes, there are 5+GB free for OS as SQL max is set to 60GB and nothing but Windows and 1 SQL server is running on the box - including viruscan which is closely monitored to NOT scan any SQL files or any other files that can impact overall performance. IO stats look great after we upgraded to the new PAR3 SAN and with ALL running including full backup on our peek days the highiest average disk queue length ever reported by SQL data collections was 2 - in the past we had up to 4000! on the index LUN..oh wellThanks again. |
|
|
|
|
|
|
SQL 2008 Memory Consumption report