Wednesday, March 28, 2012

Lock Timeout Resource

Using sql 2000 profiler I traced the event lock timout. In the binary field I get a value,
0x000705003B468D2402000D00F5A8D578,
BOL says this is the resource type. How or where do I go to get an english translation to the binary record?
Is this a KEY resource? If so, this value is a hash value based on the index key, and cannot be translated. You could potentially get more information by looking at the ObjectID or IndexID columns. What is the duration of the lock timeout? You may see durations of 0 for this event, which are internal timeouts that are not anything to worry about.
If you are concerned about blocking, see if http://support.microsoft.com/?id=271509 and http://support.microsoft.com/?id=224453 help you out any.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine
"Eugene" <anonymous@.discussions.microsoft.com> wrote in message news:46470501-4BF8-47B1-A71E-631F135197AE@.microsoft.com...
Using sql 2000 profiler I traced the event lock timout. In the binary field I get a value,
0x000705003B468D2402000D00F5A8D578,
BOL says this is the resource type. How or where do I go to get an english translation to the binary record?
sql

No comments:

Post a Comment