Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Buffer Manager\Reserved Pages Expand / Collapse
Author
Message
Posted Wednesday, July 13, 2011 1:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 25, 2012 5:18 AM
Points: 2, Visits: 28
Hi there,

Could anyone out there explain to me what this performance counter tells me please? I can't find much out there...

Buffer Manager\Reserved pages
"Number of buffer pool reserved pages."

Some context around my question:

We are seeing buffer cache hit ratio fall at exactly the same time as reserved pages grows to consistently around 100,000. We currently have 12GB assigned to SQL server, all of which is being used. When this reservation takes place it is signifigantly degrading performance presumably because it is causing ~100,000 pages to be stolen from db objects that were cached.

The output of DBCC MEMORYSTATUS shows a similar number under Buffer Counts - External Reservation

Are these two related? How can I narrow in on the root cause?
Post #1141265
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse