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?
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