Monitor performance, analyze workload, tune queries, and manage agent jobs
Database administrators need reliable, real-time information on the status, health, and
performance of their databases and BI services. They also need to minimize the time and
effort spent on the routine monitoring of databases across the organization. To address
this challenge, benefit from IDERA’s bundle of top tools for SQL Server performance.
Monitor, alert, diagnose, and
report on performance
Analyze workloads and tune queries
Manage and monitor agent jobs
SQL Performance Suite provides complete SQL Server performance, from database performance monitoring, diagnostics, and tuning guidance to agent job management.
Quickly find and fix performance issues
Monitor performance for physical, virtual, and cloud environments.Use predictive alerting with settings to avoid false alerts. Tune performance with integrated expert advice. Monitor wait states and analyze application transaction workload. Profile and optimize poor-performing SQL queries.
Manage and monitor agent jobs
Monitor SQL Server agent jobs across the environment. View job status and details smoothly with a familiar calendar layout. Chain jobs together and build automated workflows. Configure and manage jobs that run over multiple instances. Set alerts to be notified of potential issues. Simplify deployment with web-based architecture.
IDERA Dashboard services requirements
You need to comply with the following requirements to install the IDERA Dashboard:
Microsoft .NET Framework version
4.0 or later
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.
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).
- 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)
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
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
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