Hopp til innholdet

SQL Diagnostic Manager

Comprehensive SQL Server Monitoring

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

  • Performance monitoring for physical and virtual environments
  • Query plan monitoring to see the causes of blocks and deadlocks
  • Integrated SQL Doctor expert recommendations
  • Easy integration with Microsoft SCOM
  • Predictive alerting with settings to avoid false alerts
  • Web-based dashboard with at-a-glance views of top issues and alerts

Info

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.

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. Read more…

Capacity Planning

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.

Mobile Access

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

Lisensiering

Lisensiering

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.

Systemkrav

Systemkrav

General

  • Microsoft Windows: Server 2008 SP1, 7, Server 2008 R2, Server 2012, 8, Server 2012 R2, 10, Server 2016, Server 2019;
  • Client browser: Microsoft Internet Explorer 7.0+

Console

  • Microsoft .NET Framework: 4.0+ (4.6.2 recommended)
  • Monitor resolution: 1280 x 1024 with small text

Services

  • Linux (for monitoring SQL Server 2017): Red Hat Enterprise 7.3+, SUSE Enterprise v12 SP2 +, Ubuntu 16.04LTS and 16.10 +
  • Microsoft .NET Framework: 4.0 SP2 + (4.6.2 recommended)
  • Microsoft Data Access Components: 2.8

Repository

  • Microsoft SQL Server: 2005, 2008+, 2008 R2, 2012, 2014, 2016, 2017, 2019 on Windows and Linux; Standard and Enterprise Edition

Monitored SQL Server Instances

  • Microsoft SQL Server: 2000 SP4+, 2005 SP1+, 2008 SP1+, 2008 R2, 2012, 2014, 2016, 2017, 2019 on Windows and Linux; Standard and Enterprise Edition
  • Microsoft SQL Server Express: 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019
  • Microsoft Azure SQL Database
  • AWS RDS SQL Server

SQL Diagnostic Manager does not install any components, DLLs, scripts, stored procedures, and tables on the monitored SQL Server instances.

Mobile Requirements

  • Service and web server: Microsoft Windows: Server 2003 SP2, Vista SP1+, Server 2008, 7, Server 2008 R2, Server 2012, 8, 8.1, Server 2012 R2, 10, Server 2016
  • Microsoft .NET Framework: 4.0+ (4.6.2 recommended)
  • Repository: Microsoft SQL Server: 2005 SP1+, 2008, 2008 R2, 2012 , 2014, 2016, 2017, 2019 on Windows and Linux; Standard and Enterprise Edition
  • Web server: Microsoft Internet Information Services: 7.2+

Mobile and Desktop Devices

  • Mobile device: Google Android v2.1+, Apple iOS v3.2+, BlackBerry RIM v6.0+, Microsoft Windows Phone 7+
  • Desktop web browsers: Microsoft Internet Explorer 9.x+, Google Chrome, Mozilla Firefox, Microsoft Edge

Cloud
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).

Support

Support

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:

  • Access information about IDERA products that you have purchased
  • Search our Knowledge Base
  • Submit/track technical support cases
  • Review current product versions and release dates