lock timeouts

In our SQL Server, the Profiler is detecting the occaisional Lock:Timeout
event. I am assuming this means that some transaction is blocked, however
the @.@.LOCK_TIMEOUT value is set to -1 which means that locks never timeout.
So why am I detecting this event?
Any help much appreciated...This also includes internal lightweight locks that timeout and are not the
same as a real lock timeout. It's normal and not to be concerned with.
--
Andrew J. Kelly SQL MVP
"Mark" <swozz_@.hotmail.com> wrote in message
news:uzFOVYhjFHA.3960@.TK2MSFTNGP12.phx.gbl...
> In our SQL Server, the Profiler is detecting the occaisional Lock:Timeout
> event. I am assuming this means that some transaction is blocked, however
> the @.@.LOCK_TIMEOUT value is set to -1 which means that locks never
> timeout. So why am I detecting this event?
> Any help much appreciated...
>|||Are you talking about spinlocks here? Isn't it the case that spinlocks never
timeout? Anyway, during these timeouts, SQL Profiler does report an objectID
of 0 most of the time, but occaisionally the object ID is on one of the user
tables - do you still think we shouldn't be concerned with it?
--
Best regards
Mark Baldwin
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23QGbifmjFHA.2852@.TK2MSFTNGP15.phx.gbl...
> This also includes internal lightweight locks that timeout and are not the
> same as a real lock timeout. It's normal and not to be concerned with.
> --
> Andrew J. Kelly SQL MVP
>
> "Mark" <swozz_@.hotmail.com> wrote in message
> news:uzFOVYhjFHA.3960@.TK2MSFTNGP12.phx.gbl...
>> In our SQL Server, the Profiler is detecting the occaisional Lock:Timeout
>> event. I am assuming this means that some transaction is blocked, however
>> the @.@.LOCK_TIMEOUT value is set to -1 which means that locks never
>> timeout. So why am I detecting this event?
>> Any help much appreciated...
>|||It is hard to say how much of this is caused by the internal stuff or not.
Most likely it is nothing to worry about. But why are you looking at it in
the first place? Did you have an issue specific to locks or timeouts or
just curious? Unless you have an actual problem or other symptoms related
to this I wouldn't worry about it.
--
Andrew J. Kelly SQL MVP
"Mark" <swozz_@.hotmail.com> wrote in message
news:%234DOsVrjFHA.1044@.tk2msftngp13.phx.gbl...
> Are you talking about spinlocks here? Isn't it the case that spinlocks
> never timeout? Anyway, during these timeouts, SQL Profiler does report an
> objectID of 0 most of the time, but occaisionally the object ID is on one
> of the user tables - do you still think we shouldn't be concerned with it?
> --
> Best regards
> Mark Baldwin
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23QGbifmjFHA.2852@.TK2MSFTNGP15.phx.gbl...
>> This also includes internal lightweight locks that timeout and are not
>> the same as a real lock timeout. It's normal and not to be concerned
>> with.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Mark" <swozz_@.hotmail.com> wrote in message
>> news:uzFOVYhjFHA.3960@.TK2MSFTNGP12.phx.gbl...
>> In our SQL Server, the Profiler is detecting the occaisional
>> Lock:Timeout event. I am assuming this means that some transaction is
>> blocked, however the @.@.LOCK_TIMEOUT value is set to -1 which means that
>> locks never timeout. So why am I detecting this event?
>> Any help much appreciated...
>>
>|||We did have a deadlock issue which is now resolved but in the process in
investigating I stumbled on these timeouts messages. Yesterday, the web site
developer says he had one timeout issue, the profiler reported 7 timeout
issues on user data and around 40 timeout issues all together. I am just
trying to understand this Lock:Timeout message to determine if I can use it
to resolve and possibly find as yet unknown problems residing in the
database.
--
Best regards
Mark Baldwin
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23xWiDurjFHA.1444@.TK2MSFTNGP10.phx.gbl...
> It is hard to say how much of this is caused by the internal stuff or not.
> Most likely it is nothing to worry about. But why are you looking at it
> in the first place? Did you have an issue specific to locks or timeouts
> or just curious? Unless you have an actual problem or other symptoms
> related to this I wouldn't worry about it.
> --
> Andrew J. Kelly SQL MVP
>
> "Mark" <swozz_@.hotmail.com> wrote in message
> news:%234DOsVrjFHA.1044@.tk2msftngp13.phx.gbl...
>> Are you talking about spinlocks here? Isn't it the case that spinlocks
>> never timeout? Anyway, during these timeouts, SQL Profiler does report an
>> objectID of 0 most of the time, but occaisionally the object ID is on one
>> of the user tables - do you still think we shouldn't be concerned with
>> it?
>> --
>> Best regards
>> Mark Baldwin
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:%23QGbifmjFHA.2852@.TK2MSFTNGP15.phx.gbl...
>> This also includes internal lightweight locks that timeout and are not
>> the same as a real lock timeout. It's normal and not to be concerned
>> with.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Mark" <swozz_@.hotmail.com> wrote in message
>> news:uzFOVYhjFHA.3960@.TK2MSFTNGP12.phx.gbl...
>> In our SQL Server, the Profiler is detecting the occaisional
>> Lock:Timeout event. I am assuming this means that some transaction is
>> blocked, however the @.@.LOCK_TIMEOUT value is set to -1 which means that
>> locks never timeout. So why am I detecting this event?
>> Any help much appreciated...
>>
>>
>|||Mark wrote:
> We did have a deadlock issue which is now resolved but in the process
> in investigating I stumbled on these timeouts messages. Yesterday,
> the web site developer says he had one timeout issue, the profiler
> reported 7 timeout issues on user data and around 40 timeout issues
> all together. I am just trying to understand this Lock:Timeout
> message to determine if I can use it to resolve and possibly find as
> yet unknown problems residing in the database.
>
You can. But as Andrew stated, many of the Timeout errors are internal
lightweight timeouts. You may be able to use the Duration column to
determine if it is a relevant timeout.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

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 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--

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?

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