WUtils.com

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