Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2013-07-24 : 15:44:56
|
waitresource column doesn't indicate if it's a page, KEY, TAB. How can I tell what it is. Look at the result below.319 491 0 0x0003 SELECT 5:72057594042515456 (20c5eaeb69e4) |
|
MuMu88
Aged Yak Warrior
549 Posts |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2013-07-29 : 16:55:48
|
Thanks MuMu. However the links were not useful.I used this and ran it against the right db. However it returns nothing. SELECT o.name AS TableName, i.name AS IndexName,SCHEMA_NAME(o.schema_id) AS SchemaNameFROM sys.partitions p JOIN sys.objects o ON p.OBJECT_ID = o.OBJECT_ID JOIN sys.indexes i ON p.OBJECT_ID = i.OBJECT_ID AND p.index_id = i.index_id WHERE p.hobt_id = 72057594042515456 |
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-07-29 : 20:47:28
|
Try the query without WHERE clause:[CODE]SELECT o.name AS TableName, i.name AS IndexName,SCHEMA_NAME(o.schema_id) AS SchemaNameFROM sys.partitions p JOIN sys.objects o ON p.OBJECT_ID = o.OBJECT_ID JOIN sys.indexes i ON p.OBJECT_ID = i.OBJECT_ID AND p.index_id = i.index_id [/CODE]How are you getting your waitresource? |
|
|
|
|
|