July 9, 2014 at 6:50 am
Need recommendations on a good, easy to use --- SQL Server AUDITing tool... to capture many facets of who did what, when, how.. yaddy ya...
(I recently posted a similar ? on a need for an Inventory tool and got great feedback from u guys.. wound up using Microsoft's free Assessment & Planning tool)
We have over 600 SQL Servers in our organization... 1 group is using Idera's Compliance Mgr but is looking for other options
thanks in advance !
July 9, 2014 at 7:02 am
ApexSQL has a compliance product that has been out for a long time. Tell them TheSQLGuru sent you - maybe you can get a discount. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 9, 2014 at 7:48 am
I am not a fan, but you should at least take a look at the built-in functionality for auditing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 9, 2014 at 11:04 am
There are several products out there. I'm in the process of trying to find out what we want to audit and then picking the tool that does what we need best. I'm already leading toward Green SQL's product, http://greensql.com/product/database-activity-monitoring, because it doesn't make any changes to the database(s) or the SQL Server, but works like a firewall in front of the server. I haven't talked with them or demo'd it yet, but I like the idea behind it, especially when dealing with vendor databases who don't let you make database changes. Most of the other products out there use CDC, database triggers, DDL triggers, etc... to collect the data.
The thing I don't like about SQL Server's built-in auditing is that there isn't a built-in method to move the data to a central repository from each server. There is a tool on codeplex from the SQLCAT team called SQLAuditCentral, http://sqlcat.codeplex.com/wikipage?title=sqlauditcentral&referringTitle=Home
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 10, 2014 at 12:59 am
Express12 (7/9/2014)
Need recommendations on a good, easy to use --- SQL Server AUDITing tool... to capture many facets of who did what, when, how.. yaddy ya...(I recently posted a similar ? on a need for an Inventory tool and got great feedback from u guys.. wound up using Microsoft's free Assessment & Planning tool)
We have over 600 SQL Servers in our organization... 1 group is using Idera's Compliance Mgr but is looking for other options
thanks in advance !
You can also take a look at this application (http://www.sqlserveraudit.org) which makes database auditing secure and specific user activities and operations as per requirement. It helps to keep all record server audit action groups per-instance, and database audit actions per database. By archiving all the logs centrally, it allows to uphold compliance standards and regulations like SOX, HIPAA, PCI and GLBA.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply