SQL Server Performance

Lock Timeouts/sec

Discussion in 'Performance Tuning for DBAs' started by kdefilip, Dec 8, 2005.

  1. kdefilip Member

    What do these numbers show for sqlserver:lock timeout/sec in perfmon?
    Thanks.
    kd

    \SERVERNAMESQLServer:Locks(_Total)Lock Timeouts/sec
    0.082844233
    0
    0.049987145
    0
    0.400000098
    0
    1.616666213
    0.016666674
    0
    3.516664332
    0.016666675
    0
    0
    0.066666683
    0
    1.633333721
    0
    0
    1.133333742
    0.366666328
    0
    0
    0
    0
    0
    0.499999932
    0
    0
    0
    0
    0
    1.40000067
    0.016666653
    0
    0.033333405
    0
    0.766666645
    2.950000774
    1.066666246
    0.216666631
    kdefilip, Dec 8, 2005
    #2

  2. satya Moderator

    http://www.sqlservercentral.com/columnists/bkelley/perfmonexcerpt.asphttp://doc.ddart.net/mssql/sql70/8_con_7a_4.htm fyi.
    TO be generic information it is number of lock requests per second that timed out, including internal requests for NOWAIT locks.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Dec 8, 2005
    #2

Share This Page