IDERA SQL Diagnostic Manager for SQL Server Valuable Features

JS
Senior DBA Lead at a government with 10,001+ employees

There are so many features. One of the most valuable features is the ability to alert, proactively, on a variety of issues on which we would normally not get a heads-up, that something is going to happen. The alerting functionality is important.

There are a few pre-designed reports that we use for database and disk usage growth, that allow us to show, over time, how much a database and disk space have grown. They help us plan for the coming year.

View full review »
PB
Assistant at a tech services company with 1,001-5,000 employees

The ability to go back and look at historical data is the most valuable feature. 

View full review »
MB
Senior Manager, Data Operations at a consumer goods company with 201-500 employees

The most valuable features are disk space projections for planning, and also the Snapshotting ability, to look back in time, to see what was going on the server at a particular time. It's basically the output of an sp_who2.

View full review »
Buyer's Guide
Database Development and Management
March 2024
Find out what your peers are saying about IDERA, SolarWinds, Redgate and others in Database Development and Management. Updated: March 2024.
765,386 professionals have used our research since 2012.
it_user11286 - PeerSpot reviewer
IT - Server Administration with 501-1,000 employees

The capability to baseline the environment and define thresholds for alerting is definitely the most valuable feature in my opinion. As an operational DBA, I don't write code but need to make sure the SQL servers are healthy, performing scheduled jobs and made aware when issues arise.

View full review »
it_user806148 - PeerSpot reviewer
Database Administrator at a tech services company with 11-50 employees

The best part of SQL DM is the ability to customize alerts and counters. This allows our team to find an issue, then alert on the issue at a granular level.

View full review »
it_user612705 - PeerSpot reviewer
Cloud Database Administrator at a tech services company with 501-1,000 employees

I love the customization of the alerts.

We created several stored procedures/functions that would query multiple DMV’s and alert if a certain threshold was reached. However, since new DMV’s are added, or older ones are adjusted, it caused too much headache to continue to support the home brew method.

View full review »
it_user177303 - PeerSpot reviewer
Database Architect at a insurance company with 51-200 employees

Ability to identify bottlenecks, deadlocks and slow running queries and run monthly and daily reports.

View full review »
HL
Managing Director at eGlobal Technology

Memory and CPU utilization features are good. 

View full review »
Buyer's Guide
Database Development and Management
March 2024
Find out what your peers are saying about IDERA, SolarWinds, Redgate and others in Database Development and Management. Updated: March 2024.
765,386 professionals have used our research since 2012.