September 5, 2005 at 6:06 am
can anybody tell me which one is the default lock in sql server?
September 6, 2005 at 1:21 am
Hi,
FROM BOL
Allowing SQL Server to use locks dynamically is the recommended configuration. However, you can set locks and override SQL Server's ability to allocate lock resources dynamically. Increase this value if SQL Server displays a message that you have exceeded the number of available locks. Because each lock consumes memory (96 bytes per lock), increasing this value can require increasing the amount of memory dedicated to the server.
locks is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change locks only when show advanced options is set to 1. The setting takes effect after stopping and restarting the server.
For more information read BOL.
From
Killer
September 6, 2005 at 6:34 am
Do you mean row lock vs page lock vs table lock? Or do you mean shared vs exclusive? Look up "transaction isolation levels" and "lock escalation" as well as "locking hints" - should give you all you need.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply