 |
 |
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. |
|
 |
Now You Know the Benefits, Take a Look At the Features of SQL Task Manager |
|