SQL Diagnostic Manager

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 and Virtual Database Monitoring

Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server 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.

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.

Tempdb Monitoring

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.

Custom Counters

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.

IDERA Dashboard and SQL Diagnostic Manager Web Console

  • Microsoft Windows: XP SP2+, Vista SP2+, Server 2008 SP1+, 7, Server 2008 R2, Server 2012, 8, 8.1, Server 2012 R2, 10, Server 2016; 32-bit and 64-bit
  • Repository: Microsoft SQL Server 2005 SP1+, 2008, 2008 R2, 2012, 2014, 2016
  • Microsoft .NET Framework: 4.0+
  • Web browser: Internet Explorer 9.x+, Google Chrome, Mozilla Firefox, Edge Browser
  • Web server: Apache Tomcat 6.0

SQL Diagnostic Manager

General

  • Microsoft Windows: XP SP2+, Vista SP2+, Server 2008 SP2, 7, Server 2008 R2, Server 2012, 8, 8.1, Server 2012 R2, 10, Server 2016; 32-bit and 64-bit
  • Client browser: Microsoft Internet Explorer 7.0+

Console

  • Microsoft .NET Framework: 4.0+
  • Microsoft Data Access Components: 2.8
  • Monitor resolution: 1280 x 1024 with small text

Services

  • Microsoft .NET Framework: 4.0 SP2+
  • Microsoft Data Access Components: 2.8

Repository

  • Microsoft SQL Server: 2005 SP1+, 2008 or later, 2008 R2, 2012, 2014, 2016, 2017 (experimental support); Standard and Enterprise Edition

Monitored SQL Server Instances

  • Microsoft SQL Server: 2000 SP4+, 2005 SP1+, 2008+, 2008 R2, 2012, 2014, 2016, 2017 (experimental support); Standard and Enterprise Edition
  • Microsoft SQL Server Express: 2008, 2008 R2, 2012, 2014

SQL Diagnostic Manager does not install any components, DLLs, scripts, stored procedures, and tables on the monitored SQL Server instances.

Mobile Requirements

  • Service and web server: Microsoft Windows: Server 2003 SP2, Vista SP1+, Server 2008, 7, Server 2008 R2, Server 2012, 8, 8.1, Server 2012 R2, 10, Server 2016
  • Microsoft .NET Framework: 4.0
  • Repository: Microsoft SQL Server: 2005 SP1+, 2008, 2008 R2, 2012 , 2014, 2016, 2017 (experimental support)
  • Web server: Microsoft Internet Information Services: 7.2+

Mobile and Desktop Devices

  • Mobile device: Google Android v2.1+, Apple iOS v3.2+, BlackBerry RIM v6.0+, Microsoft Windows Phone 7+
  • Desktop web browsers: Microsoft Internet Explorer 9.x+, Google Chrome, Mozilla Firefox, Microsoft Edge

Be the first to comment

Leave a Reply

Your email address will not be published.


*