SQL Enterprise Monitor is the feature-rich diagnostic tool for instant visibility into what's going on with your SQL Servers.
Find the problem fast by drilling down into up-to-the-minute performance information for servers, databases, users, queries and hardware.
This tool helps you quickly make decisions based on up to the minute performance data.
It shows how resources are being consumed enabling you to drill down by database, application, user or query.
SQL Enterprise Monitor offers two views of your SQL Servers: the Enterprise View allows you to check and compare servers and services across
your entire network. Switch to the My SQL Servers view to drill down into specific performance data for a single server.
|
 |
 |
|
 |
View the operational status for
services including SQL Server, SQL Agent, DTC and Reporting Services to ensure
your critical services stay running. See which services are running,
stopped, paused or not installed. |
|
|
Compare the security, properties
and settings of all your servers on the network, including Login Audit Level,
Security Mode, Version Numbers and current Service Pack. Keep all your servers
configured correctly and up to date with security fixes. |
|
|
See all the scheduled jobs that
have failed in the last 24 hours to ensure essential tasks and
maintenance jobs get done. |
|
|
Register and monitor unlimited
SQL Servers - pay one price however many servers you have! |
|
|
 |
|
|
Quickly see how well your server
is performing using the Dashboard tab. See how many processes are
running, the number of open and blocked transactions and jobs that failed to
run. |
|
|
Monitor the load on your server
and see databases have the highest consumption of CPU, memory and disk I/O:
essential for your de-consolidation work. |
|
|
Are all of your databases being backed
up? Don't lose critical data (or your job!). The Database Backup
History tab will tell you if each database has been backed up, when the last
backup took place and who did it. |
|
|
Find queries that are repeatedly
executed and can be converted to stored procs and make use of query plans.
Stored procs return results quicker than ad-hoc code, because query plans
can make use of indexes and statistics. |
|
|