很多人都遇到过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) |
Row |
DatabaseID:FileID:PageID:Slot(row) |
RID: 5:1:104:3
|
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 for more information on blocking caused by compile locks. |
本文转自 lzf328 51CTO博客,原文链接:
http://blog.51cto.com/lzf328/1243715