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