Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2007-11-15 : 21:26:11
|
| Hi all, Does anyone have the traceflag 1204 & 3506 turn on 24x7? does it have any performance impact at all? I do sometimes got deadlock issue and want to find that out, but no info unless i got these 2 flag turn on, since cannot replicate the error in a given time....but want to find out does anyone have performance impact when they use it?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-15 : 23:23:08
|
| Didn't see big impact on my server since they do nothing if there is no deadlock. |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-11-16 : 02:01:22
|
| Cool, thanks for that, might as well put that on. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-20 : 18:10:56
|
| No i have them on all the time... |
|
|
|
austdev
Starting Member
3 Posts |
Posted - 2007-11-27 : 02:45:07
|
| I have them on when required, but the seem to reset themselves after a server reboot... |
|
|
|
|
|
|
deadlock traceflag