sunnyepgc (9/2/2015)
I do not have sufficient permission to add deadlock trace.Actually I am inserting new records into Target table (say Table B) using Merge statement (WHEN NOT MATCHED), I have replaced this with Left Join and didn't get any deadlock error so far,while running parallel.I will keep you posted,in case of any.
You don't need to add trace to get deadlock information. It's automatically captured by the system_health extended event session which runs automatically. You can pull the information right out of there[/url].
It sounds like you may have tuned the query and that could help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning