Post reply

Lock: Timeout x Lock: Timeout (timeout > 0)

  • April 6, 2011 at 10:19 am

    #249098

    Hi Friends,

    Can anybody tell me the difference between Lock: Timeout and Lock: Timeout (timeout > 0) in SQL Server Profile ?

    Should I be worried about the first one?

    Thanks,

    Luiz.

  • April 6, 2011 at 11:59 am

    #1308186

    This is the comment in the following MS Link: http://msdn.microsoft.com/en-us/library/ms189107.aspx

    Use the Lock:Timeout event class to monitor when time-out conditions occur. This information is useful to determine if time-outs are significantly affecting the performance of your application, and which objects are involved. You can examine the application code that modifies these objects to determine if changes to minimize time-outs can be made.

    Lock:Timeout events with a duration of 0 are commonly the result of internal lock probes and are not necessarily an indication of a problem. The Lock:Timeout (timeout > 0) event can be used to ignore time-outs with a duration of 0.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

  • April 6, 2011 at 2:17 pm

    #1308278

    Thank you Shaiju

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply