|
A great solution for a multi -SQL Server environment. The Enterprise Edition is a unique management solution for any number of SQL Server databases from a single point.
Tree View of Multiple SQL Servers
A tree view shows all SQL Servers on the network with branches that expand to show each server’s databases.
Apply Actions to Multiple Databases
Simultaneously apply a single action or rule to any selected databases. Select the databases from any of the SQL Servers displayed on the tree branches using the familiar ctrl-click.
Single View of All SQL Servers
EZManage™ SQL makes it easy to monitor and prioritize problem areas across all SQL Servers at a glance. Powerful drill down functionality provides the ability to go from a top view of a list of SQL Servers down to a full description of an alert on a particular database in just three clicks. All of the properties, maintenance rules and alerts for all of your SQL Servers are visible within one mouse click from one main console.
Building Custom Maintenance Rules
Populate the Rules Repository with your own custom maintenance rules and then attach them to any single or group of databases with just a couple of mouse clicks from one central console.
Tracking Rules
Hover with a mouse over a rule in the Rules Repository and a convenient tool tip will display a mini report of the databases to which the rule is attached.
Control Rule Changes
Any time a change is made to a maintenance rule, it is automatically re-attached to all of the databases with that rule, ensuring the change is applied.
Centralized Job Control
The EZ Manage™ SQL Central Console puts you in control of your SQL Server environment from one convenient screen. Start or stop any number of jobs across multiple servers by simple ctrl-click from one central console. Sit back and watch the jobs run in parallel, while each job is executed according to their custom settings, previously defined.
Powerful Alerts
EZManage™ SQL provides great flexibility in setting up distribution lists for alert notifications. Create distribution lists per database so the alert will reach its owners. You can also create distribution lists per type of alert so the responsible experts are informed. Apply as many lists as needed to each alert. As always with EZManage™ SQL, it is easy to apply the same lists to multiple databases across any of the SQL Servers in just one click from the central console. Alert options
email/smtp/sms*(via external mail service)
Windows event log supports command and control systems (Tivoli by IBM, Open View by HP, MOM by MS)
Windows pop up alerts
Intelligent Database Optimization
EZManage™ SQL keeps your databases optimized as intelligently as you would, but with much less effort. Set the optimization schedules once, and let EZManage™ SQL perform de-fragmentation, shrink the log files, optimize statistics, analyze the indexes and re-index only when necessary. All of the optimization jobs are performed according to protocol and in a logical order that minimizes even trivial errors such as accidentally shrinking before backup.
Advanced Backup
The advanced backup and restore offered by EZManage™ SQL offers significant advantages over the standard tools offered by SQL Server. Backup is approximately 3 times faster than native SQL tools and uses highly advanced encryption algorithms. The advanced compression of EZManage™ SQL reduces your data down to 85% - 95% of its original size, enabling storage of more of your data for longer periods on the same hardware.
DRP Built In
Disaster recovery is built into EZManage™ SQL by sending the backup files off site by FTP, automatically. Choose the destination, set it up once, and let EZManage™ SQL send it for you automatically. The application includes powerful functionality for creating a new database from a backup file.
All In One Solution
EZManage™ SQL – Enterprise Edition is an "all in one" solution for SQL Server administration, including:
Central Console for multiple SQL Servers
Management
Backup & Restore
Monitoring
Alerts
DRP
And more...
|