Database monitoring elements.
Discovery and inventory: Server inventory, SQL version, available space,
configuration settings, database inventory, SQL jobs, backup history,
inventory reporting, physical inventory, user setting, inventor altering,
discover instances, and virtual inventory.
Health checks: Performance metrics, index optimization, query optimization,
query statistics, query tuning, integrity issues, missing index, and index
analysis.
Diagnostics: Availability group, wait stats, diagnose query, OS [operating
system] metric, replication, mirrored environment, predictive alerting,
resource governor, wait type, history browsing, PowerShell scripting,
clusters, latch, transaction logs, disk metrics, error logs, deadlock,
tempdb, blocking, response time, agent logs, and query resources.
Job management: Job chaining, long-running jobs, job scheduling, and agent
jobs.
Security: User permission, role permission, policy management, password
detection.
Compliance: PCI [payment card industry] or SOX [Sarbanes-Oxley Act]
tracking, sensitive data, audit snapshot, audit log write, audit data
filtering, and data auditing.
Defragmentation: Schedule job, defragment policy, average fragmentation,
index fragmentation, page density, fragmentation window, partition stats,
and pages per fragmentation.
