SQL Diagnostic Manager

Want to know more? See below.

Purchase

Like this? You will love what comes next.

$2,049 per instance

Buy it Now
Product Video

Got 5 minutes? See the product in action.

Watch it Now
Request More Info

Questions? Need a price quote? Talk to us.
Request Info
Data Sheet

Need more info? We have a pretty color brochure for that.
Get it here

“ With SQL diagnostic manager’s centralized console, filtering capabilities, and data repository, I'm able to see what's happening to all of my SQL Servers now or 2 months ago, with the click of a button. I now have more time to plan and tune my environment -- and it’s a lot easier and faster than trying to collect the data myself. Great job Idera! ”

- SQL Database Administrator, Boston Medical Center Health Net Plan

“ We have been using SQL diagnostic manager since 2003, it's our virtual teammate who never ever sleeps and continuously monitors over the performance of our SQL Server production systems. We especially love the alerting capabilities because it is very reliable, immediate, and allows us to customize the alerts we really need. It’s much better than any other SQL Server monitoring tools we’ve seen. ”

- DBA manager, QuickenLoans Inc.

“ Our company runs primarily purchased, third-party applications. This presents several tuning, troubleshooting, and performance challenges because we did not design the applications. SQL diagnostic manager gives us both deep and immediately visible performance data that allows us to immediately see what's going on inside the vendors' databases, to diagnose performance issues, and to keep things running smoothly. It’s a great tool. ”

- Database Administrator, American Management Services

Why It Rocks

Performance Monitoring

Alerting and Diagnostics

Enterprise Management

Report and Collaborate

System Requirements

Physical and Virtual Performance Monitoring

Easily monitor and view the performance of both physical and VMware server environments to get a complete view of SQL Server databases. View performance metrics and alerts for VMs and their related ESX hosts including CPU, memory, disk usage, network throughput and more.

Query Performance Monitoring

Identify inefficient code and poor-performing queries causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O.

History Browsing

Drill down to the precise point-in-time an error occurred to view historical SQL Server and OS metrics and better understand the multiple factors which could have contributed to an error.

Predictive Alerting

Avoid false alarms with adaptive alerting functionality and set alert thresholds based on built-in historical statistical analysis of your server performance data.

Database Growth Forecasting

Understand trends and view forecasts of your SQL Server environment to better plan for future needs and get a handle on SQL Server sprawl with database growth reporting.

Continuous Monitoring and Analysis

Continuous monitoring and real-time analysis of SQL Server and OS health and performance metrics across hundreds of SQL Servers enterprise-wide, including clustered configurations.

Physical and Virtual Monitoring

Easily monitor and view the performance of both physical and VMware server environments to get a complete view of your SQL Server databases. View performance metrics and alerts for VMs and their related ESX hosts including CPU, memory, disk usage, network throughput and more.

Custom Monitoring

Monitor and alert on performance issues affecting tempdb, mirrored database or replication environments. Add any SQL, Windows, or DMV counter for total flexibility in monitoring and alerting.

Query and Wait Stat Monitoring

Identify performance bottlenecks such as the worst performing queries along with what resource is causing the longest wait time, long-running queries, and most frequently run queries.

Mobile Monitoring

Use any mobile device, such as iPhone, Android, Blackberry or Tablet to view real-time and historical SQL Server performance data. Plus, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues remotely while on-the-go. View a demo of SQL diagnostic manager mobile.

Adaptive and Automated Alerting

Automatically identify alert threshold recommendations based on historical performance data and automatically takes corrective action.

Pinpoint Locks & Deadlocks

Identify locks, deadlocks and blocked sessions and see the complete blocking chain for easy identification and resolution.

Fragmentation Statics

Fragmentation is one of the most common causes of performance degradation in SQL Server. Statistics on fragmentation are displayed to help you identify indexes that may need attention.

History Browser

Easily navigate through SQL Server historical data with an easy to use History Browser. Check for performance problems by selecting a past point-in-time to view both historical SQL Server and OS performance metrics.

PowerShell Snap-In

Quickly and easily script many of the SQL diagnostic manager management tasks using the PowerShell Snap-in.

Customizable & Scalable Console

Hundreds of servers can be monitored from a single console; multiple consoles can support thousands of databases providing an unprecedented level of visibility and control of your entire SQL Server environment.

Server Activity Timeline

Visualize server performance events as a timeline calendar instead of only as a list of events. Events are color-coded for easy differentiation, and a sliding scale provides the ability to zoom in to a specific timeframe. This helps correlate events happening at the same time in an easy to read format for quicker trend analysis and remediation.

Application Security

Flexible customization of server access and security permissions allow DBAs to have full access to one or more servers while other users such as Help Desk Operators are provided read-only access.

Central Data Repository

Store all historical performance data in a central repository enabling analysis of long-term trends, supporting capacity planning and allowing for a variety of strategic analyses.

Agent-less & Low Impact

Simple and secure data collection is accomplished through utilization of a background service. No agents or components of any kind are installed on the monitored SQL Servers, worries of performance impact are eliminated.

Performance Baselines

View server baseline performance and compare a server’s baseline over time ranges, as well as across different servers. Plus generate reports that show the baseline in the given performance metric’s graph, allowing for better capacity planning.

IntelliFeed™ Technology

Idera Newsfeed allows users to follow critical issues and share updates on SQL Server problems with other technical staff using a social-networking paradigm.

Dashboard Templates

Customize dashboards to see the performance metrics most relevant to you for any given database and save as templates to share across servers or console users.

Knowledge Base

A knowledge sharing tool provided in the UI, gives the ability to add custom environment-specific details as a reference point to reduce problem resolution time, increase availability, and increase internal awareness.

Powerful Reporting

Generate pre-defined reports which highlight key performance trends or create custom reports via the easy to use reporting interface. Also, users can generate reports on historical performance trending, analysis, and forecasts to identify recurring problems and prevent future occurences.

Management Console

Windows XP SP2+, Windows Server 2003 SP2, Windows Server 2008 SP1+, Windows Vista SP2+, Windows 7, Windows 2008 R2, Windows 8, Windows 2012
.Net 4.0+ and MDAC 2.8
Monitor resolution of 1280x1024 with small text resolution

Services and Data Repository

Windows 2000 SP4, Windows XP SP2+, Windows Server 2003 SP2, Windows Server 2008 SP1, Windows Vista SP2+, Windows 7, Windows 2008 R2, Windows 8, Windows 2012
.Net 2.0 SP2+ and MDAC 2.8
Repository: SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Supported monitored SQL Servers

SQL Server 2000 SP4, SQL Server 2005 SP1+, SQL Server 2008 SP1, SQL Server 2008 R2, SQL Server 2012

SQL diagnostic manager does not install any components, DLLs, scripts, stored procedures or tables on the SQL Server instances being monitored.

Mobile Requirements

Services and Web Server OS: Windows Server 2003 SP2, Windows XP SP2+, Windows Server 2008 RTM+, Windows Vista SP2+, Windows 7, Windows 2008 R2, Windows 8, Windows 2012
.Net Framework: .Net 4.0
Repository: SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012
Web Server: IIS 7.2+, 8.0

Mobile and Desktop Devices

Mobile device: Android v2.1+, iOS v3.2+, RIM v6.0+, Windows Phone 7
Desktop Browsers: IE 9.x+, Chrome, Firefox

TRY IT FOR FREE

SQL diagnostic manager

Find and fix SQL Server performance problems