##lockinfo

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 workin
g
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?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
"Huacuz" <Huacuz@.discussions.microsoft.com> wrote in message
news:51FCF432-5044-4741-A1F7-2DB063DB2322@.microsoft.com...
> Hi every one...
> Heres 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 doesnt (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 id
> 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 doesnt 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?