2010-04-21
05:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
Thanks,
KFS
2 Replies
2010-04-27
10:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
2011-02-11
08:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
are the 44 exec statements in the event IDs the fields in the message log? Yes, i agree, i see millions of event id existiong connection 17. what did you decide to audit in the end?
