Tech Specs: SQL Diagnostic Manager for SQL Server

Technical Specifications

What Is New

Expand

Version 10.6

  • New and improved user interface: 
    • Improved workflow, easing navigation in desktop client console.
    • Expandable Servers sidebar, allowing users to have a larger screen space.
    • Dock and undock user interface components to optimize usage in multi-monitor environments .
    • Search bar eases search of monitored instances in large scale deployments.
    • Searchable drop-down instance name navigation without changing drill-down.
    • History Range control available for historical or real-time analysis.
    • Advanced sessions filter by application adds to powerful analysis options including drag-and drop “Group By” options.
  • Access to Azure Monitor Counters for Custom collection

Please also refer to the product documentation New features and fixed issues.


Platform Support

Expand
  • General: Microsoft Windows
  • Client web browser: Microsoft Internet Explorer
  • Desktop console: Microsoft .NET Framework
  • Web console: IDERA Dashboard
  • Mobile console:
    • Service and web server: Microsoft Windows, Microsoft .NET Framework
    • Repository: Microsoft SQL Server
    • Web server: Microsoft Internet Information Services (IIS)
    • Mobile devices: Google Android, Apple iOS, BlackBerry RIM, Microsoft Windows Phone
  • Services: Linux, Microsoft .NET Framework, Microsoft Data Access Components (MDAC)
  • Repository: Microsoft SQL Server
  • Monitored database platforms: Microsoft SQL Server, Microsoft SQL Server Express, Microsoft Azure SQL Database, Amazon RDS
  • Desktop web browsers: Microsoft Internet Explorer, Google Chrome, Mozilla Firefox, Microsoft Edge
  • Cloud: Microsoft Azure VM, Amazon EC2, Microsoft Azure SQL Database, Amazon RDS for SQL Server

For more information, please refer to the product documentation SQL Diagnostic Manager requirements.


System Requirements

Expand

General

  • Microsoft Windows: Server 2019, Server 2016, 10, Server 2012 R2, 8, Server 2012, Server 2008 R2, 7, Server 2008 SP1

Client Web Browser

  • Microsoft Internet Explorer: 7.0+

Desktop Console

  • Microsoft .NET Framework: 4.0+ (4.6.2 recommended)
  • Monitor resolution: width 1280 px +, height 1024 px + (SVGA+), small text

Web Console

For the web console, please refer to the IDERA Dashboard. [hyperlink]

Mobile Console

Service and Web Server
  • Microsoft Windows: Server 2016, 10, Server 2012 R2, 8.1, 8, Server 2012, Server 2008 R2, 7, Server 2008, Vista SP1+, Server 2003 SP2
  • Microsoft .NET Framework: 4.0+ (4.6.2 recommended)
Repository
  • Microsoft SQL Server: 2019 (Windows, Linux), 2017 (Windows, Linux), 2016, 2014, 2012, 2008 R2, 2008, 2005 SP1+; Standard, Enterprise edition
Web Server
  • Microsoft Internet Information Services (IIS): 7.2+
Mobile Devices
  • Google Android: 2.1+
  • Apple iOS: 3.2+
  • BlackBerry RIM: 6.0+
  • Microsoft Windows Phone: 7+

Services

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

Repository

  • Microsoft SQL Server:
    2019 (Windows, Linux), 2017 (Windows, Linux), 2016, 2014, 2012, 2008 R2, 2008, 2005; Standard, Enterprise edition

SQL Diagnostic Manager does not install any components, agents, databases, dynamic link libraries (DLLs), scripts, stored procedures, or tables on the monitored instances.

Desktop Web Browsers

  • Microsoft Internet Explorer: 9.x+
  • Google Chrome
  • Mozilla Firefox
  • Microsoft Edge

Cloud

  • Runs on cloud virtual machines such as Microsoft Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2) with Microsoft Windows.
  • Monitors database instances on cloud virtual machines such as Microsoft Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).
  • Monitors managed cloud databases Microsoft Azure SQL Database and Amazon Relational Database Service (RDS) for Microsoft SQL Server.

For more information, please refer to the product documentation SQL Diagnostic Manager requirements.


Supported Systems

Expand

