Win32_PerfRawData_MSSQLSERVER_SQLServerExecStatistics, ROOT\cimv2 - Instances

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

Instances of Win32_PerfRawData_MSSQLSERVER_SQLServerExecStatistics

This section contains sample wmi instances of Win32_PerfRawData_MSSQLSERVER_SQLServerExecStatistics class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerExecStatistics.Name="Average execution time (ms)"

Properties={
   'Caption' : null
   'Description' : null
   'DistributedQuery' : '0' //String, 0x0
   'DTCcalls' : '0' //String, 0x0
   'ExtendedProcedures' : '0' //String, 0x0
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Average execution time (ms)' //String
   'OLEDBcalls' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634111930000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerExecStatistics.Name="Execs in progress"

Properties={
   'Caption' : null
   'Description' : null
   'DistributedQuery' : '0' //String, 0x0
   'DTCcalls' : '0' //String, 0x0
   'ExtendedProcedures' : '0' //String, 0x0
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Execs in progress' //String
   'OLEDBcalls' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634111930000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerExecStatistics.Name="Execs started per second"

Properties={
   'Caption' : null
   'Description' : null
   'DistributedQuery' : '0' //String, 0x0
   'DTCcalls' : '0' //String, 0x0
   'ExtendedProcedures' : '0' //String, 0x0
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Execs started per second' //String
   'OLEDBcalls' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634111930000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerExecStatistics.Name="Cumulative execution time (ms) per second"

Properties={
   'Caption' : null
   'Description' : null
   'DistributedQuery' : '0' //String, 0x0
   'DTCcalls' : '0' //String, 0x0
   'ExtendedProcedures' : '0' //String, 0x0
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Cumulative execution time (ms) per second' //String
   'OLEDBcalls' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634111930000' //String
}
comments powered by Disqus
WUtils.com