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--
Showing posts with label traced. Show all posts
Showing posts with label traced. Show all posts
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?
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?
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
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
Subscribe to:
Posts (Atom)