Online Documentation for SQL Administrator for SQL Server
Welcome to EMS SQL Administrator!
SQL Administrator is a toolset for efficient SQL Server administration. It provides with a complete and easy-to-use set of tools for administering SQL Server. SQL Administrator is designed specifically for database administrators and allows performing administrative tasks in the fastest, easiest and most efficient way.
Key features:
- Performance monitoring in real-time
- Statistics Collector to collect statistics of the system and SQL Server performances
- Graphical comparison of statistics over different time periods to find performance bottlenecks
- Analysing trends of performance metrics over time
- Checking SQL Server health with Alarm Summary tool
- Well-described wizard system to backup/restore, attach/detach, check, shrink databases, rebuild/reorganize indexes
- Getting complete information about all database maintenance tasks including their schedule and status
- Storing, comparing and applying server configurations including server properties, configuration options, logins, database options, objects’ permissions
- Forecasting disk space exhaustion
- Analysing space utilization by drive, database or database objects
- Creating/editing/deleting SQL Server objects
- Viewing information about current server processes and locks of specific processes and objects
- Handy Query Management tool for SQL queries and script execution
- Ability to print almost any data of the program
- Support of SQL Server versions from 2000 to 2014
