wrote:
> I need some help understanding the data retrieved from the
> wait_resource column from the dynamic management view
> sys.dm_exec_requests.
> Normally the data returned is in the format of [database_id]:
> [object_id]. Where the object_id returns the table name. That
> facilitates finding your points of contention.
> This morning we were having some trouble and we were getting data in
> the format of [database_id]:[object_id]:[something]. Could anyone shed
> some light on the third number. I've done some research and it and
> I've not been able to find much of anything beyond the most base of
> information.
> Thanks in advance for your help.
>
> Drew Flint
> Plexus Systems Inc.