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.com/sf_block_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
>

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,
florence
Maybe this article will help you:
http://www.sql-server-performance.co...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
>
sql

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
>

Deadlock Issue

Hi all,
I am using Visual Foxpro as front end and SQL Server at
backend. This is a Client/Server Database App. I am facing
deadlock problems in this environment. Please provice me
any help in this regard.
Thgank in advance.
That is a very open eneded question. You can read SQL Server 2000 Books
Online to understand, what a dead lock is, and how to avoid and troubleshoot
deadlocks in SQL Server Books Online. Believe me, there's a lot of
information in Books Online.
Additionally, you could try out the following link, to learn how to log
additional information about deadlocks into SQL Server error log:
http://vyaskn.tripod.com/administration_faq.htm#q14
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Muhammad Saleem" <anonymous@.discussions.microsoft.com> wrote in message
news:958501c49711$dbde1760$a601280a@.phx.gbl...
> Hi all,
> I am using Visual Foxpro as front end and SQL Server at
> backend. This is a Client/Server Database App. I am facing
> deadlock problems in this environment. Please provice me
> any help in this regard.
> Thgank in advance.