Results 1 to 2 of 2

Thread: Lock requests/sec too high?

  1. #1
    Join Date
    Mar 2003
    Posts
    383

    Lock requests/sec too high?

    Hi:

    one production server DB is getting slower... (SQL2K sp4 ent)
    1. dbcc checkdb(abc) with 0 errors
    2. no blocking
    3. no abnormal in sql log and event system log
    4. only found one crypt32 auto update fail last night.

    the Lock Requests/sec is kind high from 5400 to 15400 on 0.01 scale. max is from 57611 to 155411.

    Could I increase the locks assigned to sql and what is the best way for it?

    thanks
    david

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    That means lot of updates on the server. If queries use proper index then nothing you can do in sql server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •