Monitor performance, analyze workload, tune queries, defragment indexes, audit for compliance, manage security, and manage disaster recovery
Database administrators need reliable, real-time information on the status, health, and security of their databases. They also need to minimize the time and effort spent on the routine management of databases across the organization. To address this challenge, benefit from IDERA’s bundle of top tools for SQL Server management.
Monitor, alert, diagnose, and
report on performance
Analyze workloads and
tune queries
Defragment indexes
Manage disaster recovery
Audit for regulatory compliance
and manage security
SQL Management Suite provides complete SQL Server management, from performance monitoring, diagnostics, and tuning guidance to backup, recovery, compliance, and security management. Save 40% versus buying each product separately. Plus, save an additional 20% when you purchase in the online store.
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.
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.
Audit for regulatory compliance
Audit sensitive data and see who did what, when, where, and how. Monitor and alert on suspicious activity to detect problems. Satisfy audits with templates for standard regulations. Leverage pre-defined compliance reports and create custom views. Minimize server impact with a lightweight data collection agent.
Manage security and permissions
Identify existing vulnerabilities in SQL Server including managed cloud instances Manage, review, and update security policies. Rank protection with distinct security levels. Scrutinize rights, files, directories, weak passwords, operating system, and more. Analyze and report user permissions and groups across databases.
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.
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