Microsoft SQLServer System Configuration

• Instance Information

• Registry

• Security

• Server Parameters

Microsoft SQLServer System Database Configuration

• Database

• Database Settings

Microsoft SQLServer System Memory Statistics

• Server Statistics

• Buffer Cache Hit Ratio (%)

• Cache Hit Ratio (%)

• Average Latch Wait Time (ms)

• Total Lock Wait Time (ms)

Microsoft SQLServer System Space Usage

• Database Space Usage

• Top 5 Databases by Space Used (%)

• Database Files

Microsoft SQLServer System Performance

• Host CPU load percentage

• Top SQL Server Processes by CPU Time

• Memory Manager

• Top Server Processes by Memory Usage

Microsoft SQLServer System Process Info and Locks

• Summary

• Process States

• Process Info

• Process Locks

• Lock Analysis

Microsoft SQLServer System Cache and Buffer

• Memory Status

• Buffer Performance

• Buffer Allocation

• Cache Performance

• Memory Allocation

• Memory Allocation Chart

Microsoft SQLServer System Database Backups and Jobs

• Database Backups

• Database Jobs

Microsoft SQLServer System Cluster

• Cluster Nodes Summary

• Nodes in Cluster

• SQL Cluster Nodes Summary

• Cluster Resources and Activity

Microsoft SQLServer System Statistics

• Server Statistics

• Rate of Errors

• Packet Error Ratio

• Rate of Reads

• Rate of Writes

• Database Statistics

• Database Statistics Summary

• Server Statistics

Microsoft SQLServer Session Performance

• Top 5 Sessions by CPU Time

• Top 5 Sessions by Memory Utilization

Microsoft SQLServer Query Performance

• Top 5 Queries by Execution

• Top 5 Queries by Blocked Time

• Top 5 Queries by CPU Time