WMI-specific built-In metrics
The following metric classes can only be polled using WMI. The WMI-specific metric classes are:
• Domain controller
• IIS Webservice
• Microsoft message queuing
• SQL server
• Windows Services
• Windows System
• SharePoint ASP.NET
• SharePoint SQL databases
• SharePoint SQL statistics
• SharePoint SQL locks
• SharePoint SQL latches
• SharePoint SQL plan cache
• SharePoint search
• SharePoint search indexer
Domain controller
WMI-specific metrics from the domain controller class indicate the number of DS threads in use, how long the LDAP server takes to bind to a client, and how many LDAP client sessions are active.
Metric name
Description
Units
Alertable
timestamp
Time of metric data retrieval.
milliseconds
No
DS Threads in Use
Current number of threads in use by the directory service. Can be used to indicate whether additional processors could be of benefit.
—
Yes
LDAP Bind Time
Time taken for last successful LDAP bind.
milliseconds
Yes
LDAP Client Sessions
Number of connected LDAP client sessions.
—
Yes
IIS Webservice
Include this metric class in any polling profile that intends to poll all SharePoint metrics.
WMI-specific metrics from the IIS Webservice class give information on IIS processing requests and connections.
Metric name
Description
Units
Alertable
timestamp
Time of metric data retrieval.
milliseconds
No
Name
Name of the web service.
—
No
Total Method Requests/Sec
Rate at which all HTTP requests are made per second.
seconds
Yes
Current Connections
Current number of connections established with the web service.
—
Yes
Bytes Received/Sec
Rate at which the web service receives bytes.
seconds
Yes
Bytes Sent/Sec
Rate at which the web service sends bytes.
seconds
Yes
Microsoft message queuing
WMI-specific metrics from the Microsoft Message Queuing class give information on messages waiting in the queue.
Metric name
Description
Units
Alertable
timestamp
Time of metric data retrieval.
milliseconds
No
Name
Name of the queue.
—
No
Total Number of Messages in Queue
Number of messages currently waiting in the queue.
counts
Yes
Total Bytes in Queue
Total number of bytes in queue.
bytes
Yes
SQL server
WMI-specific metrics from the SQL Server class give information about database transactions occurring in SQL Server.
Metric name
Description
Units
Alertable
timestamp
Time of metric data retrieval.
milliseconds
No
Active Transactions
Number of active update transactions for the database.
counts
Yes
Transactions/sec
Number of transactions started for the database.
counts
Yes
Index Searches/sec
Number of index searches. Index searches are used to start range scans and single index record fetches as well as to reposition within an index.
counts
Yes
Full Scans/sec
Number of unrestricted full scans. These can either be base table or full index scans.
counts
Yes
FreeSpace Scans/sec
Number of scans per second that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragments. Each scan may find multiple pages.
counts
Yes
Pages Allocated/sec
Number of pages allocated per second in all databases in this SQL Server instance, including pages allocations from both mixed extents and uniform extents.
counts
Yes
Paged Splits/sec
Number of page splits per second that occur as a result of overflowing index pages.
counts
Yes
Scan Point Revalidations/sec
Number of times the scan point had to be revalidated to continue the scan.
counts
Yes
Windows Services
WMI-specific metrics from the Windows Services class provide information about services, their status, state, operational status, startup type, and process ID. These metrics also indicate who started the service. To work with this metric class you must have WMI credentials with administrative privileges.
Metric name
Description
Units
Alertable
timestamp
Time of metric data retrieval.
milliseconds
No
Service Identifier
Unique identifier of the service.
—
No
Path to Service
Fully qualified path to the binary file that implements the service.
—
No
Name
Display name of the service. Some services you might see:
• Network Provisioning Service
• Wireless Configuration
• Automatic Updates
• WMI Performance Adapter
• Windows Management Instrumentation Driver Extensions
• Portable Media Serial Number Service
• WinHTTP Web Proxy Auto-Discovery Service
—
No
Status
Indication of whether service has been started.
—
No
Status ID
Indication of whether service has been started.
—
Yes
Current State
Current state of the base service. See Current State ID for values.
—
No
Current State ID
Numeric equivalent of the current state of the base service. Values: Stopped = 1, StartPending = 2, StopPending = 3, Running = 4. ContinuePending = 5, PausePending = 6, Paused = 7, Unknown = 8.
—
Yes
Operational Status
Current operational status of the object. See Operational Status ID for values.
—
No
Operational Status ID
Numeric equivalent of the Current operational status of the object. Values: OK = 1, Error = 2, Degraded = 3, Unknown = 4. PredFail = 5, Starting = 6, Stopping = 7, Service = 8.
—
Yes
Startup Type
Start mode of the Windows base service. See Startup Type ID for values.
—
No
Startup Type ID
Numeric equivalent of the start mode of the Windows base service. Boot = 1, System = 2, Manual = 3, Auto = 4. Disabled = 5, Unknown = 6.
—
Yes
Process ID
Process identifier of the service. If it is not running, the value is 0.
—
Yes
Log On As
Account name under which a service runs. Can also be LocalSystem, NT Authority\LocalService.
—
No
Windows System
WMI-specific metrics from the Windows System class provide information about windows systems processes, queue lengths, processing of read and write operations, context switches, threads, system calls, and commands being processed.
Metric name
Description
Units
Alertable
timestamp
Time of metric data retrieval.
milliseconds
No
System Up Time
Elapsed time that the computer has been running after it was last started.
seconds
Yes
Process Count
Number of processes in the computer at the time of data collection.
counts
Yes
Processor Queue Length
Number of threads in the processor queue.
counts
Yes
File Read Operations/Sec
Combined rate of all file system read requests to all devices on the computer, including requests to read from the file system cache.
seconds
Yes
File Write Operations/Sec
Combined rate of all file system write requests to all devices on the computer, including requests to write to data in the file system cache.
seconds
Yes
Context Switches/Sec
Rate of switches from one thread to another. Thread switches can occur either inside of a single process or across processes.
seconds
Yes
Threads
Number of threads in the computer.
counts
Yes
System Calls/Sec
Combined rate of calls to Windows system service routines by all processes running on the computer.
seconds
Yes
Current Commands
Number of requests to the LAN Redirector that are currently queued for service.
counts
Yes
Current Commands
Number of requests to the LAN Redirector that are currently queued for service.
counts
Yes
SharePoint ASP.NET
This metric class is in the Web tier of SharePoint.
Metric name
Description
Units
Alertable
Cache Total Entries
Number of ASP Cache Total Entries.
counts
Yes
Cache Total Hits
Number of ASP Cache Hits.
counts
Yes
Cache Total Misses
Number of ASP Cache Misses.
counts
Yes
Request Execution Time
ASP Request Execution Time.
milliseconds
Yes
Requests Rejected
Number of IIS Requests Rejected (Count).
counts
Yes
Request Wait Time
ASP Request Wait Time.
milliseconds
Yes
Requests Per Sec
Number of IIS Requests Per Second.
counts
Yes
Total Requests
Total number of requests from service start.
counts
Yes
Requests Executing
Number of currently executing requests.
counts
Yes
Application Restarts
Number of ASP Application Restarts.
counts
Yes
Current Number of Requests
Number of ASP Requests Executing.
counts
Yes
Queued Requests
Number of IIS Requests Queued.
counts
Yes
Worker Process Restarts
Number of ASP Worker Process Restarts.
counts
Yes
SharePoint SQL databases
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
Name
Name of the database.
—
No
Active Transactions
Number of active update transactions for the database.
counts
Yes
Transactions Per Sec
Number of transactions started for the database.
counts
Yes
Log Cache Hit Ratio
Percentage of log cache reads that were satisfied from the log cache.
%
Yes
Log Files Size
Cumulative size of all the log files in the database.
kilobytes
Yes
Log Transactions
Total number of log truncations for this database.
counts
Yes
Percent Log Used
Percentage of space in the log that is in use.
%
Yes
Write Transactions Per sec
Number of transactions which wrote to the database in the last second.
counts
Yes
Log Cache Reads Per sec
Number of reads performed through the log manager cache.
counts
Yes
Log Bytes Flushed Per sec
Total number of log bytes flushed.
bytes/
second
Yes
Backup Per Restore Throughput Per sec
Read/Write throughput for backup/restore of a database.
—
Yes
Bulk Copy Rows Per Sec
Number of rows bulk copied.
counts
Yes
Bulk Copy Through put Per sec
KiloBytes bulk copied.
kilobytes/
second
Yes
Log File Used Size
Cumulative used size of all the log files in the database.
kilobytes
Yes
Log Flushes Per sec
Number of log flushes.
counts
Yes
Log Flush Waits Per sec
Number of commits waiting on log flush.
counts
Yes
Log Flush Wait Time
Total Wait time.
milliseconds
Yes
Log Growths
Total number of log growths for this database.
counts
Yes
Log Shrinks
Total number of log shrinks for this database.
counts
Yes
SharePoint SQL statistics
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
SQL Compilations Per Sec
Number of compilations per second.
counts
Yes
SQL Re-Compilation Per Sec
Number of recompilation per second.
counts
Yes
Batch Requests Per Sec
Number of SQL batch requests received by server.
counts
Yes
User Connections
Number of users connected to the system.
users
Yes
Number of transactions
Number of transaction enlistments (local, DTC, and bound).
counts
Yes
Connections resets per sec
Total number of connection resets per second.
counts
Yes
Logical Connections
Number of logical connections to the system.
counts
Yes
Login Per Sec
Total number of logins started per second.
counts
Yes
Logouts Per Sec
Total number of logouts started per second.
counts
Yes
Blocked Processes
Number of currently blocked processes.
counts
Yes
SharePoint SQL locks
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
Name
Name of the database.
—
No
Deadlocks/Sec
Number of lock requests that resulted in a deadlock.
counts
Yes
Average Wait Time
Average amount of wait time for each lock requests that resulted in a wait.
milliseconds
Yes
Lock Waits/Sec
Number of lock requests that forced caller to wait.
counts
Yes
Lock Requests/Sec
Number of new locks and lock conversions requested from the lock manager.
counts
Yes
Lock Wait Time
Total wait time for locks in the last second.
milliseconds
Yes
Lock Timeout(Including NOWAIT Locks)/Sec
Number of lock requests that timed out. This includes requests for NOWAIT locks
counts
Yes
Lock Timeout(excluding NOWAIT Locks)/Sec
Number of lock requests that timed out. This does not include requests for NOWAIT locks
counts
Yes
SharePoint SQL latches
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
Name
Name.
—
No
Average Latch Wait Time
Average latch wait time in ms for latch requests that had to wait.
milliseconds
Yes
Latch Waits
Number of lock requests that required a wait before being granted.
counts
Yes
Super Latches
Number of latches that are currently SuperLatches.
counts
Yes
Super Latches Demotions
Number of SuperLatches that have been demoted to regular latches.
counts
Yes
Super Latches Promotions
Number of latches that have been prompted to SuperLatches.
counts
Yes
Total Latch Wait Time
Total latch wait time for latch requests that had to wait in the last second.
milliseconds
Yes
SharePoint SQL plan cache
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
Name
Name of the database.
—
No
Cache Hit Ratio
Ratio between cache hits and lookups.
ratio
Yes
Cache Object Counts
Number of cache objects in the cache.
counts
Yes
Cache Objects in use
Number of cache objects in use.
counts
Yes
Cache Pages
Number of 8k pages used by cache objects.
counts
Yes
SharePoint search
This metric class is in the Application tier of SharePoint.
Metric name
Description
Units
Alertable
Blocked Documents
Number of documents waiting for a queue.
counts
Yes
Name
Name of the search application.
—
No
Documents Processed
Number of documents processed per second.
counts
Yes
Retries Rate
Number of retries per second.
counts
Yes
Transaction Waiting
Number of documents waiting to be processed. When this number goes to zero the catalog is idle. This number indicates the total queue size of unprocessed documents in the gatherer.
counts
Yes
Transaction In Progress
Number of documents in progress.
counts
Yes
Idle Threads
Number of threads waiting for documents. (_Total?)
counts
Yes
SharePoint search indexer
This metric class is in the Application tier of SharePoint.
Metric name
Description
Units
Alertable
Active Connections
Number of active connections.
counts
Yes
Documents Filtered
Number of documents filtered.
counts
Yes
Index Size
Size of index.
 
Yes
Failed Queries
Number of queries failed.
counts
Yes
Succeeded Queries
Number of queries succeeded.
counts
Yes