q; Tracing the deadlock

Hi,
I need to trace deadlock, one of article was mentioning â'QL Server
Profiler's Create
Trace Wizard to run the "Identify The Cause of a Deadlock" for SQL Server
7.0, is there any way I can do this in Sql Server 2000?INF: Analyzing and Avoiding Deadlocks in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;169960
Tracing Deadlocks
http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp
How to identify SQL Server performance issues, by analyzing Profiler output?
http://vyaskn.tripod.com/analyzing_profiler_output.htm
AMB
"JIM.H." wrote:
> Hi,
> I need to trace deadlock, one of article was mentioning â'QL Server
> Profiler's Create
> Trace Wizard to run the "Identify The Cause of a Deadlock" for SQL Server
> 7.0, is there any way I can do this in Sql Server 2000?
>

q; Tracing the deadlock

Hi,
I need to trace deadlock, one of article was mentioning “QL Server
Profiler's Create
Trace Wizard to run the "Identify The Cause of a Deadlock" for SQL Server
7.0, is there any way I can do this in Sql Server 2000?INF: Analyzing and Avoiding Deadlocks in SQL Server
http://support.microsoft.com/defaul...kb;en-us;169960
Tracing Deadlocks
http://www.sqlservercentral.com/col...ngdeadlocks.asp
How to identify SQL Server performance issues, by analyzing Profiler output?
http://vyaskn.tripod.com/analyzing_profiler_output.htm
AMB
"JIM.H." wrote:

> Hi,
> I need to trace deadlock, one of article was mentioning “QL Server
> Profiler's Create
> Trace Wizard to run the "Identify The Cause of a Deadlock" for SQL Server
> 7.0, is there any way I can do this in Sql Server 2000?
>

q; sp_executesql and speed

Hello,
I am using sp_executesql this to pass parameter to sql string and I am
seeing deadlock between sp_prepexec which does UPDATE with another UPDATE
done by another process. When it comes to speed and deadlock, would you
recomand not using sp_executesql?Hi
I don't think you blocking is caused by sp_executesql. Look at what you are
executing and make sure that it is properly optimized and the transactions
are short.
John
"JIM.H." wrote:
> Hello,
> I am using sp_executesql this to pass parameter to sql string and I am
> seeing deadlock between sp_prepexec which does UPDATE with another UPDATE
> done by another process. When it comes to speed and deadlock, would you
> recomand not using sp_executesql?
>

q; sp_executesql and speed

Hello,
I am using sp_executesql this to pass parameter to sql string and I am
seeing deadlock between sp_prepexec which does UPDATE with another UPDATE
done by another process. When it comes to speed and deadlock, would you
recomand not using sp_executesql?Hi
I don't think you blocking is caused by sp_executesql. Look at what you are
executing and make sure that it is properly optimized and the transactions
are short.
John
"JIM.H." wrote:

> Hello,
> I am using sp_executesql this to pass parameter to sql string and I am
> seeing deadlock between sp_prepexec which does UPDATE with another UPDATE
> done by another process. When it comes to speed and deadlock, would you
> recomand not using sp_executesql?
>