SQL Diagnostic Manager

Robust diagnostic management for SQL Servers

4,8 /5 (9 reviews) Write a Review!

SQL Diagnostic Manager Overview

What is SQL Diagnostic Manager?

SQL Diagnostic Manager is a cloud-based database monitoring solution that allows businesses to maximize the availability and performance of SQL server databases with detailed monitoring, smart alerts and insights and diagnostics. With SQL Diagnostic Manager, database administrators (DBAs) are able to view the real-time status of a SQL environment and quickly pinpoint and resolve potential issues. Key features include continuous monitoring, query capture, predictive alerts, expert recommendations and centralized dashboards.

For issue tracking, SQL Diagnostic Manager is able to quickly spot issues across multiple SQL server instances using metric analysis. With flexible monitoring, DBAs can view all SQL environments and instances through one single centralized dashboard and drill down into specific metrics to find the root cause of issues. DBAs can also monitor tempdb instances to identify and resolve contentions and performance issues as well as set-up custom counters for system reporting and monitoring.

SQL Diagnostic Manager notifies DBAs of any database issues before they occur with automatic email notifications, Window Event log alerts, and PowerShell script execution. With over 100 pre-defined alerts, DBAs can customize any alert to break down and filter issues by severity, metric, or server. For everyday issues and problems, SQL Diagnostic Manager will offer pre-formatted expert recommendations to prevent potential issues and improve database performance.

SQL Diagnostic Manager Overview

Pricing

Starting from
US$1 996,00

Pricing options

Free Trial
One Time License
Value for money

Includes 1 year of support and maintenance
Offers a SQL DM pro version for $2,156.00, includes SQL Workload Analysis


SQL Diagnostic Manager Features

Devices
Business size
S M L
Markets
United States
Supported Languages
English

Media

Find query bottlenecks
Alert predictively
View expert guidance
Monitor top issues
Report comprehensively
SQL Diagnostic Manager video SQL Diagnostic Manager screenshot: Find query bottlenecks SQL Diagnostic Manager screenshot: Alert predictively SQL Diagnostic Manager screenshot: View expert guidance SQL Diagnostic Manager screenshot: Monitor top issues SQL Diagnostic Manager screenshot: Report comprehensively

SQL Diagnostic Manager Reviews

SQL Diagnostic Manager Reviews

Overall rating
4,8
/
5
Excellent
8

Very good
0

Average
1

Poor
0

Terrible
0

Value for Money
4,3
Features
5
Ease of Use
4
Customer Support
4,4
89% recommended this app
Magno B.

SQL Diagnostic Manager


John F.

Fantastic SQL Insights

Overall, this is an excellent product and my experience with it has been very positive. The product offers real-time, meaningful insights into how your SQL instances are performing and behaving. These insights are essential in any enterprise and critical if you want to respond in a timely manner to emerging problems. Being able to go back in time and investigate situational issues is also a godsend.


Vineela T.

SQL DM

We have been using this tool since more than an year now...
Have found following pros and cons:

Pros:
Gives you index fragmentation, table growth , table size growth info and saves u lot of time

We also use it for monitoring deadlocks or adhoc queries locking up our system.

Cons:
Not user friendly at all
Takes lot longer to load up and start showing the graphs
Half the time it times out and says no data to show..
Had issues receiving alerts which we set up
User manual doesn't give complete description of metrics
Overall the experience was not as smooth as we thought..


Soheb S.

Very Nice Tool for DBA

it was times when server was down, database is offline, jobs are timing out any issue i was able to find the root cause in the tool and was able to fix it and this is something very useful for business to recover quick in case of failure.


Felipe R.

server diagnostics tool

We use it to monitor queries, performance and fall alerts. Bank errors often impact business applications, which generate demands on the networking team, which is often not our responsibility.


Magno B.
Industry: Information Technology & Services
Company size: 501-1 000 Employees

SQL Diagnostic Manager

Used Weekly for 1+ year
Reviewed on 2019/12/17
Review Source: Capterra

Pros

Using SQL Diagnostic Manager, reducing business impact, the ideal tool for monitoring the physical and virtual database, proactive notification brings you health and performance issues on the device you use, in my desktop case.

Cons

Only software adjustment for start-up, if you need support, can have a headache.

Rating breakdown

Ease of Use

Likelihood to recommend: 10.0/10

John F.
Industry: Food & Beverages
Company size: 501-1 000 Employees

Fantastic SQL Insights

Used Daily for 2+ years
Reviewed on 2019/12/11
Review Source: Capterra

Overall, this is an excellent product and my experience with it has been very positive. The product offers real-time, meaningful insights into how your SQL instances are performing and behaving. These insights are essential in any enterprise and critical if you want to respond in a timely manner to emerging problems. Being able to go back in time and investigate situational issues is also a godsend.

Pros

The software is simple to install and configure. Out of the box, you run the installer, add your licenses and apply the default template to start monitoring your SQL instances. You can then create custom monitoring templates that you can apply to specific instances and really narrow down on those things that are of the most important to you.

The product supports physical and virtual instances of SQL and I've used it with SQL 2008 through to SQL 2017. You can even monitor the virtual hosts resources via their integration.

The realtime capturing of queries, plans, and deadlocks is excellent. In the event of an issue, you can narrow down to a specific point in time and focus on those things impacting your SQL instance. You can see the queries that were running, the locks that were being held and so much more. This feature has saved me on more than one occasion.

The dashboard provides you with a really useful visual reference that you can leave running on a dedicated screen. You get regularly updated statistics about how your server is performing. In combination with the desktop warnings, you can react quickly to any developing issues.

