SQL Audit

Question

SQL Audit

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

CavyPrincess (7/16/2010)
I had to research it the first time. At least this time, I knew the answer. My biggest excitement - actually remembering something "all the way" back to July 9 🙂
Cindy

That is one of the great things about this site. Even if in this case by accident, you keep coming here and new knowledge gets reinforced and you start to get a deeper understanding of how to use everything. Just this week I used 2 things I learned on SSC in production.:cool:

Tom Garth SSCertifiable Points: 6193 More actions · Answer 2

EASY MONEY!!!

This time:-P.

Tom Garth
Vertical Solutions[/url]

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

Ken SSCoach Points: 17191 More actions · Answer 3

Thanks for the freebie! Happy Friday everyone!

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 4

Apologies, we must have had a scheduling error out there. Still, a free point for everyone.

Jan Sorenson Mr or Mrs. 500 Points: 579 More actions · Answer 5

Deja-vu I think Steve saw the movie "Inception" and has gotten into our dreams, where he has manipulated our dreams thinking that we have already had this questions but we really haven't. Thanks for the bonus point.;-)

UMG Developer SSChampion Points: 13482 More actions · Answer 6

I figured you were testing short-term recall to see if people still remembered what they learned. 😉

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 7

Maybe, because there is confusion over C2 audit?

Limitations

The main limitation of the auditing is that it reduces the performance of the SQL Server. This happens due to saving the every action to the file. Second limitation is the hard disk space. These auditing files grow rapidly, which will reduce the disk space. According to the C2 , if it is not able to write to the trace file, SQL Server will be shutdown.

http://sqlhelpguide.wordpress.com/2009/07/01/basics-of-c2-auditing/

Jamie