So here is my question... what is the upper limit for the MaxLocksPerFile value? Reasoning that if 200K is good 500K must be better right?
Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.
Upper End For MaxLocksPerFile Value
Started by
TheGreyGuy
, Jul 20 2010 10:59 AM
2 replies to this topic
#1
TheGreyGuy
-
- Members
- 28 posts
- OFFLINE
- Gender:Male
- Location:Tacoma, WA
- Local time:05:43 PM
Posted 20 July 2010 - 10:59 AM
While working on an MS Access problem someone recommended I increase the MaxLocksPerFile value from the 9500 default to 200,000 shown in the example from MS Support. It didn't solve my problem but my users other queries ran faster. This is generally considered a good thing.
So here is my question... what is the upper limit for the MaxLocksPerFile value? Reasoning that if 200K is good 500K must be better right?
So here is my question... what is the upper limit for the MaxLocksPerFile value? Reasoning that if 200K is good 500K must be better right?
This job would be sooo much easier if wasn't for all the users and their problems!
Back to top
#2
thrillhouse
-
- Members
- 1,040 posts
- OFFLINE
- Gender:Male
- Location:Va
- Local time:08:43 PM
#3
TheGreyGuy
- Topic Starter
-
- Members
- 28 posts
- OFFLINE
- Gender:Male
- Location:Tacoma, WA
- Local time:05:43 PM
Posted 20 July 2010 - 11:21 AM
The other thread is "Not enough space on temporary disk."
This job would be sooo much easier if wasn't for all the users and their problems!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
