temp.dbo.##lockinfo

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

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
>

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

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 sub
ject).

--
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
>