Tools for managing SQL Server and idera optimization
The IDERA provides additional management tools for database performance to manage the performance of SQL Server, including: The SQL Diagnostic Manager offers physical and virtual performance monitoring with the ability to set alerts on metrics important performance database ; It can also be used to monitor and identify SQL queries with poor performance. SQL Doctor provides expert advice and assistance with query plans. It can integrate with SQL Diagnostic Manager. SQL BI Manager monitors and manages the health and availability of Microsoft SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services to optimize the performance of these business intelligence services. SQL Defrag Manager identifies database objects that require reorganization and helps the DBA schedule defragmentation tasks to repair hot spots, page splits, redefine space, and fill factor settings.
