Lock Monitor - 03-31-2006 , 09:11 AM
I have a sql server (Sql 2k Sp3) that has a very high CPU utilization count
for the Lock Monitor. The database is used by a Java application that
controls all update transactions. There are some instances where the app is
saving data, querying data and then saving more data inside a distributed
transaction. We are trying to remove those instances.
But I need tips and help on how to get lower the Lock Monitor CPU usage.
What is a average count?
RE: Lock Monitor - 04-02-2006 , 05:53 AM
If you are not in control of the scope of the transaction, then you may be
limited to looking at the high duration of high volume statements and try and
tune the database to make them quick. You may also want to look at
distributing the I/O better such as adding discs to a raid system or
splitting filegroups into files over different spindles.
Use sp_locks to see lock information, check the isolation level and look for
query hints in SQL Profiler.