Locks per File

From: elf <eric@xxxxxxxxxxxxxxx>
Date: Fri, 04 Nov 2005 09:54:12 -0500

For some time, I have been trying to determine why we are getting timeouts under certain conditions using an A2003 front end, SQL2000 backend. I have recently seen several quirky conditions related to a too-low setting of maxlocksperfile.

Can that setting perhaps cause a timeout if the process is trying to acquire too many locks?

TIA
.

Follow-Ups:
- Re: Locks per File
  - From: Sue Hoegemeier

Prev by Date: DSN Configuration setting "Use strong encryption for data"
Next by Date: RE: SQL Profiler: Attention Event class on DELETE statement - why?
Previous by thread: DSN Configuration setting "Use strong encryption for data"
Next by thread: Re: Locks per File
Index(es):
- Date
- Thread

Relevant Pages

Re: [PATCH 0/3] 64-bit futexes: Intro
... What you *could* maybe do, to slightly speed up the reader fastpath, at ... the expense of the writer fastpath, is to also have the active writer add ... In fact, in the second version of my locks, I didn't do futex operations ... consider things like timeouts etc. Timeouts are "hard" to handle because ...
(Linux-Kernel)
Re: ATA device reset, shoud I be concerned?
... Old IDE often locks up the machine hard after timeouts. ... If such behavior is wide spread among PATA drives && we ...
(Linux-Kernel)
linux.bkbits.net downQ?=
... front page but clicking on linux-2.4 or linux-2.5 just timeouts. ... TIA ... send the line "unsubscribe linux-kernel" in ... Please read the FAQ at http://www.tux.org/lkml/ ...
(Linux-Kernel)