SP; search Query plan cache for issues, like table scans, missing indexes or stats

2014-03-02

Performance Plan cache Stored procedure

SP; search Query plan cache for issues, like table scans, missing indexes or stats, or any other command

What is the Used, Free and Reserved space per DB / LOG

2014-03-02

Dir, file or folder Disk Log Performance

What is the Used, Free and Reserved space per DB / LOG

Relative load per DB in CPU, IO and CLR

2014-03-01

CPU Disk Performance

What is the relative load per DB in CPU, IO and CLR?

Actual (sparse) file size on disk of a snapshot

2014-03-01

Dir, file or folder Disk Overview Snapshot

What is the actual (sparse) file size on disk of a snapshot?

Determine the page life expectancy per NUMA node

2014-03-01

Memory Overview Performance

Determine the page life expectancy per NUMA node (is it balanced?)

Disk usage per DB per Driveletter pivot

2014-03-01

Disk Performance

Displays the IO in bytes per database per drive [table id=3 /]

Diskspace Free and Total overview

2014-03-01

Disk Overview

Displays the free space,free space percentage plus total drive size for a server [table id=2 /]

CPU history (256 minutes)

2014-03-01

CPU Performance

Show the CPU load in last 256 minutes

Plan cache per DB

2014-03-01

Memory Performance Plan cache

How much memory each DB is using for sql plan cache?

Buffer cache per DB (Overview & Detailed)

2014-03-01

Buffer Memory Performance

Ever wondered how much memory each DB is using for buffering data? And in detail