##lockinfo

9 Sep 2005 7:29 PM

Huacuz

Hi every one...
HereÂ´s my question: I have this huge Query that acces a lot of tables and
uses sub-querys on it. Some times it gets my server to a 100% of cpu, but
some other times doesnÂ´t (the same query with same parameters).
I watch the process/lock on enterprise manager and when this happens appears
a ##lockinfo with a process id at the end, i think this is normal but iÂ´d
like to know why is this lock there and also, when the server is full working
i see a lot of temp db in the process of my query that doesnÂ´t appear when it
works normally.

So I put here a couple of questions:
1) What does the ##lockinfo process mean?
2) Why could all those temp db appear on my process and only some times
stuck my server?

9 Sep 2005 9:40 PM

John Bell

Hi

This has been asked before!

http://tinyurl.com/9ortd

That does not explain why you get 100% CPU , you may want to look at
performance monitor and see what is happening for instance if any files are
expanding or a maintenance task is running.

John
Show quote

"Huacuz" <Hua***@discussions.microsoft.com> wrote in message
news:51FCF432-5044-4741-A1F7-2DB063DB2322@microsoft.com...
> Hi every one...
> Here´s my question: I have this huge Query that acces a lot of tables and
> uses sub-querys on it. Some times it gets my server to a 100% of cpu, but
> some other times doesn´t (the same query with same parameters).
> I watch the process/lock on enterprise manager and when this happens
> appears
> a ##lockinfo with a process id at the end, i think this is normal but i´d
> like to know why is this lock there and also, when the server is full
> working
> i see a lot of temp db in the process of my query that doesn´t appear when
> it
> works normally.
>
> So I put here a couple of questions:
> 1) What does the ##lockinfo process mean?
> 2) Why could all those temp db appear on my process and only some times
> stuck my server?