Includes&Samples |
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWaitStatistics, ROOT\cimv2 - InstancesClass | Methods | Properties (21) | Qualifiers (14) | Instances (4) | Namespaces (1)Samples: VB Script | C# | VB.Net | Search on:Microsoft Instances of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWaitStatisticsThis section contains sample wmi instances of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWaitStatistics class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation. Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWaitStatistics.Name="Average wait time (ms)"Properties={ 'Caption' : null 'Description' : null 'Frequency_Object' : null 'Frequency_PerfTime' : null 'Frequency_Sys100NS' : null 'Lockwaits' : '0' //String, 0x0 'Logbufferwaits' : '0' //String, 0x0 'Logwritewaits' : '0' //String, 0x0 'Memorygrantqueuewaits' : '0' //String, 0x0 'Name' : 'Average wait time (ms)' //String 'NetworkIOwaits' : '0' //String, 0x0 'NonPagelatchwaits' : '0' //String, 0x0 'PageIOlatchwaits' : '0' //String, 0x0 'Pagelatchwaits' : '0' //String, 0x0 'Threadsafememoryobjectswaits' : '0' //String, 0x0 'Timestamp_Object' : null 'Timestamp_PerfTime' : null 'Timestamp_Sys100NS' : null 'Transactionownershipwaits' : '0' //String, 0x0 'Waitfortheworker' : '0' //String, 0x0 'Workspacesynchronizationwaits' : '0' //String, 0x0 } Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWaitStatistics.Name="Waits in progress"Properties={ 'Caption' : null 'Description' : null 'Frequency_Object' : null 'Frequency_PerfTime' : null 'Frequency_Sys100NS' : null 'Lockwaits' : '0' //String, 0x0 'Logbufferwaits' : '0' //String, 0x0 'Logwritewaits' : '0' //String, 0x0 'Memorygrantqueuewaits' : '0' //String, 0x0 'Name' : 'Waits in progress' //String 'NetworkIOwaits' : '0' //String, 0x0 'NonPagelatchwaits' : '0' //String, 0x0 'PageIOlatchwaits' : '0' //String, 0x0 'Pagelatchwaits' : '0' //String, 0x0 'Threadsafememoryobjectswaits' : '0' //String, 0x0 'Timestamp_Object' : null 'Timestamp_PerfTime' : null 'Timestamp_Sys100NS' : null 'Transactionownershipwaits' : '0' //String, 0x0 'Waitfortheworker' : '0' //String, 0x0 'Workspacesynchronizationwaits' : '0' //String, 0x0 } Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWaitStatistics.Name="Waits started per second"Properties={ 'Caption' : null 'Description' : null 'Frequency_Object' : null 'Frequency_PerfTime' : null 'Frequency_Sys100NS' : null 'Lockwaits' : '0' //String, 0x0 'Logbufferwaits' : '0' //String, 0x0 'Logwritewaits' : '0' //String, 0x0 'Memorygrantqueuewaits' : '0' //String, 0x0 'Name' : 'Waits started per second' //String 'NetworkIOwaits' : '0' //String, 0x0 'NonPagelatchwaits' : '0' //String, 0x0 'PageIOlatchwaits' : '0' //String, 0x0 'Pagelatchwaits' : '0' //String, 0x0 'Threadsafememoryobjectswaits' : '0' //String, 0x0 'Timestamp_Object' : null 'Timestamp_PerfTime' : null 'Timestamp_Sys100NS' : null 'Transactionownershipwaits' : '0' //String, 0x0 'Waitfortheworker' : '0' //String, 0x0 'Workspacesynchronizationwaits' : '0' //String, 0x0 } Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWaitStatistics.Name="Cumulative wait time (ms) per second"Properties={ 'Caption' : null 'Description' : null 'Frequency_Object' : null 'Frequency_PerfTime' : null 'Frequency_Sys100NS' : null 'Lockwaits' : '0' //String, 0x0 'Logbufferwaits' : '0' //String, 0x0 'Logwritewaits' : '0' //String, 0x0 'Memorygrantqueuewaits' : '0' //String, 0x0 'Name' : 'Cumulative wait time (ms) per second' //String 'NetworkIOwaits' : '0' //String, 0x0 'NonPagelatchwaits' : '0' //String, 0x0 'PageIOlatchwaits' : '0' //String, 0x0 'Pagelatchwaits' : '0' //String, 0x0 'Threadsafememoryobjectswaits' : '0' //String, 0x0 'Timestamp_Object' : null 'Timestamp_PerfTime' : null 'Timestamp_Sys100NS' : null 'Transactionownershipwaits' : '0' //String, 0x0 'Waitfortheworker' : '0' //String, 0x0 'Workspacesynchronizationwaits' : '0' //String, 0x0 } |