4. Monitoring Template

This chapter describes the monitoring template for PFM - RM for Microsoft SQL Server.

Organization of this chapter
Overview of the monitoring template
Format of alarm explanations
List of alarms
Blocked Sessions
Cache Usage
CPU Usage
Database Space
Log Space Usage
Network Error
Server Status
Format of report explanations
Organization of report folders
List of reports
Blocked Sessions
Blocking Locks
Cache Usage
Cache Usage Trend(Multi-Agent) (historical report past 24 hours)
Cache Usage Trend(Multi-Agent) (historical report past month)
CPU Usage - Top 10 Sessions
Database Detail
Database Space Usage
Database Space Usage Detail
Database Summary
Lock Detail
Lock Overview
Lock Overview by Lock Type
Lock Usage - Top 10 Sessions
Log I/O Activity
Log Space Usage - Top 10 Databases
Memory Usage - Top 10 Sessions
Network Activity
Network Activity Trend (historical report past 24 hours)
Network Activity Trend (historical report past month)
Pending I/O
Physical I/O - Top 10 Sessions
Physical Write Activity
Server Configuration Status
Server CPU Trend (historical report past 24 hours)
Server CPU Trend (historical report past month)
Server Space Trend(Multi-Agent) (historical report past 24 hours)
Server Space Trend(Multi-Agent) (historical report past month)
Server Space Usage
Session Detail
Sessions
System Overview