 |
|
Got a question about SQL Enterprise Monitor we haven't answered?
Please email our support team. |
|
|
|
 |
What is SQL Enterprise Monitor |
| When your database server slows down use SQL Enterprise Monitor 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 Enterprise Monitor 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 Enterprise Monitor Do? |
| 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.
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 Enterprise Monitor? |
| SQL Enterprise Monitor 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 Enterprise Monitor 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 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 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 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. |
|
|
|
|
Who Should Buy SQL Enterprise Monitor?/b> |
| SQL Enterprise Monitor is aimed at all members of your team who use, monitor and maintain SQL Servers on an everyday basis. SQL Enterprise Monitor 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 Enterprise Monitor? |
| You can constantly keep an eye on the changing state of your SQL Servers with SQL Enterprise Monitor. 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 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. |
|
|
|
|
Where Should I Install SQL Enterprise Monitor? |
| SQL Enterprise Monitor 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 Enterprise Monitor Safe to Use on My Production Server? |
| You can safely use SQL Enterprise Monitor on production servers. SQL Enterprise Monitor 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 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. |
|
|
|
|
Why Can't I See All Databases on the Current Server in the Databases Tab? |
| SQL Enterprise Monitor 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 Enterprise Monitor only shows databases with activity. |
|
|
|
|
Why Can't I End Connections to the Master Database? |
| SQL Enterprise Monitor 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 Enterprise Monitor only shows databases with activity. |
|
|
|
|
Why Can't I End SQL Enterprise Monitor in the Applications or Processes Tabs? |
| In order to gather data SQL Enterprise Monitor needs to connect to the master database on the server. If you want to end all connections to the master database, please close SQL Enterprise Monitor first and then use another application such as SQL Server Management Studio, Enterprise Manager or Query Analyzer to end the connections. |
|
|
|
| Top of Page |