Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.Check out:
http://support.microsoft.com/default.aspx/kb/906344
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.|||Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>|||You'll have to tell us what you "configured".
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:eidPzzAyGHA.3844@.TK2MSFTNGP06.phx.gbl...
Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>
Showing posts with label sp_who. Show all posts
Showing posts with label sp_who. Show all posts
Monday, March 19, 2012
Blocks
Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.Check out:
http://support.microsoft.com/default.aspx/kb/906344
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.|||Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>|||You'll have to tell us what you "configured".
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:eidPzzAyGHA.3844@.TK2MSFTNGP06.phx.gbl...
Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.Check out:
http://support.microsoft.com/default.aspx/kb/906344
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
Hello,Why an sp autoblock '
If exec my sp and view the connections with sp_who i watch te id of my
connection in the column blk of the result.
Why succedes this '
Thanks in advance.|||Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>|||You'll have to tell us what you "configured".
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
news:eidPzzAyGHA.3844@.TK2MSFTNGP06.phx.gbl...
Thanks !!!
But,what i configured in the server because the time of blocked is over 20
seconds ?
Thanks in advance.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23mmGQy%23xGHA.2516@.TK2MSFTNGP06.phx.gbl...
> Check out:
> http://support.microsoft.com/default.aspx/kb/906344
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Luis Tarzia" <tarzialuis@.ciudad.com.ar> wrote in message
> news:euJLKt%23xGHA.4840@.TK2MSFTNGP04.phx.gbl...
> Hello,Why an sp autoblock '
> If exec my sp and view the connections with sp_who i watch te id of my
> connection in the column blk of the result.
> Why succedes this '
> Thanks in advance.
>
Thursday, March 8, 2012
Blocking
Hi everybody
I have a process in a SQL Server 2000 database that is blocking itself, is
that normal? The sp_who output looks like this:
Process id: 80
Hostname: XXXXX
user: XXX
...
...
Blkby: 80
I would appreciate any advice.
Harold
It depends. It can happen and it may or may not be
problematic. Check the following article - this may be what
you are seeing:
The blocked column in the sysprocesses table is populated
for latch waits after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
-Sue
On Mon, 9 Oct 2006 10:19:01 -0700, haRold
<haRold@.discussions.microsoft.com> wrote:
>Hi everybody
>I have a process in a SQL Server 2000 database that is blocking itself, is
>that normal? The sp_who output looks like this:
>Process id: 80
>Hostname: XXXXX
>user: XXX
>..
>..
>Blkby: 80
>I would appreciate any advice.
>Harold
I have a process in a SQL Server 2000 database that is blocking itself, is
that normal? The sp_who output looks like this:
Process id: 80
Hostname: XXXXX
user: XXX
...
...
Blkby: 80
I would appreciate any advice.
Harold
It depends. It can happen and it may or may not be
problematic. Check the following article - this may be what
you are seeing:
The blocked column in the sysprocesses table is populated
for latch waits after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
-Sue
On Mon, 9 Oct 2006 10:19:01 -0700, haRold
<haRold@.discussions.microsoft.com> wrote:
>Hi everybody
>I have a process in a SQL Server 2000 database that is blocking itself, is
>that normal? The sp_who output looks like this:
>Process id: 80
>Hostname: XXXXX
>user: XXX
>..
>..
>Blkby: 80
>I would appreciate any advice.
>Harold
Blocking
Hi everybody
I have a process in a SQL Server 2000 database that is blocking itself, is
that normal? The sp_who output looks like this:
Process id: 80
Hostname: XXXXX
user: XXX
..
..
Blkby: 80
I would appreciate any advice.
HaroldIt depends. It can happen and it may or may not be
problematic. Check the following article - this may be what
you are seeing:
The blocked column in the sysprocesses table is populated
for latch waits after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
-Sue
On Mon, 9 Oct 2006 10:19:01 -0700, haRold
<haRold@.discussions.microsoft.com> wrote:
>Hi everybody
>I have a process in a SQL Server 2000 database that is blocking itself, is
>that normal? The sp_who output looks like this:
>Process id: 80
>Hostname: XXXXX
>user: XXX
>..
>..
>Blkby: 80
>I would appreciate any advice.
>Harold
I have a process in a SQL Server 2000 database that is blocking itself, is
that normal? The sp_who output looks like this:
Process id: 80
Hostname: XXXXX
user: XXX
..
..
Blkby: 80
I would appreciate any advice.
HaroldIt depends. It can happen and it may or may not be
problematic. Check the following article - this may be what
you are seeing:
The blocked column in the sysprocesses table is populated
for latch waits after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
-Sue
On Mon, 9 Oct 2006 10:19:01 -0700, haRold
<haRold@.discussions.microsoft.com> wrote:
>Hi everybody
>I have a process in a SQL Server 2000 database that is blocking itself, is
>that normal? The sp_who output looks like this:
>Process id: 80
>Hostname: XXXXX
>user: XXX
>..
>..
>Blkby: 80
>I would appreciate any advice.
>Harold
Wednesday, March 7, 2012
Blocking
Hi everybody
I have a process in a SQL Server 2000 database that is blocking itself, is
that normal? The sp_who output looks like this:
Process id: 80
Hostname: XXXXX
user: XXX
..
..
Blkby: 80
I would appreciate any advice.
HaroldIt depends. It can happen and it may or may not be
problematic. Check the following article - this may be what
you are seeing:
The blocked column in the sysprocesses table is populated
for latch waits after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
-Sue
On Mon, 9 Oct 2006 10:19:01 -0700, haRold
<haRold@.discussions.microsoft.com> wrote:
>Hi everybody
>I have a process in a SQL Server 2000 database that is blocking itself, is
>that normal? The sp_who output looks like this:
>Process id: 80
>Hostname: XXXXX
>user: XXX
>..
>..
>Blkby: 80
>I would appreciate any advice.
>Harold
I have a process in a SQL Server 2000 database that is blocking itself, is
that normal? The sp_who output looks like this:
Process id: 80
Hostname: XXXXX
user: XXX
..
..
Blkby: 80
I would appreciate any advice.
HaroldIt depends. It can happen and it may or may not be
problematic. Check the following article - this may be what
you are seeing:
The blocked column in the sysprocesses table is populated
for latch waits after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
-Sue
On Mon, 9 Oct 2006 10:19:01 -0700, haRold
<haRold@.discussions.microsoft.com> wrote:
>Hi everybody
>I have a process in a SQL Server 2000 database that is blocking itself, is
>that normal? The sp_who output looks like this:
>Process id: 80
>Hostname: XXXXX
>user: XXX
>..
>..
>Blkby: 80
>I would appreciate any advice.
>Harold
Subscribe to:
Posts (Atom)