The business challenges that led the profiled company to evaluate and ultimately select SQL Diagnostic Manager:
- Optimize their SQL Server database instances to:
- Improve database performance.
- Avoid finger pointing from other IT groups and third-party application vendors when issues occur.
- Improve visibility into the overall health of the databases.
- Identify inefficient and poor performing SQL queries, batches, and statements.
- Accelerate root cause identification and mean time to resolution.
- Improve the ability to identify database-related application performance.
- Address a lack of DBA resources to effectively and proactively manage all instances.
- Automate administration and provision monitoring using scripting language.
- Automate alert response actions to correct problems and integrate with other systems.
- Find query bottlenecks using wait state query workload analysis.
- Produce and publish performance reports.
- Perform prescriptive analysis with expert recommendations and executable scripts.
- Find and resolve blocking and deadlock application conflicts.
- Diagnose performance issues with Availability Groups.
The key features and functionalities of SQL Diagnostic Manager that the surveyed company uses:
- Has 100 or more SQL Server databases in their environment.
- Operating systems integrated with SQL Server databases: Windows and VMWare.
The surveyed company achieved the following results with SQL Diagnostic Manager:
- Decreased unplanned database downtime.
- Decreased mean time to resolution for database issues.