ApexSQL Manage is a powerful tool for SQL Server instance management, offering capabilities such as instance discovery across the network, health checks, issue detection, comparison of SQL Server instances, and the generation of detailed documentation. It also allows for automated scheduling of key operations and SQL script execution to address identified issues. The tool ensures that best practices are followed and facilitates effective login management on multiple instances.

Features

• Discover SQL Server instances, SSRS, SSAS, and SSIS services across your network.
• Perform health checks on SQL Server instances to view and analyze statistics.
• Use predefined SQL scripts to fix health check issues automatically.
• Create SQL Server instance snapshots for comparison.
• Compare SQL Server instances and snapshots for differences.
• Generate documentation for SQL Server instances and snapshots in Word, PDF, HTML, or CHM formats.
• Automate operations and schedule tasks for all core features.
• Manage active SQL Server logins across multiple instances.
• Configure maintenance periods to prevent schedules from executing.
• Use advanced filtering options for health check results.
• Export results to formats like Word, PDF, or XML.
• Customize the tool’s visual interface to fit your preferences.
• Receive email notifications for specific task events and outcomes.
• Easily schedule and automate core features, ensuring smooth and efficient instance management.