Sunday, March 25, 2012

deadlock/blocking in sql server

Hi,
My application using foxpro sometimes seems like hang and when connect to
sql server. I directly go to the sql server and use sp_lock to check whether
there is any thread is waiting and find out there is indeed one thread is
waiting and i use sp_who and can see one process got blocking. But these
things not happen in foxpro database. How i need to troubleshoot this
problem, what i can do so that i can prevent from blocking/deadlock. I have
a profiler and the profiler save the procedure. So, how i can check and
provent by using this profiler?
Thanks a lot.
regards,
florenceMaybe this article will help you:
http://www.sql-server-performance.c..._prevention.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Florencelee" <florencelee@.visualsolutions.com.my> wrote in message
news:O6oIkQavEHA.536@.TK2MSFTNGP11.phx.gbl...
> Hi,
> My application using foxpro sometimes seems like hang and when connect
to
> sql server. I directly go to the sql server and use sp_lock to check
whether
> there is any thread is waiting and find out there is indeed one thread is
> waiting and i use sp_who and can see one process got blocking. But these
> things not happen in foxpro database. How i need to troubleshoot this
> problem, what i can do so that i can prevent from blocking/deadlock. I
have
> a profiler and the profiler save the procedure. So, how i can check and
> provent by using this profiler?
> Thanks a lot.
> regards,
> florence
>

No comments:

Post a Comment