| Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager |
| Statistics related to SQL Servers buffer manager |
| NameSpace Path |
| \ROOT\CIMV2 |
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| AWElookupmapsPersec | | UInt64 | Number of AWE map calls made for pages found in the buffer pool. |
| AWEstolenmapsPersec | | UInt64 | Number of AWE map calls made for pages stolen from the buffer pool. |
| AWEunmapcallsPersec | | UInt64 | Number of AWE unmap calls. |
| AWEunmappagesPersec | | UInt64 | Number of AWE pages unmapped. |
| AWEwritemapsPersec | | UInt64 | Number of AWE map calls made for pages to be written to disk. |
| Buffercachehitratio | | UInt64 | Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| Buffercachehitratio_Base | | UInt64 | Base for prior entry |
| Caption | | String | A short textual description (one-line string) for the statistic or metric. |
| CheckpointpagesPersec | | UInt64 | Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed. |
| Databasepages | | UInt64 | Number of pages in the buffer pool with database content. |
| Description | | String | A textual description of the statistic or metric. |
| FreeliststallsPersec | | UInt64 | Number of requests that had to wait for a free page. |
| Freepages | | UInt64 | Total number of pages on all free lists. |
| Frequency_Object | | UInt64 | NA |
| Frequency_PerfTime | | UInt64 | NA |
| Frequency_Sys100NS | | UInt64 | NA |
| LazywritesPersec | | UInt64 | Number of buffers written by buffer manager's lazy writer. |
| Name | | String | The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. |
| Pagelifeexpectancy | | UInt64 | Number of seconds a page will stay in the buffer pool without references. |
| PagelookupsPersec | | UInt64 | Number of requests to find a page in the buffer pool. |
| PagereadsPersec | | UInt64 | Number of physical database page reads issued. |
| PagewritesPersec | | UInt64 | Number of physical database page writes issued. |
| ReadaheadpagesPersec | | UInt64 | Number of pages read in anticipation of use. |
| Reservedpages | | UInt64 | Number of buffer pool reserved pages. |
| Stolenpages | | UInt64 | Number of pages used for miscellaneous server purposes (including procedure cache). |
| Targetpages | | UInt64 | Ideal number of pages in the buffer pool. |
| Timestamp_Object | | UInt64 | NA |
| Timestamp_PerfTime | | UInt64 | NA |
| Timestamp_Sys100NS | | UInt64 | NA |
| Totalpages | | UInt64 | Number of pages in the buffer pool (includes database, free, and stolen). |
| SAMPLE DATA INSTANCE |
Class does not currently contain data instances
|