Monitored Database Platforms

  • Microsoft SQL Server:
    2019 (Windows, Linux), 2017 (Windows, Linux), 2016, 2014, 2012, 2008 R2, 2008 SP+, 2005 SP1+, 2000 SP4+; Standard, Enterprise edition
  • Microsoft SQL Server Express: 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008
  • Microsoft Azure SQL Database
  • Amazon Relational Database Service (RDS) for Microsoft SQL Server

For more information, please refer to the product documentation SQL Diagnostic Manager requirements.


Version History

Expand

Version 10.5.1

  • New Server Uptime report
  • Three new default values for History Browser range
  • The "Days since last backup" alert configuration includes option to include or exclude Read-Only databases

Version 10.5

  • Prescriptive Analysis improvements (embedded SQL Doctor), updated user interface that matches SQL Doctor workflows, and updated recommendations (specifically for Azure SQL and Amazon RDS)
  • Cloud DBaaS user interface improvements that ease management of Azure SQL and Amazon RDS management supported metrics
  • Alerting improvements:
    • New alert templates with revised thresholds and ranks
    • New conditions for Alert Responses
    • New Alert filter to avoid false positives from spikes, filter by percentage of time over a period exceeding threshold
    • PowerShell command to Apply Alert template
    • New Alerts and metrics for Azure SQL and Amazon RDS specifically
    • All alert priority levels were updated for existing alerts and for user customization.
    • New alert template reports

Version 10.4

  • Visual Query Plans available for launch in Windows Client context from any query
  • Improved collection of Extended Event query plans
  • New options to exploit Query Store collections for query waits, query plans, and query performance
  • Improved IDERA Dashboard with new alerts grid and instance lists

Version 10.3.1

There are no new features for this product version release.

Version 10.3

  • Monitor SQL Server 2017 instances running on Windows or Linux operating systems
  • New operator security role
  • New grooming and aggregation options for long term forecasting metrics for disks, databases, and tables

Version 10.2.3

There are no new features for this product version release.

Version 10.2.2

  • Cluster environment: A UNC path is set for DataPath for services in a cluster install
  • Reports:
    • Detailed Session report
    • New Deadlock Report
    • Exclude one or more disks when running Disk Space Usage report

Version 10.2.1

There are no new features for this product version release.

Version 10.2

  • SQL Diagnostic Manager: Performance improvements, focus on an extensive scalability and user productivity improvements which involve faster startup time and faster connectivity between SQL Diagnostic Manager and SQL Workload Analysis
  • SQL Workload Analysis integration:
    • Launch SQL Workload Analysis in context of monitored server from desktop console and IDERA Dashboard
    • Time-based drilldown any graph in desktop console and in web console
    • SQL Workload Analysis launch points in different components of SQL Diagnostic Manager desktop and web console
  • History browser: New History Range Control in desktop console and web console

Version 10.1.4

There are no new features for this product version release.

Version 10.1.1

  • Launch SQL Workload Analysis in context of your monitored server from desktop console and IDERA Dashboard

Version 10.1

  • General: Desktop console is no longer showing slow performance that was caused by retained data from deleted instances
  • Grooming process: Grooming process has stopped exceeding growth of SQLStatementsOverflow table
  • Monitor AlwaysOn Availability Groups:
    • Monitored Availability Group Listeners no longer have issues gathering information from primary replica
    • “Unreadable availability replica” status is no longer displaying in databases that are part of AlwaysOn Availability Groups
  • Collection service: Enabling maintenance mode for all monitored instances is no longer causing Collection Service crash
  • Troubleshoot WMI connectivity issues: After troubleshooting WMI connectivity issues “WMI is not available on the server” alert is no longer displaying.

Version 10.0.2

There are no new features for this product version release.

Version 10.0.1

There are no new features for this product version release.

Version 10.0

  • Prescriptive analysis
  • Multiple baselines
  • Multiple custom dashboards
  • Import and export alert response
  • Import and export wizard
  • Top Servers report
  • Self-service licensing model
  • Web console improvements:
    • Federated Overview screens 
    • New common Dashboard widgets 
    • New color-coded Alerts Timeline view 
    • Query Waits view enhancements
    • Databases Summary view enhancements
    • Collapsible side panel

Version 9.1.2

There are no new features in this product version release.

Version 9.1.1

There are no new features in this product version release.

