DatabaseMonitoringElements

Transcript

Expand

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.


SQL Database Monitoring Elements Periodic Table

Monitoring SQL databases is essential to diagnose and troubleshoot SQL Server performance issues, which ultimately lead to optimal performance. The monitoring has to be a continuous process because of the constant changes that happens in a typical SQL Server database’s data, tables and so on every day.

What to monitor, is always a question of business requirements and performance goals. In the attached infographic, you can find a list of important and critical metrics that needs to be monitored. These metrics are grouped from basic elements such as discovery and health checks to much more complex elements such as diagnostics and compliance. There are many tools and techniques that can be used to monitor SQL Server databases. Check out the wide range of tools available at IDERA site to help you monitor your SQL Server database. Learn More →

Start a FREE Trial of SQL Diagnostic Manager
Share This
Contact IDERA: