WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager, ROOT\CIMV2

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

Description

Statistics related to SQL Servers buffer manager

Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager properties

Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager has 32 properties (23 Local, 9 Derived)

NameOriginCIMType
BackgroundwriterpagesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
BuffercachehitratioWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
Buffercachehitratio_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CheckpointpagesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
DatabasepagesWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
ExtensionallocatedpagesWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionfreepagesWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensioninuseaspercentageWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionoutstandingIOcounterWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpageevictionsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpagereadsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpageunreferencedtimeWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ExtensionpagewritesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
FreeliststallsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
IntegralControllerSlopeWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
LazywritesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
NameCIM_StatisticalInformation8 [string]
PagelifeexpectancyWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
PagelookupsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
PagereadsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
PagewritesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ReadaheadpagesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
ReadaheadtimePersecWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
TargetpagesWin32_PerfRawData_MSSQLSERVER_SQLServerBufferManager21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager properties

Local properties (23) of Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager class

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

Derived properties (9) of Win32_PerfRawData_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_PerfRawData_MSSQLSERVER_SQLServerBufferManager Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Statistics related to SQL Servers buffer manager'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Buffer Manager'✓✗✓✓✓
DisplayName009'SQLServer:Buffer Manager'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager System properties

…
NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager'___SYSTEM8✗✗
__NAMESPACE'ROOT\cimv2'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8✗✓
__PROPERTY_COUNT32___SYSTEM3✗✗
__RELPATH'Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager'___SYSTEM8✗✗
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8✗✗
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8✗✗
__CLASS'Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager

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