Locks/Process ID

I have been trying to track down a database problem in which for some reason
when somebody enters in some data into the database it becauses unavailable
for the application. I looked under Locks/Proccess ID and found that one of
the proccess is 'blocking' can somebody elaborate as to what sort of
processes these are and what blocking means? In addition, about 5 minutes or
so later the application can enter in data again and the web site that uses
the database is available.... any ideas? Thank you.
Gabe,
We can tell nothing about the process, we do not have the information. About
blocking, the process is blocking a resource (table, index, row, etc.) and
for that reason other processes do not have access to the resource.
See "Understanding and Avoiding Blocking" in BOL for more info.
AMB
"Gabe Matteson" wrote:

> I have been trying to track down a database problem in which for some reason
> when somebody enters in some data into the database it becauses unavailable
> for the application. I looked under Locks/Proccess ID and found that one of
> the proccess is 'blocking' can somebody elaborate as to what sort of
> processes these are and what blocking means? In addition, about 5 minutes or
> so later the application can enter in data again and the web site that uses
> the database is available.... any ideas? Thank you.
>
>
|||I have posted screenshots of the issue the resource that is blocking says
its the table, index and row. here are the screenshots, thank you for the
help.
http://66.31.179.80/sql/screenshots.doc
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...[vbcol=seagreen]
> Gabe,
> We can tell nothing about the process, we do not have the information.
> About
> blocking, the process is blocking a resource (table, index, row, etc.) and
> for that reason other processes do not have access to the resource.
> See "Understanding and Avoiding Blocking" in BOL for more info.
>
> AMB
> "Gabe Matteson" wrote:
|||test
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:uNiskn2cFHA.228@.TK2MSFTNGP12.phx.gbl...
> I have posted screenshots of the issue the resource that is blocking says
> its the table, index and row. here are the screenshots, thank you for the
> help.
> http://66.31.179.80/sql/screenshots.doc
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:920757E2-C5E4-4421-8484-D398215531AF@.microsoft.com...
and[vbcol=seagreen]
one[vbcol=seagreen]
minutes
>
|||Dear Sir,
please run sp_who2 it will let you know which process is blocking
another process.
Regards.
ghemant
ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
View this thread: http://www.mswebservertalk.com/t-1870545056
|||Thank you.
"ghemant" <ghemant.1qtd4p@.no-mx.mswebservertalk.com> wrote in message
news:ghemant.1qtd4p@.no-mx.mswebservertalk.com...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
> View this thread: http://www.mswebservertalk.com/t-1870545056
>
|||Is there anyway to tell why a process is being blocked?
"ghemant" <ghemant.1qtd4p@.no-mx.mswebservertalk.com> wrote in message
news:ghemant.1qtd4p@.no-mx.mswebservertalk.com...
> Dear Sir,
> please run sp_who2 it will let you know which process is blocking
> another process.
> Regards.
>
> --
> ghemant
>
> ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
> View this thread: http://www.mswebservertalk.com/t-1870545056
>
|||A process is blocked when a lock cannot be obtained because another session
already has a lock on the requested resource and the requested lock type is
incompatible. Common causes of blocking include long-running transactions
and queries.
You can use DBCC INPUTBUFFER on the blocking spid to see the currently
executing (or last) SQL statement. Use DBCC UPENTRAN to identify the oldest
open transaction. See http://support.microsoft.com/kb/224453/EN-US/ for
detailed information on troubleshooting blocking problems.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gabe Matteson" <gmatteson@.inquery.biz.nospam> wrote in message
news:eTg013VdFHA.2212@.TK2MSFTNGP14.phx.gbl...
> Is there anyway to tell why a process is being blocked?
> "ghemant" <ghemant.1qtd4p@.no-mx.mswebservertalk.com> wrote in message
> news:ghemant.1qtd4p@.no-mx.mswebservertalk.com...
>
|||their's a tip to avoid blocking , see the below link.
http://www.sql-server-performance.com/blocking.asp
Regards.
ghemant
ghemant's Profile: http://www.mswebservertalk.com/member.php?userid=2348
View this thread: http://www.mswebservertalk.com/t-1870545056