Find and fix SQL Server performance problems

- Performance monitoring for physical and VMWare databases
- Query monitoring to see the causes of blocks and deadlocks
- History browsing to find and troubleshoot past issues
- Predictive alerting with settings to avoid false alerts
- Database growth forecasting to minimize server sprawl


1. Why It Rocks

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.


2. Performance Monitoring

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.


3. Alerting and Diagnostics

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.


4. Enterprise Management

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.


5. Report and Collaborate

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.


6. System Requirements

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

Status: Contact Us for Special Price
Manufacturer: Idera
Reference URL http://www.idera.com/ProductsSolutions/SQLServer/SQLDiagnosticManager/