MS SharePoint Server Unified Dashboard

The SharePoint Unified Dashboard provides predefined list views with information about your SharePoint server, such as CPU Performance and Memory usage, network utilization, disk usage and performance, and SQL server statistics.
uim901
sharepoint_server_UD
The SharePoint Unified Dashboard provides predefined list views with information about your SharePoint server, such as CPU Performance and Memory usage, network utilization, disk usage and performance, and SQL server statistics.
Contents
If your Unified Dashboard is not populating with data, make sure all required data sources for the Unified Dashboard are enabled. The required probe must be deployed and must be configured so that required QoS metrics and subkeys or targets are activated. For more information, see the help topic on required data sources for the Unified Dashboard.
SharePoint Required Data Sources
This table lists the probes, QoS metrics, and subkeys or targets that must be activated to populate data in the SharePoint dashboard.
Probe
QoS Required
Subkey/Target
sharepoint
QOS_%_PROCESSOR_TIME
MOSS2007 - CPU Total Processor Time_%Processor Time
QOS_PROCESSOR_QUEUE_LENGTH
MOSS2007 - Processor Queue Length_Processor Queue Length
QOS_BYTES_TOTAL/SEC
MOSS2007 - Network Interface - Total Bytes_Bytes Total/sec
QOS_BYTES_SENT/SEC
MOSS2007 - Network Interface - Bytes Sent_Bytes sent/sec
QOS_BYTES_RECEIVED/SEC
MOSS2007 - Network Interface - Bytes Received_Bytes Received/sec
QOS_PACKETS_OUTBOUND_ERRORS
MOSS2007 - Network Interface - Packets Outbound errors_Packets Outbound Errors
QOS_%_USAGE
MOSS2007 - Paging File: %Usage_%Usage
QOS_%_USAGE_PEAK
MOSS2007 - Paging File: %Usage Peak_%Usage Peak
QOS_AVAILABLE_MBYTES
MOSS2007 - Availability of Memory in Bytes_Available
QOS_PAGES/SEC
MOSS2007 - Memory_Pages Per Second_Pages/sec
QOS_CACHE_FAULTS/SEC
MOSS2007 - Cache Faults Per Sec_Cache Faults/sec
QOS_PAGE_FAULTS/SEC
MOSS2007 - Page Faults Per Second_Page Faults/sec
QOS_BUFFER_CACHE_HIT_RATIO
MOSS2007 - SQL Server: Buffer Manager - Buffer Cache Hit Ratio_Buffer cache hit ratio
QOS_CACHE_HIT_RATIO
MOSS2007 - SQL Server: Cache Hit Ratio_Cache Hit Ratio
QOS_LATCH_WAITS/SEC
MOSS2007 - SQL Server: Latch Waits/sec_Latch Waits/sec
QOS_NUMBER_OF_DEADLOCKS/SEC
MOSS2007 - SQL Server: Number of Deadlocks/sec_Number of Deadlocks/sec
QOS_USER_CONNECTIONS
MOSS2007 - SQL Server: User Connections_User Connections
QOS_BYTES_SENT/SEC
MOSS2007 - Web Service - Bytes Sent Per Second_Bytes Sent/sec
QOS_CURRENT_CONNECTIONS
MOSS2007 - Web Service_Current Connections
QOS_CONNECTION_ATTEMPTS/SEC
MOSS 2007 - Web Service Connection Attempts_Connection Attempts/sec
QOS_%_PROCESSOR_TIME
MOSS2007 - Process - W3WP Processor Time_%Processor Time
QOS_WORKING_SET
MOSS2007 - Process - W3WP Working Set_Working Set
QOS_REQUESTS_EXECUTING
MOSS2007 - ASP.NET Applications - Requests Executing_Requests Executing
QOS_REQUEST_WAIT_TIME
MOSS2007 - ASP.NET Applications - Requests Wait Time_Request Wait Time
QOS_REQUESTS/SEC
MOSS2007 - ASP.NET Applications_Requests/sec
QOS_REQUESTS_REJECTED
MOSS2007 - ASP.NET Applications - Requests Rejected_requests Rejected
CPU Performance
Column
Description
Host
Name of the host where the SharePoint server is installed.
Processor Time Perc
Percentage of elapsed time the processor spends to execute a non-idle thread.
0 to 70 = Green
71 to 79 = Yellow
80 to 100 = Red
Processor Queue Length
If the threshold of this rule is exceeded, the processor is not fast enough.
Memory Usage and Performance
Column
Description
Host
Name of the host where the SharePoint server is installed.
Paging File Perc Usage and Perc used Peak
The server paging file, sometimes called the swap file, holds virtual memory addresses on disk. Page faults occur when a process has to stop and wait while required virtual resources are retrieved from disk into memory.
Page faults are more frequent if physical memory is inadequate.
Avail MB
Amount of physical memory, in megabytes, immediately available for allocation to a process or for system use.
Insufficient memory leads to excessive use of the page file and an increase in the number of page faults per second.
Pages/sec
Rate at which the pages are read from or written to disk to resolve hard page faults. A large number indicates system-wide performance problems.
0 to 7 = Green
8 to 9 = Yellow
10 = Red
Cache Faults/sec
Rate at which faults occur when a page is sought in the file system cache and is not found. This may be a soft fault when the page is found in memory or a hard fault when the page is on the disk.
0.0 to 0.99 = Green
1.0 = Red
Page Faults/sec
Number of times data was not found in memory. It measures the average number of pages faulted per second.
ASP.NET
Column
Description
Host
Name of the host where the SharePoint server is installed.
Requests Executing
Number of requests currently executing.
Request Wait Time
Number of milliseconds that the most recent request waited in the queue for processing. As the number of wait events increases, users experience degraded page-rendering performance.
Requests/sec
Number of requests executed per second. This represents the current throughput of the application. Under constant load, this number should remain within a certain range, barring other server work (such as garbage collection, cache cleanup thread, external server tools, and so on).
Req Queued
Number of requests waiting to be processed.
0 to 300 = Green
301 to 500 = Yellow
501 = Red
Requests Rejected
Total number of requests not executed because of insufficient server resources to process them. This counter represents the number of requests that return a 503 HTTP status code, indicating the server is too busy.
Network Utilization
Column
Description
Host
Name of the host where the SharePoint server is installed.
Bytes Total/sec
Rate at which the data is sent and received via the Network Interface Card.
0 to 39.9 = Green
40.0 to 49.9 = Yellow
50.0 = Red
Bytes Recd/sec
Rate at which data bytes are received by the web service.
Bytes Sent/sec
Rate at which data bytes are sent by the web service.
Packet Outbound Errors
Number of outbound packets that could not be transmitted because of errors.
Disk Usage and Performance
Column
Description
Host
Name of the host where the SharePoint server is installed.
Writes/sec
Number of writes to disk per second.
Reads/sec
Number of reads to disk per second.
Perc Idle Time
Percentage of time the disk system was not processing requests and no work was queued.
Avg Write Q Length
Average number of write requests that are queued.
Avg Read Q Length
Average number of read requests that are queued.
Avg Disk sec/Transfer
Number of read and writes completed per second, regardless of how much data they involve.
SQL Server Statistics
Column
Description
Host
Name of the host where the SharePoint server is installed.
Buffer Cache Hit Ratio
Percentage of pages found in the buffer cache without having to read from disk.
The ratio is the total number of cache hits divided by the total number of cache lookups since an instance of SQL Server was started.
0.0 to 60.9 = Red
61.0 to 89.0 = Yellow
90.0 = Green
Cache Hit Ratio
Ratio between cache hits and lookups for plans.
Latch Waits/sec
Number of latch requests per second that could not be granted immediately.
Deadlocks/sec
Number of deadlocks on the SQL Server per second.
User Connections
Number of user connections on your instance of SQL Server.
W3WP Process
Column
Description
Host
Name of the host where the SharePoint server is installed.
Proc Time Perc
Percent of elapsed time that all process threads use the processor.
0.0 to 49.0 = Green
49.1 to 74.9 = Yellow
75.0 = Red
Working Set
The set of memory pages recently touched by the threads in the process.
0 to 79.0 = Green
80.0 = Red
Web Front End Server
Column
Description
Host
Name of the host where the SharePoint server is installed.
Bytes Sent/sec
Rate at which data bytes are sent by the web service.
Current Connections
Monitors current IIS connections.
Connection Attempts
Rate at which connections to the web service are attempted.