RE: spid changes when execting async queries

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 18:15:08 GMT

It sounds like the queries themselves are spawning new connections.
Why not use our script to troubleshoot the blocking issue ?

271509 INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/?id=271509

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: Row and Table Level Locking
    ... 224453 INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking ... Incomplete Transaction May Hold Large Number of Locks and Cause ...
    (microsoft.public.sqlserver.clients)
  • Re: Triggering After an update
    ... 224453 INF: Understanding and Resolving SQL Server 7.0 Blocking Problem ... How to Monitor SQL Server 2000 Blocking ...
    (microsoft.public.sqlserver.programming)
  • Re: Triggering After an update
    ... attempted to run my trigger it worked just fine, no blocking. ... > 224453 INF: Understanding and Resolving SQL Server 7.0 Blocking Problem ...
    (microsoft.public.sqlserver.programming)
  • SQLServer slows down after some time
    ... To troubleshoot this issue, there would be several other things to try and ... Moving SQL Server databases to a new location with Detach/Attach ... The probably cause of the issue is Blocking. ... Support Service, and our support professionals will work on with you ...
    (microsoft.public.sqlserver.server)
  • Re: Norton Firewall Blocking my access to the Internet
    ... Had a similar problem with zone alarm, had to dummy down the content ... blocking. ... > After I had a technical person isolate and try to troubleshoot the ...
    (comp.security.firewalls)
Quantcast