November 11, 2011 at 1:34 pm
Hi all.
I am seeing a lot of wait types with wait resource as
KEY: 10:72057594038714368 (01009eb309ad)
KEY: 10:72057594038714368 (01002bd6f0da)
KEY: 10:72057594038714368 (01002bd6f0da)
KEY: 10:72057594038714368 (01002bd6f0da)
KEY: 10:72057594038714368 (01002bd6f0da)
KEY: 10:72057594038714368 (0100c4996f5b)
KEY: 10:72057594038714368 (01003e9725df)
how can i decode this. I want to know the name of the object.
Thanks for your help in advance
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 11, 2011 at 1:53 pm
I used the script below to identify the name of the object. But all I see is nothing in the output. Do I need to enable a trace flag for this
SELECT o.name, i.name
FROM 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='72057594038714368'
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 11, 2011 at 2:21 pm
That script's correct. Just make sure you're in database 10 when you run it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2011 at 2:44 pm
Yep..that works..I was on a different database. Thanks Gail.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply