Audit DB is a powerful but rarely used tool.
Apparently was designed with store flexibility (write all possible event types and their measures in just two tables), rather than with performance or report usability, in mind.
So even if you installed Audit Universe and fixed it for your database flavor, installed audit reports and figured out what are they for, or created your own reports, chances are performance will be discouraging for using it or/and you will be providing not compatible event/event details in the prompts.
BiWhy approach:
Connect to Audit DB with BiWhy just by providing a connection string and JDBC driver, the most used ones are shipped with BiWhy for convenience.
With a single click collect Audit DB metadata – available events (Refresh, Logon, Error,…), details (size, duration,…), statuses (successful, failed…), users, servers,...
Retrieve events, filtering by what you need. Double click will insert keys with comments from metadata to SQL query.
Double-click on results to drill down or add an additional window for side investigation.
Pros:
Quick start
Better performance – proven in several critical engagements
More meaningful results – you know your query and avoid not compatible events/details
Easy get to know and use metadata (what is available, filter for yourself or query)
Quick query test, for example with TOP 1
Quick drill down
Cons:
A bit of technical interface, subject to improvement by request
Requires basic SQL knowledge
Suggestions:
Check Errors, top Size, and top Duration events
If you have problems with some particular Server, check what is running on it Object Name and who is running it User
Example:
To increase your Audit DB effectiveness and avoid overloading the system with events collection, check what is in it and get rid of objects that you don’t need.
Below is an example of Audit DB (45 days retention) with 1 billion rows in the Details table, among which ~630M rows are just useless overhead information of (User Group Name/ID) which could be turned off just by unchecking one check box.
留言