|
Home > Archive > MS SQL Server > July 2005 > temp.dbo.##lockinfo
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
temp.dbo.##lockinfo
|
|
| salvoWJ 2005-07-29, 7:23 am |
| Hello!
I have a problem on my sql server, It's very slow, and some simple
query have a long time execution.
I look on EM->management->Current Activity->Locks object, and I look
for a strange lock on temp.dbo.##lockinfo54
TAB/X/GRANT/Xact/##lockinfo54 on right click -> "dbcc inputbuffer(54)".
I see that this lock I associated to the process ID of my login with
EM...
How can I resolve this problem?
On process information I see that the process associated with this lock
have the follow information:
runnable/2/SELECT INTO/ MS SQLEM/0/not waiting/CPU:844/IO:0/Memory:15
| |
| Tibor Karaszi 2005-07-29, 7:23 am |
| This is enterprise manager itself, generating the data that Current Activity is based on. This is
not your performance problem.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"salvoWJ" <salvatore.toro@volawindjet.it> wrote in message
news:1122620712.451547.36840@f14g2000cwb.googlegroups.com...
> Hello!
>
> I have a problem on my sql server, It's very slow, and some simple
> query have a long time execution.
> I look on EM->management->Current Activity->Locks object, and I look
> for a strange lock on temp.dbo.##lockinfo54
> TAB/X/GRANT/Xact/##lockinfo54 on right click -> "dbcc inputbuffer(54)".
>
> I see that this lock I associated to the process ID of my login with
> EM...
>
> How can I resolve this problem?
>
>
> On process information I see that the process associated with this lock
> have the follow information:
>
> runnable/2/SELECT INTO/ MS SQLEM/0/not waiting/CPU:844/IO:0/Memory:15
>
| |
| salvoWJ 2005-07-30, 3:23 am |
| Thanks, but I find the follow error on Log Error: 17805, Severity: 20,
State: 3; Invalid buffer received from client..;
What mean?
Thank a lot
| |
| Tibor Karaszi 2005-07-30, 8:23 pm |
| That error doesn't seem to be related to the ##lockinfo thing. I suggest you search KB, google and
Books Online for that error message (or post a new post with appropriate subject).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"salvoWJ" <salvatore.toro@volawindjet.it> wrote in message
news:1122712430.128039.263730@g47g2000cwa.googlegroups.com...
> Thanks, but I find the follow error on Log Error: 17805, Severity: 20,
> State: 3; Invalid buffer received from client..;
>
> What mean?
>
> Thank a lot
>
|
|
|
|
|