Cons

As with most off the shelf software, SQL diagnostic Manager is most things you need in most cases. It does come with a default template that you can use. Be prepared though for some fine-tuning as you get more familiar with how the software works.

I've had one issue with the software since purchase. I didn't find their Tier 1 support to be very good but once escalated my issue was resolved.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

Vineela T.

SQL DM

Reviewed on 2015/06/29
Review Source: Capterra

We have been using this tool since more than an year now...
Have found following pros and cons:

Pros:
Gives you index fragmentation, table growth , table size growth info and saves u lot of time

We also use it for monitoring deadlocks or adhoc queries locking up our system.

Cons:
Not user friendly at all
Takes lot longer to load up and start showing the graphs
Half the time it times out and says no data to show..
Had issues receiving alerts which we set up
User manual doesn't give complete description of metrics
Overall the experience was not as smooth as we thought..

Rating breakdown

Ease of Use
Customer Support

Soheb S.
Industry: Health, Wellness & Fitness
Company size: 1 001-5 000 Employees

Very Nice Tool for DBA

Used Daily for 2+ years
Reviewed on 2019/03/09
Review Source: Capterra

it was times when server was down, database is offline, jobs are timing out any issue i was able to find the root cause in the tool and was able to fix it and this is something very useful for business to recover quick in case of failure.

Pros

I have been using the diag tool for past few years now and I completely satisfy with the in-depth and detail metrics it has to keep track of all the events happening on SQL server which other wise we have to either do it thorough extended event or trace. it helps me detect the problem before the user reports it and help us to stay proactive and recover quickly if any failure.

Cons

its hard to tell what I don't like about this software.

Response from IDERA

Thanks for the review Soheb! We are glad to hear that you are enjoying the tool and that it is allowing you to be proactive in detecting issues.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

Felipe R.
Industry: Telecommunications
Company size: 5 001-10 000 Employees

server diagnostics tool

Used Weekly for 2+ years
Reviewed on 2019/11/21
Review Source: Capterra

We use it to monitor queries, performance and fall alerts. Bank errors often impact business applications, which generate demands on the networking team, which is often not our responsibility.

Pros

The real time diagnostics of the servers. Wasting less time on bank maintenance, alerts are customizable and responsive.

Cons

Browsing history is still slow, which causes some discomfort when it is necessary to redo bank analysis.

Rating breakdown

Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

User recommendation
9,8/10
Based on 9 user ratings
Compare user recommendation rating with alternatives
Compare with alternatives

SQL Diagnostic Manager Pricing

SQL Diagnostic Manager Pricing

Starting from
US$1 996,00
Free Trial
One Time License
Value for money

Includes 1 year of support and maintenance
Offers a SQL DM pro version for $2,156.00, includes SQL Workload Analysis

Includes 1 year of support and maintenance
Offers a SQL DM pro version for $2,156.00, includes SQL Workload Analysis

Value for Money
4,3/5
Based on 9 user ratings
Compare value for money rating with alternatives
Compare with alternatives

SQL Diagnostic Manager Features

SQL Diagnostic Manager Features

API
Access Control
Activity Dashboard
Activity Tracking
Alerts / Escalation
Auditing
Automatic Notifications
Collaboration Tools
Compliance Management
Data Import/Export
Data Visualization
Drag & Drop Interface
Monitoring
Real Time Data
Real Time Monitoring
Reporting & Statistics
Search Functionality
Third Party Integration
User Management
Workflow Management
Features
5/5
Based on 9 user ratings
Compare features rating with alternatives
Compare with alternatives

Categories

Additional information for SQL Diagnostic Manager

Additional information for SQL Diagnostic Manager

Key features of SQL Diagnostic Manager

  • Dashboard
  • Data Migration
  • Data Storage Management
  • Database Conversion
  • Diagnostic Tools
  • Predictive Analytics
  • Reporting
  • Resource Management

Benefits

Idera relentlessly delivers the industry's most complete solution for 24x7 SQL server performance monitoring, alerting, and diagnostics and tirelessly supports the SQL community with 100% free tools and expert advice.

SQL Diagnostic Manager FAQs

SQL Diagnostic Manager FAQs

Below are some frequently asked questions for SQL Diagnostic Manager.

Q. What type of pricing plans does SQL Diagnostic Manager offer?

SQL Diagnostic Manager offers the following pricing plans:

Starting from: US$1 996,00

Pricing model: One Time License

Free Trial: Not Available

Includes 1 year of support and maintenance Offers a SQL DM pro version for $2,156.00, includes SQL Workload Analysis

Q. What are the main features of SQL Diagnostic Manager?

SQL Diagnostic Manager offers the following features:

  • Dashboard
  • Data Migration
  • Data Storage Management
  • Database Conversion
  • Diagnostic Tools
  • Predictive Analytics
  • Reporting
  • Resource Management

Q. Who are the typical users of SQL Diagnostic Manager?

SQL Diagnostic Manager has the following typical customers:

Mid Size Business

Q. What languages does SQL Diagnostic Manager support?

SQL Diagnostic Manager supports the following languages:

English

Q. What type of pricing plans does SQL Diagnostic Manager offer?

SQL Diagnostic Manager has the following pricing plans:

One Time License

Q. Does SQL Diagnostic Manager support mobile devices?

We do not have any information about what devices SQL Diagnostic Manager supports

Q. What other apps does SQL Diagnostic Manager integrate with?

We do not have any information about what integrations SQL Diagnostic Manager has

Q. What level of support does SQL Diagnostic Manager offer?

SQL Diagnostic Manager offers the following support options:

Phone Support, Online Support