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 |
|
ConorS79
Starting Member
5 Posts |
 Posted - 2008-01-22 : 11:06:52
|
| HiI have a table called "Jobs" on my SQL server. I have an access front end which connects to this as well as some access backend tables.We have 30+ users on the system. There are 1000s of records in this "jobs" table.For some reason, at certain points of the day all users are stopped from updating a group of records. No-one can update values in a clump of records. It is usually 10-20 records that are numerically together.When i kick everyone off the system, and log back those particular records seem to be unlocked.I can rule out permissions on the Jobs table. i am failry certain they have been set correctly.To me it sounds like Page locking. Now i am new to SQL server. I am inheriting a recently created sql system.But i notice there are multiple indexes formed on this JOBS table. I looked at one in particular. It is a "ClientName" field.. I noticed under this index > options...it says "Use Page locks when accessing the index".Am i interpreting this right... But anyone searching under this field, will page lock on that table. And...if my memory serves me right, "page locking" locks a group of all the nearest records?Is this correct?Does this sound like where my system is going wrong?ThanksConor |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-22 : 11:22:03
|
| http://www.sqlteam.com/article/introduction-to-locking-in-sql-server_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
ConorS79
Starting Member
5 Posts |
Posted - 2008-01-23 : 04:20:24
|
| Thanks. I'll take a read at it now. |
|
|
|
|
|
|
Sql Index page Locking