Senior DBA Lead at a government with 10,001+ employees
Real User
2018-10-21T07:40:00Z
Oct 21, 2018
We use it to look at the overarching environment and, from there, we're able to pick and choose which servers and databases we want to view more closely. We manage over 300 servers, and 14,000 databases. We're constantly in the tool, utilizing it to drill down and determine what is going on with a specific database and query, or cache, etc.
Senior Manager, Data Operations at a consumer goods company with 201-500 employees
Real User
2018-10-02T19:05:00Z
Oct 2, 2018
Our primary use case is monitoring. We use the solution to get an overview of our entire environment and then drill down to view details. We look for issues that have happened in the past, that have been reported by users. We can then see what was going on, on the server, at that time, to cause such issues. The only people who are using it are eight DBAs. We did increase usage for lower environments rather than just production environments.
Learn what your peers think about IDERA SQL Diagnostic Manager for SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad PowerShell integration, complete customization, and extensive support for current and legacy SQL Server and Windows.
We use it to look at the overarching environment and, from there, we're able to pick and choose which servers and databases we want to view more closely. We manage over 300 servers, and 14,000 databases. We're constantly in the tool, utilizing it to drill down and determine what is going on with a specific database and query, or cache, etc.
Our primary use case is monitoring. We use the solution to get an overview of our entire environment and then drill down to view details. We look for issues that have happened in the past, that have been reported by users. We can then see what was going on, on the server, at that time, to cause such issues. The only people who are using it are eight DBAs. We did increase usage for lower environments rather than just production environments.
We use it to look at performance.