In sql profiler I see the following ObjectName called "Flush IDES". It
appears to occur after a commit of a user_transaction? It's
EventSubClass is all "0-begin" and "1-commit"s?
Does anybody know what this is?My guess this is what you may see.
IDES The IDES latch waitresource is used when the PFS page is scanned to
find free space and when the PFS page is updated to reflect allocations and
deallocations of pages. This latch is also used when single pages are
allocated to an existing object. Determine whether you have a clustered index
on the object in question.
reference.
http://support.microsoft.com/kb/822101/en-us
this is applicable to sql 200 sp4 and later versions.
You did not provide all the info from the trace to say for sure. So it is a
guess.
--
Thanks, Liliya
"Ken" wrote:
> In sql profiler I see the following ObjectName called "Flush IDES". It
> appears to occur after a commit of a user_transaction? It's
> EventSubClass is all "0-begin" and "1-commit"s?
> Does anybody know what this is?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment