473,385 Members | 1,569 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

SPID in Blk By is itself

I am seeing intermittent blocking problems. The strange part of it is,
that the SPID listed in the Blk By column is the same as the SPID that
is being blocked.

Has anyone seen this before, or have any idea what this may suggest?

Dec 29 '06 #1
1 2569
Absinthe (Br**********@gmail.com) writes:
I am seeing intermittent blocking problems. The strange part of it is,
that the SPID listed in the Blk By column is the same as the SPID that
is being blocked.

Has anyone seen this before, or have any idea what this may suggest?
http://support.microsoft.com/default.aspx/kb/906344 tells you all about it.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 29 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Travis L. Alltop | last post by:
Is there an easy way to do this? I can see the SPID on SQL but its hostname is just the Metaframe Server, and that does not tell who it belongs to on that server when there is multiple users on...
2
by: Paul | last post by:
Is there a way to get the SPID at runtime (the server-side connection/process ID, which you can see in the management/current_activity/process_info area in Enterprise Manager) from an active...
1
by: Matik | last post by:
Hello 2 all, Maybe my question can be very stupid, but I'm a little confused. When I run sp_who on my database, I see one process (accessing remotely my database from another database on another...
2
by: JimLad | last post by:
Hi, In an existing ASP/ASP.NET 1.1 app running on IIS 6, I need to RELIABLY pass the logged in username through to the SQL Server 2000 database for auditing purposes. The current method is...
1
by: Agnes | last post by:
when One user open the application, he will access around 5 database so there will be 5 spid in the sql server , right? if there are 200 hundres user , there will be 1000 right?
7
by: =?Utf-8?B?S2plbGwgQnJhbmRlcw==?= | last post by:
Is there a way to get unique @@SPID to database when programming solutions for IIS in ASP. When trying I realize that the actual client/user against MSSQL database is IIS, not the currently...
1
by: liquidfirex | last post by:
I have looked at all documentation I can find but still cannot find the answer to my simple question! When connection pooling is enabled, all individual connections still maintain their own SPID...
1
by: Yoda | last post by:
Hi, which is the syntax for a stored procedure that return to me the exact @@SPID of my current connection? I'm using ADO in VB6 and i want to obtain @@SPID Thank u Rob
3
ganeshkumar08
by: ganeshkumar08 | last post by:
Hello.. Can any one give me brief explaination regarding @@SPID. And where we have to use it and to use it.. Ganesh
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.