Posted by Dimitri Furman on 09/03/07 03:44

On Sep 02 2007, 01:39 pm, Erland Sommarskog <esquel@sommarskog.se> wrote
in news:Xns999FC8952760AYazorman@127.0.0.1:

> Anyway, you can easily examine this next time it happens by running
>
> SELECT * FROM sys.dm_os_tasks WHERE session_id = <trouble spid>
>
> If there are rows with non-zero exec_context_id, there are parallel
> threads.

There are not, so I guess we can rule out parallelism.

> It's also available in sys.dm_exec_text_query_plan. A way to get the
> plan, sys.os_waiting_tasks and more packaged into one result set, is
> to use my beta_lockinfo, available at
> http://www.sommarskog.se/sqlutil/beta_lockinfo.html

This should be handy. Thanks.

> There have been some bugs around temp-table caching, I don't if they
> could be related to what you see. There is a Cumultative Update,
> including these two bugfixes at
> http://support.microsoft.com/kb/939537.

I'll get that and watch how it goes for a few days. If it still happens,
will try to find some time to work on a repro. Will follow-up with any
news.

--
remove a 9 to reply by email

[Back to original message]