SQL Server Performance

Lock requests/sec

Discussion in 'Performance Tuning for DBAs' started by frettmaestro, Aug 2, 2003.

  1. frettmaestro New Member

    Unfortunately I'm not too familiar with the performance-monitoring of sql-server so I got a question. The database btw is a Win2k SP4 Dual AMD 1,6Mhz with 512MB RAM and RAID 1 with two 10000rmp SCSI disks running a pretty advanced website...here goes:

    I have during testing a very modest amount of users online and I am expecting alot more. The average number of lock requests/sec is between 10 and 15000 and I'm wondering if this is alot or not, if there are any limits I should look out for and what I can do to reduce this number? The last question might be more suitable for the "tuning for developers"-forum though...

  2. satya Moderator

    YOu many options to reduce blocking on the server, refer to the following URLs and assess them to fix it.

    http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp - PERFMON counters.
    http://www.sql-server-performance.com/lock_contention_tamed_article.asp - Lock contention tamed.
    http://www.sql-server-performance.com/reducing_locks.asp - Tips to reduce locks
    http://www.sql-server-performance.com/reducing_locks_hints.asp - Tips to use lock hints

    Satya SKJ

Share This Page