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 t
ranslation to the binary record?Is this a KEY resource? If so, this value is a hash value based on the inde
x 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 interna
l 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:4647050
1-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 t
ranslation to the binary record?

No comments:

Post a Comment