Manage disaster recovery, monitor agent jobs, and
defragment indexes
Database administrators need reliable, real-time information on the status, health, and security of their
backups, restores, agent jobs, and index fragmentation. They also need to minimize the time and effort
spent on the routine maintenance of databases across the organization. To address this challenge,
benefit from IDERA’s bundle of top tools for SQL Server maintenance.
Manage disaster recovery
Manage and monitor
agent jobs
Defragment indexes
SQL Maintenance Suite provides complete SQL Server maintenance, from backup andrestore management, to agent job management and monitoring, and index defragmentation. Save almost 20% versus buying each product separately. Plus, save an additional 20% when you purchase in the online store.
Manage backups and recovery
Backup hundreds of servers on-premises and in the cloud from a single console. Eliminate failed or missed backups with alerting and network resiliency. Leverage multiple flexible recovery options for instant data access and recovery. Backup faster and save storage space with automated dynamic compression.
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.
Defragment indexes
Automate defragmentation policies to multiple databases, tables, and indexes. Quickly find the worst impacting indexes in a color-coded dashboard. Customize triggers to start and stop defragmentation. Review resource utilization before defragmentation to avoid contention. Reduce page splits with index fill factor settings.
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