The Collection Service accesses the following WMI scopes to collect information.
|
Scope |
Descriptions |
|---|---|
|
\\<ComputerName>\root\default |
Used to access the registry on the remote server. |
|
\\<ComputerName>\root\cimv2 |
Used to collect performance information. |
|
\\<ComputerName>\root\Mi- crosoft\SqlServer\ComputerManagement10 |
Used to access the list of SQL Server instances. |
|
\\<ComputerName>\root\Mi- crosoft\SqlServer\ComputerManagement |
Used to access the list of SQL Server 2003 instances. |
|
\\<ComputerName>\root\mscluster |
Used on SQL Server cluster nodes to determine the active/passive node in the cluster. |
The Collection Service accesses the following WMI classes and fields on each server in the farm:
|
Item |
WMI Class |
Class Property |
|---|---|---|
|
Processor Interrupts per Second (Count) |
Win32_PerfRawData_PerfOS_Processor |
InterruptsPersec |
|
CPU Usage Total - Privileged Time (Percent) |
Win32_PerfRawData_PerfOS_Processor |
PercentPrivilegedTime |
|
CPU Usage Total (Percent) |
Win32_PerfRawData_PerfOS_Processor |
PercentProcessorTime |
|
CPU Usage Total - User Time (Percent) |
Win32_PerfRawData_PerfOS_Processor |
PercentUserTime |
|
Processor Queue Length (Count) |
Win32_PerfRawData_PerfOS_System |
ProcessorQueueLength |
|
CPU Usage - Per-Process Privileged Time (Percent) |
Win32_PerfRawData_PerfProc_Process |
PercentPrivilegedTime |
|
CPU Usage - Per-Process Total (Percent) |
Win32_PerfRawData_PerfProc_Process |
PercentProcessorTime |
|
CPU Usage - Per-Process User Time (Percent) |
Win32_PerfRawData_PerfProc_Process |
PercentUserTime |
|
Item |
WMI Class |
Class Property |
|---|---|---|
|
Disk Free Space (MB) |
Win32_PerfFormattedData_PerfDisk_LogicalDisk |
FreeMegabytes |
|
Disk Free Percent (Percent) |
Win32_PerfFormattedData_PerfDisk_LogicalDisk |
PercentFreeSpace |
|
Disk Used (Percent) |
Win32_PerfFormattedData_PerfDisk_LogicalDisk |
PercentFreeSpace |
|
Disk Idle Time (Percent) |
Win32_PerfFormattedData_PerfDisk_LogicalDisk |
PercentIdleTime |
|
Average Disk Seconds Per Read (ms) |
Win32_PerfRawData_PerfDisk_LogicalDisk |
AvgDisksecPerRead |
|
Average Disk Seconds Per Transfer (ms) |
Win32_PerfRawData_PerfDisk_LogicalDisk |
AvgDisksecPerTransfer |
|
Average Disk Seconds Per Write (ms) |
Win32_PerfRawData_PerfDisk_LogicalDisk |
AvgDisksecPerWrite |
|
Disk Size (MB) |
Win32_PerfRawData_PerfDisk_LogicalDisk |
PercentFreeSpace_Base |
|
Average Disk Queue Length (Count) |
Win32_PerfRawData_PerfDisk_PhysicalDisk |
AvgDiskQueueLength |
|
Disk Reads Per Second (Count) |
Win32_PerfRawData_PerfDisk_PhysicalDisk |
DiskReadsPersec |
|
Disk Writes Per Second (Count) |
Win32_PerfRawData_PerfDisk_PhysicalDisk |
DiskWritesPersec |
|
Disk Time (Percent) |
Win32_PerfRawData_PerfDisk_PhysicalDisk |
PercentDiskTime |
