Criteria
| SQLDBManager Plus | Applications Manager | OpManager |
Mode of Monitoring
| JDBC
| JDBC
| WMI
|
General SQL Metrics
|  | | |
Monitor SQL Windows Host
| | | |
General Database Details
| | | |
| Monitor User specified queries in SQL | | |  |
Monitor SQL Jobs, view jobs history, view failed jobs history, create new jobs, perform admin operations in job
| | Monitor SQL Jobs only
| |
| Database Real-time snapshot like Tables details, Index Details, Fragmentation Details, VLF details, Recovery mode. | | | |
| Identify performance affecting SQL queries (Slow queries, CPU expensive queries, High I/O etc) based on Execution time, Database, Top n records. | | | |
| Monitor SQL Backup and Restore Details | | | |
| Monitor SQL Log Shipping | | | |
| Monitor SQL Sessions, session locks, deadlocks and kill SQL user sessions | | | |
List available SQL Users, Create / Edit / Manage SQL users
| | | |
| Option to Execute SQL Queries and SQL Jobs in case of errors | | | |
| Data file & Log file monitoring | | | |
| Replication Monitor to monitor the status of publications, subscriptions and replication agent details | | | |
| Edit SQL Configuration Details | | | |
| Option to perform database admin operations like Offline, Online, Delete etc., |  |  | |
| Support to monitor and manage the mirroring status of principal/mirror database and the related attributes. | | | |
| SQL Cluster monitoring support to monitor an SQL cluster's disk utilization,
storage, resource groups, network and node details. | | | |
| SQL Server audit activities over different time periods. You can view
audit events related to Login, Server, Database and Audit categories. | | | |
| Target Audience | SQL DBAs and SQL Developers | System Administrators | Network Administrators |
Uploading ....