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.