SQL Server Profiler Trace

[Didi]

I just ran a trace on a database that has been having
performance problem (slow running) for some time, and I
got a lot of of Locks Acquired and Locks Released from the
trace result. What could this explain about the poor performance.
Can some body please explain the Locks Acquired and Locks Released
to me.

THANKS!!!!!!

Hi Didi

when you do changes to the database (like update,delete), these
locks acquired and once the transactions are completed the
locks are released. It will be better if you use the filter
option in the profiler, it will help you filter out a query
which takes more resources (cpu time ) or duration or based
on application , this will help you narrow down your problem
and also to do a better analysis.




------------
Didi at 9/26/00 10:28:24 PM

I just ran a trace on a database that has been having
performance problem (slow running) for some time, and I
got a lot of of Locks Acquired and Locks Released from the
trace result. What could this explain about the poor performance.
Can some body please explain the Locks Acquired and Locks Released
to me.

THANKS!!!!!!