Performance | Overview

A graphical report summarizing the performance of the server. Covers CPU, memory, I/O, tempdb and waits.

What It Shows

Comments

CPU history

A chart of CPU usage over the last hour (or less if the service has been restarted within the hour)

Memory allocation

A bar chart showing how much memory is used by database pages, stolen pages, and free pages

Page life expectancy

The number of seconds that a database page remains in cache before being flushed. Higher values are better. See thresholds for the calculation that is used to determine highlighting of this metric in orange or red

Non-buffer pool memory

The amount of memory that is used outside the buffer pool

Connection memory

Memory being used to manage connections

Optimizer memory memory

Memory that is used during query optimization

Lock memory

Mmory that is used by the lock manager

Granted workspace memory

Memory granted to currently executing processes

Memory grants outstanding

Number of processes that have acquired a workspace memory grant

Memory grants pending

Number of processes waiting for a workspace memory grant

SQL cache memory

Memory used by the dynamic cache for compiled execution plans

Average pages per second

A chart showing the average number of page reads, page writes and readahead pages per second. These are averages since the service was last restarted

Average I/O

A chart showing the average data read, data write and log write duration in ms. These are taken from the virtual file stats, and are averages since the service was last restarted

Current waits

A bar chart showing the top 5 waits for currently waiting processes

Total tempdb size

The combined size of all the tempdb files

Active temp tables

The number of temporary tables currently in tempdb

tempdb space

A chart showing a breakdown of tempdb usage into user objects, internal objects, version store and mixed extents