FEATURE COMPARISON : SQL ENTERPRISE MONITOR 2009 v SQL TASK MANAGER 2007 FEATURE SQL TASK MANAGER SQL ENTERPRISE MONITOR Enterprise level view of all of your SQL Servers - Easily switch between helicopter view of all SQL Servers or drill down to individual metrics of a single server - Check if critical SQL Server and related services have stopped, across all SQL Servers - Determine at a glance which scheduled jobs have failed in the last 24 hours across ALL servers in your organization - Compare security auditing settings across all SQL Servers - Compare login authentication levels across all SQL Servers - Determine collation sequence settings across all SQL Servers - Quickly see SQL Server editions installed on each server at a glance. Ideal for reporting on legal licensing compliance - Instantly see SQL Server Service Pack levels to ensure consistent upgrading across your organization - Monitor unlimited servers for the same price - no per-server licensing costs - View all applications currently connected to the server See what commands are running on each connection Immediately see how many connections the server has Quickly see how many processes are running on the server View total CPU time used since the SQL Server was started See which NT and SQL Server users are connected to the server Determine how much CPU, disk I/O and memory each process consumes Quickly end SQL Server processes with a single mouse click Instantly see how many connections exist on each database Quickly kill 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 transactions are open on any given database Quickly determine how long it has been since a command was executed against a database 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, so you can target your performance tuning Discover how many bytes and how many pages your queries are using Locate troublesome T-SQL statements consuming too much server resources Secure databases by quickly checking which users are connected Find out when a user was last active Discover how much time has passed since a user ran a query against a database so that inactive connections can be killed off Instantly see how much disk I/O SQL Server is using, including 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 SQL 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 Find out which queries and applications are consuming the most resources Determine if heavily used databases should be moved to another server or if hardware upgrades are required Top of Page