4 Microsoft SQL Server Reports

This chapter provides a list of out-of-box reports available for System Monitoring Plug-In for Microsoft SQL Server.

Table 4-1 Microsoft SQL Server Reports

Report Name Report Elements

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

Figure 4-1 shows the System Performance report available for Microsoft SQL Server:

Figure 4-1 Microsoft SQL Server System Performance Report