Hello. I have an issue with SQL 2000 where when I run profiler I see multiple
locks that are acquired then release many, many times over. I have an
application with minimal users 15-20 and the clients are accessing a Compaq
Proliant 8000 with dual 800Mhz processors, (6) 18GB drives in a RAID 5 config,
2GB of ram and all connected to a Cisco 3548 Switch via Gigabit link. I am
seeing poor performance from the database. I have a feeling it may be due to the
Running Profiler for 1 hr and filtering it down to 3 users (that do not have a
real heavy load; simple selects, updates, inserts) the Profiler returns over
22000 Lock:Acquired/Released entries! Is this normal? The app they are using
isn't too transaction intensive. Mostly selects. I was going to attach a
Profiler Trace file, but they are pretty big. If this would be of help, please
let me know.
Thanks in advance for any help or comments!
Federated Rural Electric Insurance