Use the Features of SQL Enterprise Monitor to Keep SQL Server Running


	Query Monitoring
	See the top 100 most frequently executed queries. Use this tab to find dynamic transact-SQL to convert to stored procedures. Find queries that are repeatedly executed which can be converted to stored procs, so SQL Server can create a query plan. Stored procedures return results quicker than ad-hoc code, because the query plan makes use of indexes and statistics. Doing this will boost your SQL Server performance.

	User Monitoring
	Instantly find all users who are logged into your SQL Server. Quickly see the time each connected user was last active and how long it has been since they last ran a query. You can see who still has a connection to a database that may need taking offline. You can end individual and/or inactive connections, freeing up resources for other users. Or, once you see that there are no users who are still running queries, you can use the Databases tab to end all connections to a database.

	Application Monitoring
	View all applications connected to the server and the command the application is running. Instantly see which software applications are placing a load on the server and end those that are no longer required in order free up resources for other applications. An easy way to speed up your SQL Server.

	Database Monitoring
	Monitor databases with open user connections. This data tab shows database CPU, disk I/O and memory consumption allowing you to easily spot those databases requiring more hardware so you can de-consolidate your servers. You can quickly end all connections to a database to perform maintenance tasks or take it offline. This saves manually having to end each user connection through code. It also means you can end all inactive connections to a database to free up resources for other users, returning results faster.

	Process Monitoring
	Use the processes tab to see all processes running on the SQL Server. See in seconds which processes are consuming the most resources on your server. You can view all currently running processes, or just user processes. Identify which system processes or NT users are consuming the most I/O, CPU and memory on the server and end processes which are causing server problems by using up too much resource.

	Performance Monitoring
	For an instant and graphical view of how much server resource is being consumed by a SQL Server on your network take a look at the performance tab. You will see how much network traffic is passing to and from the SQL Server, how many packet errors have occurred on SQL Server connections and how much disk activity is caused by SQL Server reading and writing to disk. Use this tab to monitor a server as part of your performance tuning plan so you can see where CPU, disk I/O and memory is in need of upgrade.


	View all applications currently connected to the server and see what commands are running.

	End applications and processes connected to the server to free up resources.

	Immediately see how many connections there are to the server, how many processes are running and the total CPU time used since the server was started.

	See which NT and SQL Server users are connected to the server, how much CPU, disk I/O and memory each process is consuming and end processes.

	Instantly see how many connections there are to each active database on the server.

	End all connections to a database so it can be taken offline or the server can be restarted.

	View how much CPU, disk I/O and memory is being consumed by all the connections to each database.

	See how many open transactions there are on any database and how long it has been since a command was executed against the database. This makes it easy to stop the server or take the database offline if no connections are actually active.

	Immediately see all the T-SQL and stored procedures running against active database and how many times each has been executed. Quickly find queries being repeatedly executed that can be converted to stored procs so execution plans will be created.

	Discover how many bytes and how many pages queries are using and locate troublesome T-SQL statements that are consuming too much server resources and need tuning.

	Keep databases secure by seeing in an instant which users are connected to the server. Find out when each user was last active and how much time has passed since the user ran a query against a database. Inactive connections can then be killed off.

	Instantly see how much disk I/O SQL Server is using, the total number of reads, writes and errors on the disk.

	Monitor network activity and see how many packets are being sent to and from the server and how many errors are occurring.

	Make capacity planning easy – see how much load is being put on the server and each database in turn. And find out which queries and applications consume the most resources.

	Determine if heavily used databases should be moved to another server or if hardware upgrades are required.