Use Today’s Analysis to Inform Tomorrow’s Strategy

SQL Diagnostic Manager

Access the reporting capabilities you need to manage databases more efficiently.

Feel like you’ve been stuck in the dark on Database Administration?

You can’t work efficiently without accurate monitoring. SQL Diagnostic Manager can help.

Your job is to keep things running smoothly, no matter what. And yet to do that, you can’t rely on reactive management of your data environment. Planning for better performance in the future, or even avoiding disaster, requires knowing what has happened in the past and why. Having the right diagnostic tool will save you countless hours hunting down root causes of issues and enable you to make more informed plans for upgrades or improvements.

We give you a picture of what’s really going on

Get access to reliable, real-time information on the status and health of your environment. With the help of our diagnostic tool, you can not only quickly pinpoint and resolve performance issues, but also form a more accurate picture of what’s happening in your environment. These diagnostics grant you the peek-around-the-corner you need to strategize for better-performing, more available databases.
Use historical data and multiple baselines to better understand why issues are occurring.
z

Incorporate tools like PowerShell to automate alert response actions.

b

Create smarter, data-informed proposals for upgrades and improvements.

Build continuity into every process

Customize the diagnostics and reporting features of SQL Diagnostic Manager.
Diagnostics & Reporting
-

View locks, blocks, and deadlocks

For easy problem identification and resolution, view the complete blocking chain by identifying real-time and historical session locks, blocks, bottlenecks, and deadlocks
,

Run PowerShell scripts

Get even more control over SQL Diagnostic Manager by deploying Microsoft PowerShell, and automate responses to alerts with PowerShell scripts
P

Integrate with SCOM

Share data efficiently with IT operations by propagating the status, health, and events of monitored instances to Microsoft’s System Center Operations Manager (SCOM).
1

View activity timelines

Understand events faster and more intuitively by viewing color-coded performance events on your server in a timeline calendar instead of a list of events. Use a sliding scale to zoom in to specific times.

Browse historical data

Reduce future problems by understanding the multiple factors behind SQL Server database issues. Examine historical trends and drill into the precise time a problem emerged.

Plan capacity

Confidently plan the future of your storage infrastructure. View charts and create reports with trends and metrics to help forecast future capacity needs.

View fragmentation

Quickly remedy one of the most common causes of performance degradation: View statistics on fragmentation to identify indexes that may need defragmentation

Set up multiple baselines

Compare the performance baselines that matter to your business by defining and scheduling multiple baseline periods

Here’s how it works

01

Sign up for a free two-week trial

Trying our IDERA SQL Diagnostic Manager is easy and commitment-free.

02

See the difference in your data management

Unlock efficiency in your processes like never before.

03

Get full support— no strings attached

Throughout your trial, our team is on hand to answer any questions.

Try IDERA SQL Diagnostic Manager today