What do Blocking drilldown Resource column value represent? (4221529)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

What do Blocking drilldown Resource column value represent?
Description

What do Blocking drilldown Resource column value represent? When investigating blocking issues, the grid displays a Resource with a Key, and the help suggests clicking the Question Mark button but no button is displayed.
Resolution

WORKAROUND:
The RID numbers of the Resource column means that is a row ID which has the following format: Database-ID: File-ID: Page-ID. So as an example, numbers 12.1.309 represents: 12 is the database ID, 1 is the file ID and 309 is the page ID.
In case there is a question mark present in this column one can click it and Spotlight will decode to the database name and file name, such as SoSSDemo.SoSSDemo... If Spotlight does not show a question mark, then these values will have to decoded manually.
The following article describe information on decoding these values in order to obtain object ID and name:
https://danieladeniji.wordpress.com/2014/01/30/technical-microsoft-sql-server-wait-resource/
STATUS:
Issue resolved in latest release of Spotlight on SQL Server Enterprise. Click here to download the installation file.
Defect ID

SOSSE-5071

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title