September 23, 2014 at 9:20 am
You have to specific with terminology here. A deadlock is a specific type of blocking that cannot be resolved without canceling/abending at least one task. Blocking can eventually clear itself up.
Are you seeing deadlocks or just blocking?
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
September 23, 2014 at 11:26 am
You need to figure out what is blocking the command. You can use the system_health session in SQL Server 2008 to pull the deadlock XML[/url].
From there you have to determine what process is causing the deadlock and adjust for it. If your users are executing actual T-SQL frequently they should build their queries to workaround or detect for deadlock errors.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply