Monitor cloud databases with SQL Diagnostic Manager

SQL Diagnostic Manager for SQL Server (SQLDM) is a database tool specifically designed to diagnose and tune Microsoft SQL Server. It allows you to analyze the state of SQL Server, discover potential problems, and generate reports. SQLDM users can also monitor Azure ADS for SQL Server and Microsoft Azure SQL Database.

Monitoring support

• SQL Server on-premises

• SQL Server on cloud virtual machines

• Amazon RDS for SQL Server

• Azure SQL Database

Benefits

• Monitor hybrid cloud with single GUI

• Shorten learning curve

• Cut licensing costs

• Deduce application footprints

Discovery feature

• Find all database instances in cloud environment

• Easily find managed cloud database instances

Summary tiles

• Summary for each monitored instance

• Show response time and number of user sessions

• Display CPU usage, memory usage, and disk I/O

Display window tabs

• Overview: Dashboard, Details, Configuration, Active Alerts, and Timeline

• Sessions: Summary, Details, Locks, and Blocking

• Query: Signature Mode, Statement Mode, Query History, and Query Waits

• Resources: Summary, Memory, Disk, Disk Size, File Activity, and Server Waits views.

• Databases: Summary, Availability Group, Tempdb Summary, Database Configuration, Files, Backups & Restores, and Tables & Indexes

• Services: Summary and SQL Agent Jobs

• Logs: View, Filter, and Search

• Analyze: run prescriptive analyses to find and fix problems

SQLDM summary

SQLDM is a performance monitoring solution for SQL Server running in a variety of environments, including Amazon RDS for SQL Server and Azure SQL Database. It provides a general overview and detailed metrics for database instances with a single dashboard from a centralized location.