troubleshooting Question

Too many blocking locks

Avatar of ashok_001
ashok_001 asked on
Microsoft SQL Server
7 Comments2 Solutions617 ViewsLast Modified:
We are using a custom J2EE application that uses the Hibernate ORM (ver 3.05) to connect to a  MS Sql Server 2000 (ver SP3 - AKA - 8.00.760).

Normal Hibrernate reading and writing is resulting in TOO MANY BLOCKING LOCKS on the DB. When 10 people simultaneously log in  and read/write data there are far too many locks, and the DB is almost dead. This is in production! We also have a few deadlocks here and there

We have reasoanabe size hardware , a decent network and environment.

All read only queries are in Uncommitted Read, Other queries are in READ COMMITTED level.

What can I do to reduce the number of locks  ?
ASKER CERTIFIED SOLUTION
Gautham Janardhan

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros