SQL Diagnostic Manager is a powerful performance monitoring and diagnostics solution that proactively alerts administrators to health, performance, or availability problems within their SQL Server environment via a central console or mobile device. SQL diagnostic manager minimises costly server downtime by providing agent-less, real-time monitoring and customisable alerting for fast diagnosis and remediation of SQL Server performance and availability problems. SQL diagnostic manager also provides a ¿community¿ environment where, using Idera¿s IntelliFeed technology, DBAs form a community to collaborate to quickly resolve problems, perform maintenance, and capture best practices
What is SQL Diagnostic Manager?
Physical and Virtual Performance Monitoring
Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.
Query Performance Monitoring
Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.
Integrated SQL Doctor Expert Recommendations
Expert recommendations from IDERA SQL Doctor are now integrated into SQL Diagnostic Manager. Enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. These updated recommendations are integrated into analysis workflows and provide specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge your SQL Server performance.
Query Plan Diagnostics
Dig deep into problematic queries with new query plan diagnostic capabilities. View high level query performance information across applications, databases and users with enhanced drill down capabilities into individual queries to view detailed SQL text, execution plan XML, and graphical views of execution plans.
Avoid false alarms with adaptive alerting functionality and set alert thresholds based on built-in historical statistical analysis of your server performance data. Read more…
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.
Access SQL Diagnostic Manager from anywhere. 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.
SQL Diagnostic Manager is offered per instance. A license is needed for each (per) SQL Server instance that is being monitored. First year of maintenance is included in price.
Alfasoft offer a price guarantee for the IDERA products. If you find an IDERA product at a lower price before your purchase somewhere else we will match it.
Monitored SQL Server Instances
SQL Diagnostic Manager does not install any components, DLLs, scripts, stored procedures, and tables on the monitored SQL Server instances.
Mobile and Desktop Devices
SQL Diagnostic Manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2). It supports cloud databases (that is, Microsoft Azure SQL Database and AWS RDS SQL Server).
IDERA Product Support is included with every purchase of IDERA software. IDERA´s goal is to provide their customers with the assistance and information they need to achieve success with IDERA’s products. 24×7 worldwide customer support is available to IDERA customers that hold a current maintenance contract.
Supporthelp can be received at: https://www.idera.com/support/productsupport
IDERA Customer Support Portal includes: