 |
| Got a question about SQL Task Manager we haven't answered? Please email our support team. |
 |
 |
What is SQL Task Manager |
| When your database server slows down use SQL Task Manager universal diagnostic tool to troubleshoot the problem. See instant graphical and data views of the current performance of any SQL Server on your network.
As a database, 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.
As a developer or tester you can use SQL Task Manager to see all the T-SQL and stored procedures running against your databases. You can see how many times each piece of code has been executed and quickly find queries being repeatedly executed that can be converted to stored procs to create execution plans and so improving your query and application performance. |
|
|
What Does SQL Task Manager Do? |
| SQL Task Manager 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.
This tool makes capacity planning easy - see how much load is being put on the server and each database. Find out which queries and applications consume the most resources and determine if heavily used databases should be moved to another server or if hardware upgrades are required. |
|
|
Why Should I Buy SQL Task Manager? |
| SQL Task Manager is a feature-rich diagnosis tool for all members of your SQL Server team. You can instantly see what is happening on any SQL Server on the network and SQL Task Manager saves you time by delivering up to the minute database, user, network and application activity. It allows you to quickly end all connections to one database, or all databases on the server, so the server can be stopped or databases taken offline.
SQL Task Manager 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 Task Manager to instantly 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 Task Manager 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. |
|
|
Who Should Buy SQL Task Manager?/b> |
| SQL Task Manager is aimed at all members of your team who use, monitor and maintain SQL Servers on an everyday basis. SQL Task Manager provides constantly updated server information and shows how users, applications, stored procedures and T-SQL are consuming CPU, disk I/O and network resources. This tool provides a wide range of features useful in all aspects of administering, developing and testing SQL Server. |
|
|
How Often Should I Use SQL Task Manager? |
| You can constantly keep an eye on the changing state of your SQL Servers with SQL Task Manager. It can be used daily to review how each server is performing and check which users are logged in and which applications are connected to SQL Server.
If you need to take a database offline, then SQL Task Manager 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 Task Manager 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. |
|
|
Where Should I Install SQL Task Manager? |
| SQL Task Manager should be installed on the client PC. We recommend that it is installed on the local machine where you are most likely to be using it on a daily basis. Keep this tool close to hand to quickly diagnose a problem as soon as it happens. |
|
|
Is SQL Task Manager Safe to Use on My Production Server? |
| You can safely use SQL Task Manager on production servers. SQL Task Manager simply gathers information on the state of the server and its databases and refreshes this data on a timed basis.
You can pause this data gathering or set SQL Task Manager to refresh at a quicker or slower rate. SQL Task Manager performs no operations on the server other than gathering data, unless you use SQL Task Manager to end user connections or processes. |
|
|
Why Can't I See All Databases on the Current Server in the Databases Tab? |
| SQL Task Manager only displays databases that currently have connections. This allows you to focus only on those databases that are being used and may face problems. SQL Task Manager only shows databases with activity. |
|
|
Why Can't I End Connections to the Master Database? |
| SQL Task Manager only displays databases that currently have connections. This allows you to focus only on those databases that are being used and need monitoring or diagnosis. SQL Task Manager only shows databases with activity. |
|
|
Why Can't I End SQL Task Manager in the Applications or Processes Tabs? |
| In order to gather data SQL Task Manager needs to connect to the master database on the server. If you want to end all connections to the master database, please close SQL Task Manager first and then use another application such as SQL Server Management Studio, Enterprise Manager or Query Analyzer to end the connections. |
|
| ^ Top of Page |
|