Version 9.1

  • Web console improvements:
    • Aggregated views across multiple repositories
    • Launch desktop console from various views
    • Adjustable panels in key web console views
    • Improved thumbnail sub-view
    • Improved heatmap sub-view
    • New web console widgets
    • Monitoring of non-query activities with Extended Events
    • Integration with IDERA community site
  • Filegroup and Mount Point monitoring improvements:
    • Configurable database filegroup alerts
    • New Disk Size view
    • Disk Space Usage report
    • Disk Space History report
  • Monitoring of additional SQL Server services:
    • SQL Server Active Directory Helper Status
    • SQL Server Browser Service Status
    • Server Summary report supports new SQL Server monitored services

Version 9.0

  • Integration with IDERA Dashboard
  • New advanced query views
  • Improved and integrated web console 
  • Licensing and version upgrading
  • Help documentation improvements

Version 8.6

  • Full support for SQL Server Express instances
  • Reporting on Query Wait Statistics
  • Query Waits information is extended to Top Servers and Top Databases reports
  • New database alert for Availability Group Preferred Replica

Version 8.5

  • Full support for SQL Server 2014
  • Hyper-V support
  • Tech Preview of new SQL Diagnostic Manager web console
  • Monitoring and alerting enhancements:
    • Enhanced alert response usability
    • Inclusion filters for Query monitors
    • New filter in Signature Mode and Statement Mode views
    • Improved Maintenance Mode flexibility
    • Virtualization counters available for custom reports
    • Run one-click System Diagnostics
    • Deadlock victim details available in Deadlock Sessions Report
    • Configuration option added to control WMI timeouts

Version 8.0.1

There are no new features in this product version release.

Version 8.0

  • Fully supports AlwaysOn Availability Groups feature of SQL Server 2012
  • Integration with Microsoft System Center Operations Manager (SCOM)
  • Change Log Summary report
  • Blocked Process report available in SQL Diagnostic Manager
  • Improved Maintenance Mode and Snooze Alerts features
  • Desktop console supports Operating Systems where FIPS compliance is required
  • SQL Server 2014 experimental support

Version 7.5.4

  • General: Charts properly manage real-time and scheduled collection data in same time span
  • Queries: Query Waits located on Queries tab
  • Alerts:
    • Manage how desktop console responds to alert notifications
    • Set to notify of only critical alerts
  • Mobile: Mobile and IDERA Newsfeed supports IIS 8

Version 7.5.3

There are no new features in this product version release.

Version 7.5.2

There are no new features in this product version release.

Version 7.5.1

There are no new features in this product version release.

Version 7.5

There are no new features in this product version release.

Version 7.2.2

There are no new features in this product version release.

Version 7.2.1

  • SQL Server 2012 RTM Support

Version 7.2

  • Monitoring SQL Server virtual environments
  • SQL Server 2012 experimental support
  • SQLdm Mobile views
  • Reporting on Tempdb Statistics
  • SQL Server Memory Usage Percent counter available for custom reports
  • Updated alert notification functionality
  • CPU Statistics report available in a custom range of hours
  • Input how long SQL Diagnostic Manager waits before raising an alert for a long-running job

Version 7.1.1

There are no new features in this product version release.

Version 7.1

  • New SQL Server dashboard
  • New Tempdb monitoring
  • New SQLdm Mobile views
  • Blocking Chain View
  • View and copy SQL Agent Job messages from Job History list

Version 7.0

  • New SQLdm Mobile interface
  • New Alert Templates
  • New Informational Alerts
  • Improved Alert Response Usability
  • Improved Notification Times for Unresponsive SQL Server Instances
  • Improved Metrics Collection
  • Improved Repository Performance
  • New Reports

Please also refer to the product documentation Previous features and fixed issues.

Try SQL Diagnostic Manager for SQL Server FREE for 14 days
SQL Diagnostic Manager Repository dashboard

24X7 SQL performance monitoring, alerting and diagnostics

  • Monitor performance for physical, virtual, and cloud environments.
  • Monitor queries and query plans to see the causes of blocks and deadlocks.
  • Monitor application transactions with SQL Workload Analysis add-on.
  • View expert recommendations from SQL Doctor to optimize performance.
  • Alert predictively with settings to avoid false alerts.
  • View summary of top issues and alerts with the web console add-on.
Start for Free


Share This
Contact IDERA:
+1 (713) 523-4433