SQL Trace on SQL 2005. Performance hit?
Does RSA have any metrics around how much of a performance hit MSSQL server takes when the SQL traces are enabled?
I know, it depends, but say we use the latest default .sql file provided by RSA, newer hardware, working under a 50% performance load now and the server maintains a large, busy database.
I don't have any numbers, but I will tell you that we modified the sql script to only log those events that were necessary so that we didn't have to worry about taking a performance hit. The standard script can have a major performance hit...I have seen it spew millions of events a day. So, I would suggest that you go through the script and selectively audit.