As a DBA, network or security administrator you can immediately see where and how server resources are being consumed and how many users are connected to your databases, who is connected and what queries are running.

If you're a developer or tester you can use SQL Enterprise Monitor to see all the T-SQL and stored procs running against your databases. You can see how many times each piece of code has been executed and quickly find queries being repeatedly executed. These can then be converted to stored procs, thereby getting SQL Server to create execution plans and so improving your query and application performance.

Our cross-server settings comparison feature makes it easy to move from development to production by ensuring you have the same level of security and service pack installed and that the servers are consistent. This helps to reduce errors due to differences between the two systems.

SQL Enterprise Monitor gives you enterprise-wide visibility into your SQL Servers - and all on your desktop for just $395!

The enterprise view displays cross-server security and configuration settings. This makes it really easy to keep your important production servers consistent with each other. You can register as many SQL Servers as you have in your network. Using the enterprise view you can cross compare versions and editions, service packs, collation sequence, security and auditing settings and more.

Under this section you'll also find what we think is the most important tab. This is the Services tab and it shows you the service state of SQL Server, SQL Agent, DTC, SQL Browser, Full Text and Terminal Services. You'll see in just a glance which services are running, paused, stopped or not installed.

And if you're running a data warehouse operation, you'll be pleased to hear that you can check on Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS) too. Need to know if they're running, stopped or not even installed? No problem, you'll find this out too.

This tool makes also capacity planning easy. You can see how much load is being put on the server and each database. Find out which queries and applications are consuming the most resources and determine if heavily used databases should be moved to another server or if hardware upgrades are required.

With the single server spotlight view, SQL Enterprise Monitor gathers performance information for a selected SQL Server and shows how resources are being consumed by each database, application, user and query. The visual display makes it quick and easy to see what users and applications are affecting the performance. The dashboard view offers a speedy overview of running services and processes and any blocked transactions.

Phew, that's quite a lot in one tool!

SQL Enterprise Monitor helps you quickly make decisions based on up to the minute performance data. Find the problem fast and fix it before users are adversely affected. If there is a performance problem on the server, use SQL Enterprise Monitor to find out what the problem is, cutting down the time it takes to deal with support queries. React to situations quickly so databases users and customers are kept happy because the server is performing as it should be.

DBAs can instantly see what is happening on any SQL Server on the network and SQL Enterprise Monitor saves the administrator time by giving up to the minute details on performance, database, user, network and application activity. It allows DBAs to quickly end all connections to one database, or all databases on the server, so the server can be stopped or databases taken offline.

Connections that are consuming too many resources and preventing other users from accessing data can be stopped, so call center operatives don't keep customers waiting on the telephone whilst waiting for customer details to be returned from the database.

If you need to take a database offline, then SQL Enterprise Monitor makes it easy by showing which users are connected to the database and how long since the user was active. You can then use SQL Enterprise Monitor to end all the connections to the database before taking it offline for maintenance or backup, or perhaps restarting the server.

If you need to restore a database in your development environment to code or test against, you can quickly see if other developers are connected before taking the current database version offline to replace it with another version.

You can pause this data gathering or set SQL Enterprise Monitor to refresh at a quicker or slower rate. SQL Enterprise Monitor performs no operations on the server other than gathering data, unless you use SQL Enterprise Monitor to end user connections or processes.