January 25, 2002 at 12:59 pm
How much extra load does setting trace flags cause? Does it depend on the flag? Has anyone found any of these useful? Has anyone had problems with any of these?
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
January 25, 2002 at 1:11 pm
Haven't seen anything on these. They must have overhead to process and send the data, but no idea how much.
Steve Jones
January 25, 2002 at 2:20 pm
I sometimes use the ones for deadlocks, thats about it though. Agree with Steve that they must add some overhead.
Andy
January 25, 2002 at 2:27 pm
Those are the ones that prompted this question. I am specifically considering using DBCC TRACEON(3605) and DBCC TRACEON(1204). Are these the ones you use?
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
February 5, 2002 at 2:26 pm
I didn't notice any major change when I added the one for deadlock and lock extended details. There is some overhead, and the best way I can tell you is to set up Performance Log and take a snapshot of memory, cpu and drive before and after the trace is turned on.
February 5, 2002 at 3:28 pm
February 5, 2002 at 4:20 pm
Thank you all for your responses. I'm going to try using them soon as we are getting enough deadlocks that it would be nice to know more about what is happening.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply