很多人都遇到过Blocking的问题,查询的时候会看到等待的资源,但是这些代表什么含义呢?
Compile |
Format |
Example
|
Table |
DatabaseID:ObjectID:IndexID |
TAB: 5:261575970:1
|
Page |
DatabaseID:FileID:PageID |
PAGE: 5:1:104
|
Key |
DatabaseID:Hobt_id (Hash value for index key) |
KEY: 5:72057594044284928 (3300a4f361aa) In this case, database ID 5 is Pubs, Hobt_ID 72057594044284928 corresponds to non clustered index_id 2 for object id 261575970 (titles table). Use the sys.partitions catalog view to associate the hobt_id to a particular index id and object id. There is no way |
Row |
DatabaseID:FileID:PageID:Slot(row) |
RID: 5:1:104:3
In this case, database ID 5 is pubs , file ID 1 is the primary data file, page 104 is a page belonging to the titles table, and slot 3 indicates the row's position on the page.
|
Compile |
DatabaseID:ObjectID [[COMPILE]] |
TAB: 5:834102012 [[COMPILE]] This is not a table lock, but rather a compile lock on a stored procedure. Database ID 5 is pubs, object ID 834102012 is stored procedure usp_myprocedure. See Knowledge Base Article 263889
|
更多详细信息参考:INF: Understanding and resolving SQL Server blocking problems