profiler to monitor security events

  • One of our production servers is undergoing a security audit.  It was suggested that, using SQL Server Profiler, I audit every security event possible.  I am quite concerned about the possible impact upon the server's performance and about the space this will require.  Does anyone have a good suggestion on how to handle this?

    Thank you.

  • Server side traces use less resources, but you have to worry about file or table contention on the disks. You can always transfer the data to a remote server on a regular basis.

    the fewer events, the less taxing

Viewing 2 posts - 1 through 1 (of 1 total)

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