Built-In Metrics : WMI-specific built-In metrics
  
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
WMI-specific metrics from the IIS Webservice class give information on IIS processing requests and connections.
Include this metric class in any polling profile that intends to poll all SharePoint metrics.
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.
—
Yes
Current Connections
Current number of connections established with the web service.
—
Yes
Bytes Received/Sec
Rate at which the web service receives bytes.
—
Yes
Bytes Sent/Sec
Rate at which the web service sends bytes.
—
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.
—
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.
—
Yes
Transactions/sec
Number of transactions started for the database.
—
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.
—
Yes
Full Scans/sec
Number of unrestricted full scans. These can either be base table or full index scans.
—
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.
—
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.
—
Yes
Paged Splits/sec
Number of page splits per second that occur as a result of overflowing index pages.
—
Yes
Scan Point Revalidations/sec
Number of times the scan point had to be revalidated to continue the scan.
—
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.
—
Yes
Processor Queue Length
Number of threads in the processor queue.
—
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.
—
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.
—
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.
—
Yes
Threads
Number of threads in the computer.
—
Yes
System Calls/Sec
Combined rate of calls to Windows system service routines by all processes running on the computer.
—
Yes
Current Commands
Count of the requests to the LAN Redirector that are currently queued for service.
—
Yes
Current Commands
Count of the requests to the LAN Redirector that are currently queued for service.
—
Yes
SharePoint ASP.NET
This metric class is in the Web tier of SharePoint.
Metric name
Description
Units
Alertable
Cache Total Entries
ASP Cache Total Entries (Count).
—
Yes
Cache Total Hits
ASP Cache Hits (Count).
—
Yes
Cache Total Misses
ASP Cache Misses (Count).
—
Yes
Request Execution Time
ASP Request Execution Time (ms).
milliseconds
Yes
Requests Rejected
IIS Requests Rejected (Count).
—
Yes
Request Wait Time
ASP Request Wait Time (ms).
milliseconds
Yes
Requests Per Sec
IIS Requests Per Second (Count).
—
Yes
Total Requests
Total Requests from service start.
—
Yes
Requests Executing
Currently executing requests.
—
Yes
Application Restarts
ASP Application Restarts (Count).
—
Yes
Current Number of Requests
ASP Requests Executing (Count).
—
Yes
Queued Requests
IIS Requests Queued (Count).
—
Yes
Worker Process Restarts
ASP Worker Process Restarts (Count).
—
Yes
SharePoint SQL databases
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
Name
—
—
—
Active Transactions
Number of active update transactions for the database.
—
Yes
Transactions Per Sec
Number of transactions started for the database.
—
Yes
Log Cache Hit Ratio
Percentage of log cache reads that were satisfied from the log cache.
%
Yes
Log Files Size
The cumulative size of all the log files in the database.
kilobytes
Yes
Log Transactions
Total number of log truncations for this database.
—
Yes
Percent Log Used
The percent 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.
—
Yes
Log Cache Reads Per sec
Reads performed through the log manager cache.
—
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.
—
Yes
Bulk Copy Through put Per sec
KiloBytes bulk copied.
kilobytes/
second
Yes
Log File Used Size
The cumulative used size of all the log files in the database.
kilobytes
Yes
Log Flushes Per sec
Number of log flushes.
—
Yes
Log Flush Waits Per sec
Number of commits waiting on log flush.
—
Yes
Log Flush Wait Time
Total Wait time in ms.
milliseconds
Yes
Log Growths
Total Number of log growths for this database.
—
Yes
Log Shrinks
Total number of log shrinks for this database.
—
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.
—
Yes
SQL Re-Compilation Per Sec
Number of recompilation per second.
—
Yes
Batch Requests Per Sec
Number of SQL batch requests received by server.
—
Yes
User Connections
Number of users connected to the system.
users
Yes
Number of transactions
Number of transaction enlistments (local, dtc, and bound).
—
Yes
Connections resets per sec
Total number of connection resets per second.
—
Yes
Logical Connections
Number of logical connections to the system.
—
Yes
Login Per Sec
Total number of logins started per second.
—
Yes
Logouts Per Sec
Total number of logouts started per second.
—
Yes
Blocked Processes
Number of currently blocked processes.
—
Yes
SharePoint SQL locks
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
Name
Name
—
Yes
Deadlocks/Sec
Number of lock requests that resulted in a deadlock.
—
Yes
Average Wait Time
The average amount of wait time (ms) for each lock requests that resulted in a wait.
milliseconds
Yes
Lock Waits/Sec
Number of lock requests that forced caller to wait.
—
Yes
Lock Requests/Sec
Number of new locks and lock conversions requested from the lock manager.
—
Yes
Lock Wait Time
Total wait time (ms) 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
 
Yes
Lock Timeout(excluding NOWAIT Locks)/Sec
Number of lock requests that timed out. This does not include requests for NOWAIT locks
 
Yes
SharePoint SQL latches
This metric class is in the Database tier of SharePoint.
Metric name
Description
Units
Alertable
Name
Name.
 
Yes
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.
 
Yes
Super Latches
Number of latches that are currently SuperLatches.
 
Yes
Super Latches Demotions
Number of SuperLatches that have been demoted to regular latches.
 
Yes
Super Latches Promotions
Number of latches that have been prompted to SuperLatches.
 
Yes
Total Latch Wait Time
Total latch wait time (ms) 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
 
 
Cache Hit Ratio
Ratio between cache hits and lookups.
ratio
Yes
Cache Object Counts
Number of cache objects in the cache.
 
Yes
Cache Objects in use
Number of cache objects in use.
 
Yes
Cache Pages
Number of 8k pages used by cache objects.
 
Yes
SharePoint search
This metric class is in the Application tier of SharePoint.
Metric name
Description
Units
Alertable
Blocked Documents
The number of documents waiting for a queue.
 
Yes
Name
Name.
 
No
Name
Name.
 
No
Documents Processed
The number of documents processed per second.
 
Yes
Retries Rate
The number of retries per second.
 
Yes
Transaction Waiting
The 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.
 
Yes
Transaction In Progress
The number of documents in progress.
 
Yes
Idle Threads
The number of threads waiting for documents. (_Total?)
 
Yes
SharePoint search indexer
This metric class is in the Application tier of SharePoint.
Metric name
Description
Units
Alertable
Active Connections
Active connections.
 
Yes
Documents Filtered
Number of documents filtered.
 
Yes
Index Size
Size of index.
 
Yes
Failed Queries
Number of queries failed.
 
Yes
Succeeded Queries
Number of queries succeeded.
 
Yes