Hi,
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
Jerome
Have you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/defaul...v_04222005.asp
Paul
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>
|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>
|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jj" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>
|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>
|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>
Showing posts with label locked. Show all posts
Showing posts with label locked. Show all posts
Friday, March 9, 2012
process which lock himself??
Hi,
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
JeromeHave you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_04222005.asp
Paul
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> At a guess you are locking another process by the same user and not
>> locking the process that is doing the shrink, in that respect the locked
>> process is no different to any other!
>> If you posted your SQL Server version and the output of your sp_who2 it
>> would have been more informative.
>> John
>>
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>>
>|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> At a guess you are locking another process by the same user and not
>> locking the process that is doing the shrink, in that respect the locked
>> process is no different to any other!
>> If you posted your SQL Server version and the output of your sp_who2 it
>> would have been more informative.
>> John
>>
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>>
>
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
JeromeHave you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_04222005.asp
Paul
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> At a guess you are locking another process by the same user and not
>> locking the process that is doing the shrink, in that respect the locked
>> process is no different to any other!
>> If you posted your SQL Server version and the output of your sp_who2 it
>> would have been more informative.
>> John
>>
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>>
>|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> At a guess you are locking another process by the same user and not
>> locking the process that is doing the shrink, in that respect the locked
>> process is no different to any other!
>> If you posted your SQL Server version and the output of your sp_who2 it
>> would have been more informative.
>> John
>>
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>>
>
process which lock himself??
Hi,
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
JeromeHave you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/defau...
v_04222005.asp
Paul
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jj" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
JeromeHave you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/defau...
v_04222005.asp
Paul
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jj" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>
Subscribe to:
Posts (Atom)