Tune database performance, disaster recovery,
and security with expert recommendations

Tune SQL Server for physical, virtual, and cloud environments
View a summary of the health of the entire enterprise and a selected server
Display prioritized list of performance optimization recommendations
Generate executable SQL scripts to optimize performance

 

Checkups

• Run real-time, as-needed, and scheduled health checkups

  Schedule a regular analysis for an instance to track the health of SQL Server environments. Schedule daily or weekly check-ups to keep SQL Servers performing in top shape.

• View enterprise and server summaries

  Based on the last analysis run, quickly see the overall health of all registered servers. Drill down to a selected instance, analysis, server, and recommendation.

• Select analysis categories

  Choose any combination of categories: blocking processes, database configuration, deadlocks, disk, disaster recovery, index optimization, long-running jobs, memory, network, open transactions, and more.

• Access analysis history and view trends

  Access the results of every analysis stored for registered instances. View summaries and drill down to details.

• Limit the analysis to specified databases and applications

  Choose which database or application workload to include in the analysis. Block recommendations per instance to reduce analysis noise for undesirable changes. Block databases from the analysis.

 

Diagnosis

• View session data

  Quickly view all sessions that are currently active with detailed performance metrics collected from Dynamic Management Views (DMV).

• Collect extended and SQL Trace events

  Collect data using extended events and SQL Trace events. Automatically use the best method available depending on the SQL Server version, or decide to use SQL Trace events always.

• Pinpoint blocking and deadlocking sessions

  Determine which sessions are blocking or are involved in a deadlock.

• Evaluate server and instance configuration

  Examine configuration settings of SQL Server and the Windows operating system.

• Find long running jobs

  Identify jobs and transactions that may be running longer than usual.

• Find processor bottlenecks

  Identify configuration settings that cause processor bottlenecks.

• Check security settings

  Uncover many of the most common holes in security settings.

• Check network

  Diagnose issues with networking hardware and bandwidth.

• Verify disaster recovery

  Identify database integrity issues and recovery methods that may leave the database in a potentially unrecoverable state

 

SQL Query Tuning

• Analyze application queries

  Evaluate the most troublesome queries and gain immediate suggestions to improve their performance.

• Check indexes

  Diagnose databases indexes to determine possible performance optimizations.

• Explore query plan statistics

  Display statistical details about query plans For SQL Server, Azure SQL Database, and Amazon RDS SQL Server and deliver recommendations to improve their performance.

• Analyze wait stats

  Analyze the most popular wait statistics that cause query delays for SQL Server, Azure SQL Database and Amazon RDS SQL Server.

• Evaluate custom queries

  Analyze custom queries by parsing the T-SQL script without actually executing the query to receive recommendations.

 

Problem Resolution

• View prioritized list of recommendations

  Display the highest performance improvement options first according to a patented ranking system.

• Export Recommendations

  Export performance recommendations to disk for convenient distribution.

• Create Executable SQL scripts

  Generate executable SQL scripts to enact the recommended change. Also, generate reverse scripts to quickly undo the previously run SQL scripts.

• Access Cloud-specific Recommendations

  Access enhanced and new expert recommendations that are unique to the managed cloud databases Azure SQL Database and Amazon RDS SQL Server.

 

Cloud

• Install on cloud virtual machines

  Run SQL Doctor on cloud virtual machines with Windows – such as Microsoft Azure Virtual Machines (VMs) and Amazon Elastic Compute Cloud (EC2).

• Tune SQL Server cloud databases

  Tune the SQL Server cloud databases Azure SQL Database and Amazon RDS for SQL Server.

• Access mapped cloud drives

  SQL Doctor can access cloud storage that is mapped as network drives or removable drives on Microsoft Windows. For example, map to Azure Blob Storage and Amazon Simple Storage Service (S3).

• View cloud-specific recommendations

  Access enhanced and new expert recommendations that are unique to the managed SQL Server cloud databases Azure SQL Database and Amazon RDS for SQL Server.

• Tune SQL Server on cloud virtual machines

  Tune instances of SQL Server running on cloud virtual machines – such as Microsoft Azure VMs and Amazon EC2.

• Monitor hybrid environments with a single tool

  Avoid learning new tools by using the same tuning tool for SQL Server on-premises on physical and virtual machines, in the cloud on virtual machines, and the cloud as managed databases.

IDERA Dashboard services requirements

You need to comply with the following requirements to install the IDERA Dashboard:

Type : Microsoft .NET Framework version
Requirement : 4.0 or later
Suggestions : Make sure to install this software prior to the installation of the IDERA Dashboard. For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies.


Type : Microsoft Library
Requirement : msolap.dll
Suggestions : The msolap.dll file needs to be installed where the data collection service runs. The installation will search for the file and if it is not found, it will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft SQL Server 2016 Feature Pack (choose the ENU\x64\SQL_AS_OLEDB.msi installer).

Type : Operating System
Requirement :

• Windows Server 2008 R2 (86-bit)
• Windows Server 2008 R2 (64-bit)
• Windows Server 2012 R2 (64-bit)
• Windows Server 2016 (64-bit)
• Windows 10 (64-bit)
• Windows 2019 (64-bit)

Suggestions : -

 

IDERA Dashboard repository requirements

The IDERA Dashboard supports any of the following versions for hosting its repositories:

• SQL Server 2008 R2 - All Editions
• SQL Server 2012 R2 - All Editions
• SQL Server 2014 - All Editions
• SQL Server 2016 - All Editions
• SQL Server 2017
• SQL Server 2019

Browser requirements

The IDERA Dashboard user interface can be accessed via web with the following browsers:

• Internet Explorer IE 10.x+
• Google Chrome
• Mozilla Firefox
• Microsoft Edge
• Safari

Port requirements

The IDERA Dashboard uses the following ports by default:

• Idera Dashboard Core Services port: 9292
• Idera Dashboard Web Application Service port: 9290
• Idera Dashboard Web Application Monitor port: 9094
• Idera Dashboard Web Application SSL port: 9291