HomeSecurityIDera SQL Server Diagnostic Manager | Achieve 24/7
June 7, 2018
IDera SQL Server Diagnostic Manager | Achieve 24/7
Monitor Performance of Physical, Virtual, and Cloud Environments
Easily monitor and view the performance of physical servers, virtual servers (VMware and Hyper-V), and cloud environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.
Continuous Monitoring and Analysis
Continuously monitor with real-time analysis of SQL Server and OS health and performance metrics across hundreds of SQL Servers enterprise-wide, including clustered configurations.
Physical, Virtual, and Cloud Database Monitoring
Easily monitor and view the performance of physical servers, virtual servers, and virtual servers (VMware and Hyper-V) to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.
Availability Group Monitoring
Manage the topology of high availability (HA) groups. SQL Diagnostic Manager monitors the performance of AlwaysOn Availability Groups that are set up and will send alerts as needed to ensure SQL Server is running on the designated node in the event of failover to a secondary replica. It can also run on an Availability Group as well.
Quickly identify and resolve tempdb database contention and performance related issues with tempdb monitoring and its diagnostic views. Monitor and display the tempdb space and performance related information including tempdb file space, tempdb version store, session space usage of tempdb, and waits related to tempdb.
Add an unlimited amount of custom counters in the monitoring process. These include any perfmon counters or any SQL queries (which can enable advanced application specific monitoring) that can be added to the list of already existing industry specified counters that SQL Diagnostic Manager will monitor. This information is also stored in the repository so a custom report can be created and stored to capture this data.
Job Management & Monitoring
Monitor and alert on job success, failure, cancelled or retry events. The Jobs view displays all jobs, their last known status, complete job history and allows users to start/stop jobs.
Monitor Replication & Mirrored Environments
Easily monitor performance problems with your mirrored or replication environments. The system also provides alerts and real-time diagnostic views to help with troubleshooting in these environments.
Monitor OS Metrics
Collect OS performance metrics using WMI or OLE automation.