With the many needs (SOX, HIPAA, internal, etc.) for auditing sensitive data, what are the options available in the market place to audit SQL Server data and code changes? Do these products automatically collect the data as well as build reports and selectively alert on critical issues?
Below outlines the SQL Server auditing products on the market with URL's to the product for more information.
|ID||Offering||Data Changes||Code Changes||Auto Data Collection||Reporting||Real Time Alerting|
|2||GridApp Clarity's Auditing and Compliance||*||*||*||*||*|
|3||Idera Compliance Manager||*||*||*||*||*|
|5||Lumigent Audit DB||*||*||*||*||*|
|6||Quest Software SQL Watch||*||*||*||*|
|7||SQL Server Profiler||*||*||*|
|8||SQL Server Triggers||*||*||*|
If you know of additional SQL Server auditing products on the market, please let us know and we will update this tip. Please email the product\technology\tool to firstname.lastname@example.org.
- Assess you needs from both a business and technology perspective to understand who and what needs to be audited to meet legal or internal needs.
- Check out these products to determine if they meet your needs and then determine if these products save time and energy as opposed to building a custom solution.
- If so, download a trial of one or more of these products and see how they work as well as close the loop with the individuals identifying the needs to validate the needs are met.
- For additional auditing tips from MSSQLTips.com check out these tips:
Last Update: 12/6/2006
About the author
View all my tips