Hi,
I'm seeing a few deadlocks on my SQL 2005 production database and wondered what i could expect if i switch on the trace flag 1222. Can this cause more deadlocks to occur? Will the performance of SQL degrade? Is it safe to have this flag set on a production server or is there another method you would recommend?
Thanks
Martin
In general every extra logging causes a little performance impact but it will not cause extra deadlocks. The performance impact is more acceptable than having deadlocks so until you have found the root cause of these deadlocks I would not hesitate to use the trace flag.
Do not bother too much about the performance impact however, it is very little and definitely less than the cost of having deadlocks.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
No comments:
Post a Comment