Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode, ROOT\CIMV2
Class
| Methods | Properties (13)
| Qualifiers (12)
| Instances (1)
| Namespaces (1)
VB Script
| C#
| VB.Net
| Search on:Microsoft
Description Statistics related to SQL Server's buffer pool by NUMA node
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode properties Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode has 13 properties (4 Local , 9 Derived )
Detailed description of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode properties Local properties (4) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode class ▲ Databasepages propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Database pages on node.' DetailLevel 100 DisplayName 'Database pages' DisplayName009 'Database pages' HelpIndex 0 PerfDefault True PerfIndex 0 Databasepages property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ LocalnodepagelookupsPersec propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale -2 Description 'Number of lookup requests from this node which were satisfied from this node.' DetailLevel 100 DisplayName 'Local node page lookups/sec' DisplayName009 'Local node page lookups/sec' HelpIndex 0 PerfIndex 0 LocalnodepagelookupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Pagelifeexpectancy propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -1 Description 'Number of seconds a page will stay in the buffer pool without references.' DetailLevel 100 DisplayName 'Page life expectancy' DisplayName009 'Page life expectancy' HelpIndex 0 PerfIndex 0 Pagelifeexpectancy property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ RemotenodepagelookupsPersec propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale -2 Description 'Number of lookup requests from this node which were satisfied from other nodes.' DetailLevel 100 DisplayName 'Remote node page lookups/sec' DisplayName009 'Remote node page lookups/sec' HelpIndex 0 PerfIndex 0 RemotenodepagelookupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode class
▲ Name propertyCIMTYPE '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. ' key True MaxLen 256 read True Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local Description 'Statistics related to SQL Server's buffer pool by NUMA node' ✓ ✗ ✓ ✓ ✓ DetailLevel 100 ✓ ✗ ✓ ✗ ✓ DisplayName 'MSSQL$MICROSOFT##WID:Buffer Node' ✓ ✗ ✓ ✓ ✓ DisplayName009 'MSSQL$MICROSOFT##WID:Buffer Node' ✓ ✗ ✓ ✗ ✓ dynamic True ✓ ✗ ✓ ✗ ✓ GenericPerfCtr True ✓ ✗ ✓ ✗ ✓ HelpIndex 0 ✓ ✗ ✓ ✗ ✓ HiPerf True ✓ ✗ ✓ ✗ ✓ Locale 1033 ✓ ✗ ✓ ✓ ✓ PerfIndex 0 ✓ ✗ ✓ ✗ ✓ provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓ RegistryKey 'MSSQL$MICROSOFT##WID' ✓ ✗ ✓ ✗ ✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode System properties Similar Classes to Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBufferNode Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by