Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager, ROOT\CIMV2

Class | Methods | Properties (31) | Qualifiers (15) | Instances (1) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

Statistics related to SQL Servers buffer manager

Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager has 31 properties (22 Local, 9 Derived)

NameOriginCIMType
BackgroundwriterpagesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
BuffercachehitratioWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CheckpointpagesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
DatabasepagesWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
ExtensionallocatedpagesWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionfreepagesWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensioninuseaspercentageWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionoutstandingIOcounterWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpageevictionsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpagereadsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpageunreferencedtimeWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpagewritesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
FreeliststallsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
IntegralControllerSlopeWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
LazywritesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
NameCIM_StatisticalInformation8 [string]
PagelifeexpectancyWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
PagelookupsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
PagereadsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
PagewritesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ReadaheadpagesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ReadaheadtimePersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
TargetpagesWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager properties

Local properties (22) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager class

BackgroundwriterpagesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'BackgroundwriterpagesPersec'
CounterType272696576
Description'Number of pages flushed to enforce the recovery interval settings.'
DisplayName'Background writer pages/sec'
DisplayName009'Background writer pages/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
BackgroundwriterpagesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
Buffercachehitratio property
CIMTYPE'uint64'
CookingType''
Counter'Buffercachehitratio'
CounterType537003264
Description'Percentage of pages that were found in the buffer pool without having to incur a read from disk.'
DisplayName'Buffer cache hit ratio'
DisplayName009'Buffer cache hit ratio'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Buffercachehitratio property is in 4 classes of ROOT\cimv2 and in 1 namespace
CheckpointpagesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'CheckpointpagesPersec'
CounterType272696576
Description'Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed.'
DisplayName'Checkpoint pages/sec'
DisplayName009'Checkpoint pages/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CheckpointpagesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
Databasepages property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Databasepages'
CounterType65792
Description'Number of pages in the buffer pool with database content.'
DisplayName'Database pages'
DisplayName009'Database pages'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Databasepages property is in 8 classes of ROOT\cimv2 and in 1 namespace
Extensionallocatedpages property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Extensionallocatedpages'
CounterType65792
Description'Number of pages occupying buffer pool extension cache.'
DisplayName'Extension allocated pages'
DisplayName009'Extension allocated pages'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Extensionallocatedpages property is in 2 classes of ROOT\cimv2 and in 1 namespace
Extensionfreepages property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Extensionfreepages'
CounterType65792
Description'Number of pages needed to fill the buffer pool extension cache.'
DisplayName'Extension free pages'
DisplayName009'Extension free pages'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Extensionfreepages property is in 2 classes of ROOT\cimv2 and in 1 namespace
Extensioninuseaspercentage property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Extensioninuseaspercentage'
CounterType65792
Description'Percentage of the buffer pool extension paging file occupied by buffer manager pages.'
DisplayName'Extension in use as percentage'
DisplayName009'Extension in use as percentage'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Extensioninuseaspercentage property is in 2 classes of ROOT\cimv2 and in 1 namespace
ExtensionoutstandingIOcounter property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ExtensionoutstandingIOcounter'
CounterType272696576
Description'Number of buffer pool extension page reads/writes outstanding.'
DisplayName'Extension outstanding IO counter'
DisplayName009'Extension outstanding IO counter'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExtensionoutstandingIOcounter property is in 2 classes of ROOT\cimv2 and in 1 namespace
ExtensionpageevictionsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ExtensionpageevictionsPersec'
CounterType272696576
Description'Number of buffer pool extension page evictions.'
DisplayName'Extension page evictions/sec'
DisplayName009'Extension page evictions/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExtensionpageevictionsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
ExtensionpagereadsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ExtensionpagereadsPersec'
CounterType272696576
Description'Number of buffer pool extension page reads issued.'
DisplayName'Extension page reads/sec'
DisplayName009'Extension page reads/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExtensionpagereadsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
Extensionpageunreferencedtime property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Extensionpageunreferencedtime'
CounterType65792
Description'Average seconds a page will stay in the buffer pool extension without references.'
DisplayName'Extension page unreferenced time'
DisplayName009'Extension page unreferenced time'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Extensionpageunreferencedtime property is in 2 classes of ROOT\cimv2 and in 1 namespace
ExtensionpagewritesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ExtensionpagewritesPersec'
CounterType272696576
Description'Number of Extension page writes issued.'
DisplayName'Extension page writes/sec'
DisplayName009'Extension page writes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExtensionpagewritesPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
FreeliststallsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'FreeliststallsPersec'
CounterType272696576
Description'Number of requests that had to wait for a free page.'
DisplayName'Free list stalls/sec'
DisplayName009'Free list stalls/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
FreeliststallsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
IntegralControllerSlope property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'IntegralControllerSlope'
CounterType65792
Description'The slope that integral controller for the buffer pool last used, times -10 billion'
DisplayName'Integral Controller Slope'
DisplayName009'Integral Controller Slope'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
IntegralControllerSlope property is in 4 classes of ROOT\cimv2 and in 1 namespace
LazywritesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LazywritesPersec'
CounterType272696576
Description'Number of buffers written by buffer manager's lazy writer.'
DisplayName'Lazy writes/sec'
DisplayName009'Lazy writes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LazywritesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
Pagelifeexpectancy property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Pagelifeexpectancy'
CounterType65792
Description'Number of seconds a page will stay in the buffer pool without references.'
DisplayName'Page life expectancy'
DisplayName009'Page life expectancy'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Pagelifeexpectancy property is in 8 classes of ROOT\cimv2 and in 1 namespace
PagelookupsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PagelookupsPersec'
CounterType272696576
Description'Number of requests to find a page in the buffer pool.'
DisplayName'Page lookups/sec'
DisplayName009'Page lookups/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PagelookupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
PagereadsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PagereadsPersec'
CounterType272696576
Description'Number of physical database page reads issued.'
DisplayName'Page reads/sec'
DisplayName009'Page reads/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PagereadsPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
PagewritesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PagewritesPersec'
CounterType272696576
Description'Number of physical database page writes issued.'
DisplayName'Page writes/sec'
DisplayName009'Page writes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PagewritesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
ReadaheadpagesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ReadaheadpagesPersec'
CounterType272696576
Description'Number of pages read in anticipation of use.'
DisplayName'Readahead pages/sec'
DisplayName009'Readahead pages/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ReadaheadpagesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
ReadaheadtimePersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ReadaheadtimePersec'
CounterType272696576
Description'Time (microseconds) spent issuing readahead.'
DisplayName'Readahead time/sec'
DisplayName009'Readahead time/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ReadaheadtimePersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
Targetpages property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Targetpages'
CounterType65792
Description'Ideal number of pages in the buffer pool.'
DisplayName'Target pages'
DisplayName009'Target pages'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Targetpages property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager class

Caption property
CIMTYPE'string'
Description'A short textual description (one-line string) for the statistic or metric.'
MaxLen64
readTrue
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces
Description property
CIMTYPE'string'
Description'A textual description of the statistic or metric.'
readTrue
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces
Frequency_Object property
CIMTYPE'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Frequency_PerfTime property
CIMTYPE'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Frequency_Sys100NS property
CIMTYPE'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Name property
CIMTYPE'string'
Description'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. '
MaxLen256
readTrue
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Timestamp_Object property
CIMTYPE'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Timestamp_PerfTime property
CIMTYPE'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Timestamp_Sys100NS property
CIMTYPE'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager'
CookedTrue
Description'Statistics related to SQL Servers buffer manager'
DisplayName'SQLServer:Buffer Manager'
DisplayName009'SQLServer:Buffer Manager'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQLSERVER'
SingletonTrue

Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT31___SYSTEM3
__RELPATH'Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfFormattedData'___SYSTEM8
__CLASS'Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager

Number of classes:1
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager03201--
comments powered by Disqus
WUtils.com