[dba-SQLServer] Processes Causing Blockages SQL 2000

Steve Conklin (Developer@UltraDNT) Developer at UltraDNT.com
Wed Dec 1 12:32:19 CST 2004


Thanks, Marty, but I guess I should be more specific ... Enterprise
Manager is telling me who, and what command (that's where I see that
it's the ADO and SP calls).  Maybe I should x-post, but what I'm really
wondering about are root casues.  I don't think its my apps, since its
always different commands.




-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
MartyConnelly
Sent: Wednesday, December 01, 2004 12:57 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Processes Causing Blockages SQL 2000


Have a look at DBCC in BOL
You could run this SP to determine who or what process is locking and 
blocking
http://www.sommarskog.se/sqlutil/aba_lockinfo.html

Steve Conklin (Developer at UltraDNT) wrote:

>I have 10-12 Access 2k front-end applications against a SQL 2000 
>database.  There are about 70 users total.  Occaisionally, including 
>right now, they perform otherwise normal stuff that randomly causes 
>"blocking" on the server.  No one else can do anything when this 
>happens.  Make the offenders logout and re-boot, problem goes away for 
>2-3 weeks.  The thing that puzzles me the most is that it is always 
>"unbound" operations that do this (ADO commands and pass-thru queries),

>never any of the bound forms.
>
>I believe it may be latency on the network, but their admins insist 
>that couldn't be the case. Any advice?
>
>TIA
>Steve
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list