| Win32_PerfFormattedData_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. | |
| 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 | |||
| [Description("Statistics related to SQL Servers buffer manager"): ToInstance Amended, DisplayName("SQLServer:Buffer Manager"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended] instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager { [Description("Number of AWE map calls made for pages found in the buffer pool."): ToInstance Amended, DisplayName("AWE lookup maps/sec"): ToInstance Amended] AWElookupmapsPersec = "0"; [Description("Number of AWE map calls made for pages stolen from the buffer pool."): ToInstance Amended, DisplayName("AWE stolen maps/sec"): ToInstance Amended] AWEstolenmapsPersec = "0"; [Description("Number of AWE unmap calls."): ToInstance Amended, DisplayName("AWE unmap calls/sec"): ToInstance Amended] AWEunmapcallsPersec = "0"; [Description("Number of AWE pages unmapped."): ToInstance Amended, DisplayName("AWE unmap pages/sec"): ToInstance Amended] AWEunmappagesPersec = "0"; [Description("Number of AWE map calls made for pages to be written to disk."): ToInstance Amended, DisplayName("AWE write maps/sec"): ToInstance Amended] AWEwritemapsPersec = "0"; [Description("Percentage of pages that were found in the buffer pool without having to incur a read from disk."): ToInstance Amended, DisplayName("Buffer cache hit ratio"): ToInstance Amended] Buffercachehitratio = "0"; [Description("Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed."): ToInstance Amended, DisplayName("Checkpoint pages/sec"): ToInstance Amended] CheckpointpagesPersec = "0"; [Description("Number of pages in the buffer pool with database content."): ToInstance Amended, DisplayName("Database pages"): ToInstance Amended] Databasepages = "0"; [Description("Number of requests that had to wait for a free page."): ToInstance Amended, DisplayName("Free list stalls/sec"): ToInstance Amended] FreeliststallsPersec = "0"; [Description("Total number of pages on all free lists."): ToInstance Amended, DisplayName("Free pages"): ToInstance Amended] Freepages = "0"; [Description("Number of buffers written by buffer manager's lazy writer."): ToInstance Amended, DisplayName("Lazy writes/sec"): ToInstance Amended] LazywritesPersec = "0"; [Description("Number of seconds a page will stay in the buffer pool without references."): ToInstance Amended, DisplayName("Page life expectancy"): ToInstance Amended] Pagelifeexpectancy = "0"; [Description("Number of requests to find a page in the buffer pool."): ToInstance Amended, DisplayName("Page lookups/sec"): ToInstance Amended] PagelookupsPersec = "0"; [Description("Number of physical database page reads issued."): ToInstance Amended, DisplayName("Page reads/sec"): ToInstance Amended] PagereadsPersec = "0"; [Description("Number of physical database page writes issued."): ToInstance Amended, DisplayName("Page writes/sec"): ToInstance Amended] PagewritesPersec = "0"; [Description("Number of pages read in anticipation of use."): ToInstance Amended, DisplayName("Readahead pages/sec"): ToInstance Amended] ReadaheadpagesPersec = "0"; [Description("Number of buffer pool reserved pages."): ToInstance Amended, DisplayName("Reserved pages"): ToInstance Amended] Reservedpages = "0"; [Description("Number of pages used for miscellaneous server purposes (including procedure cache)."): ToInstance Amended, DisplayName("Stolen pages"): ToInstance Amended] Stolenpages = "0"; [Description("Ideal number of pages in the buffer pool."): ToInstance Amended, DisplayName("Target pages"): ToInstance Amended] Targetpages = "0"; [Description("Number of pages in the buffer pool (includes database, free, and stolen)."): ToInstance Amended, DisplayName("Total pages"): ToInstance Amended] Totalpages = "0"; }; | |||