EMS SQL Administrator for SQL Server

What is EMS SQL Administrator for SQL Server?

EMS SQL Administrator for SQL Server is a set of tools for efficient SQL Server administration. It provides a complete and easy-to-use set of tools for administering SQL Server. SQL Administrator is designed specifically for database administrators and enables you to perform administrative tasks faster, easier, and more efficiently.

SQL Administrator lets you manage maintenance tasks, monitor performance schedule, frequency, and last execution result. It detects and notifies about possible failures, collects performance statistics, encounters performance bottlenecks, predicts their occurrence, and exhausts disk space. It allows you to easily find server security vulnerabilities and manage permissions. Includes tools to manage objects, monitor activities, and view server logs.

Core features

• Monitoring the most important performance indicators.
• Statistics Collector to collect system performance and SQL Server statistics.
• Graphical comparison of statistics in different periods to find performance bottlenecks.
• Analyzing performance metrics trends over time.
• Checking the integrity of the server with the alarm summaries tool.
• Well-described wizard system for backing up/restoring, attaching/detaching, checking, reducing databases, rebuilding/reorganizing indexes.
• Getting complete information about all database maintenance tasks, including schedule and status.
• Managing SQL Server configurations.
• Prediction of disk space exhaustion.
• Analyzing the utilization of space by unit, database, or database objects.
• Easy management of SQL Server objects.
• Effective security management.
• Handy Query Management Tool for SQL Query and Scriptexecution.
• Ability to print almost all program data.
• Monitoring the most important performance indicators.
• Viewing system and SQL Server performance counters in real time.
• Complete summary information on the server and database with important data highlight.
• Displaying information about current server processes and locks of specific processes and objects.
• Viewing SQL Server and system logs.

System requirements

Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 2012 Server;

.Net Framework 2.0;

.Net Framework 4.0 (for SQL Server 2012 maintenance plans)

512 MB of RAM or more;

70 MB of space available in HD for program installation;

Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution is recommended;

Microsoft mouse or compatible pointing device;

MDAC (Microsoft Data Access Components) ou SQL Server Native Client;

SQL Server 2000 local or remote, SQL Server 2005, SQL Server 2008, SQL Server 2012, or SQL Server 2014 (we do not support SQL Server Compact Edition).