SQL Server Audit
AmpleLogic SQL Server Audit lets you keep track of all the resources on your SQL server, as well as the permissions that are granted to those resources.
Organizations have a large number of SQL servers and databases. The goal of having 99 percent SQL server uptime is a significant issue. It is tough to keep track of what has changed in the environment, whether it was predicted, how a database is expanding, how capacity planning is done, and so on. As with most DBA, time is always of the essence when gathering information and putting it in writing.
To achieve 99.9% uptime on SQL servers, various SQL server resources and SQL server databases need to be monitored simultaneously. Because they must also manage illegal access to all SQL server resources, database administrators have a difficult job. This involves monitoring several resources and enlisting the help of numerous personnel.
SQL server statistical reports
SQL Server Instance level Auditing.
- SQL Server Data Base Info report
- SQL Server level changes
- SQL Server permissions changes
- SQL server Logon Failures
- Login, user and role reports
- SQL error log collection
- Disk drive capacity overview
- Server Disk Drive Growth
- SQL server up time
- SQL Server Database Level Auditing
- SQL Server Stored procedure level changes
- SQL Server Table level changes
SQL Server Audit Reports and alerts:
- Alert for creation or deletion of SQL databases
- Alert for SQL server database setting change
- Alert for SQL server backup and log backup not done
- Alert for SQL server disk drive addition or removal
- Alert for SQL server disk space
- Alert for SQL server login added or removed
- Alert for SQL database user added or removed
- Alert for SQL server role added or removed