Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ghastings
Starting Member
7 Posts |
 Posted - 2009-04-02 : 05:26:49
|
| Hi,I was setting up some perfmon counters the other day and added inSQLServer:LocksLock Requests/sec: _Total, Database, Index, Page and Table.Interestingly enough I saw that there are approx 5-30 database lock requests per second as well as up to 700 table lock requests/sec.This sounds like a massive number for the load our server is doing. I'd like to investigate this a bit more but can't find much information on what would cause a database level lock (well not 30 req/sec anyway!)Or am I reading it wrong?Any hints please? Is there a way to view database locks in profiler? I worked out how to view the index locks using profile but I'm lost with the database ones.Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-04-02 : 06:25:16
|
| database locks are locks taken by a connection. it's nothing to worry about.lock reqs per table are simple all locks taken on tables including shared, exclusive etc.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
 |
|
|
ghastings
Starting Member
7 Posts |
Posted - 2009-04-03 : 05:19:12
|
| Ok thanks for the reply.Gareth |
|
|
|
|
|
|
Database level locks