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 recordThis is a multi-part message in MIME format.
--=_NextPart_000_0113_01C443EA.7DB46880
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
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=3D271509 and =http://support.microsoft.com/?id=3D224453 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?
--=_NextPart_000_0113_01C443EA.7DB46880
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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=3D271509">http://support.microso=ft.com/?id=3D271509 and http://support.microsoft.com/?id=3D224453">http://support.microso=ft.com/?id=3D224453 help you out any.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine
"Eugene" wrote in message news:464=70501-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?
--=_NextPart_000_0113_01C443EA.7DB46880--
Wednesday, March 28, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment