MS SQL Server monitoring
Many organizations use Microsoft (MS) SQL Server as their database server. While there is a lot of awareness on the importance of monitoring database transactions, the importance of tracking SQL Server activity itself is less appreciated. There are several uses of monitoring MS SQL Server logs, such as performing privileged user activity analysis, tracking SQL Server changes to server level objects, monitoring server startups and shutdowns, and more.
EventLog Analyzer automatically collects MS SQL Server activity logs and helps you keep track of the log information, making it the ideal MS SQL Server monitoring tool. You can also analyze SQL Server changes with multiple predefined reports, and features such as report drill down and filtering, alerts, log search, archival and more. EventLog Analyzer thus also serves as an MS SQL Server log analyzer and management tool.
- Privileged user activity analysis: Detect unauthorized access with successful and failed logon reports, keep track of permission and authority changes, identify the most frequent accesses, and more.
- Server object change tracking: Track user activity with reports on the creation, deletion, and modification of several server-level objects, such as server roles, server audit objects, server audit specification objects, and more.
- SQL Server activity monitoring: Monitor server activity such as server startups and shutdowns, backup and recovery, SQL trace activity, and more.
- Server event trend analysis: Analyze MS SQL server activity over time.
Database backup report | Database restoration report | Transaction log backup report | Admin authority changes report | Permission changes report | Owner Changes report | Created server roles | Dropped server roles | Altered server roles | Created Server Audits | Dropped Server Audits | Altered server audits | Created Server Audit Specifications | Dropped Server Audit Specifications | Altered Server Audit Specifications | Created Database Audit Specifications | Dropped Database Audit Specifications | Altered Database Audit Specifications | Changed Audit Sessions | Shutdown and Failure Audits | Trace Audit C2 On | Trace Audit C2 Off | Started Trace Audits | Stopped Trace Audits | Server Startups | Server shutdowns | Logons | Failure logons | Logout Accounts | Top logons based on user | Top logons based on remote hosts | Top failure logons based on users | Top failure logons based on remote hosts | Logons Trend | Failed Logons Trend | Event Trend report