Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2009-07-25 : 10:49:25
|
| Guys,I trying to implement auditing for the sql server 2008 database. I have looked at Change data capture feature of SQL Server 2008 and like the ways it creates new cdc schema with the option of creating under different file group. However there are no reports run off the cdc tables that end user can run to get the audit information, ofcourse we can spend development hrs to write an SSRs report to run of this table and each time when a table or column is added the corresponding SSRS report has to be created or modified. I was looking at the audit tools available, I ran into Apex SQL Audit and noticed that the toolprovides the report which is preset and does not require to reworked when a new table or columnis added. However the from database standpoint the biggest issue is the tool created triggers onany table that you choose to audit and writes to the tables created by the tool. The tablesare created on Primary file group, which can ofcourse be moved to different filegroup to avoidany performance bottlenecks to disk IO.Has anyone used CDC and/or Apex SQL, can you please share your experiences and provide inputs/suggestionsThanks |
|
|
|
|
|
SQL 2008 Auditing CDC Vs Apex SQL Audit