trade off of locking scheme modification - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> trade off of locking scheme modification

Reply

Search this Thread

#1 (permalink)

Old

12-29-11, 09:50

AssedoZion AssedoZion is offline

AssedoZion is offline

Registered User

Join Date: Dec 2011

Posts: 4

trade off of locking scheme modification

Hi,

We modified massively the lock scheme of more than 400 tables from 'All Pages' to 'Data Only Lock' and the system got quickly strangled by I/O overload.
Is thare a link between this new locking scheme and the number of I/O on the disk ?
Sybase 12.5.4 on Unix Log and Data on same discs

Reply With Quote

#2 (permalink)

Old

01-12-12, 04:22

ishu.cs

ishu.cs is offline

Registered User

Join Date: Mar 2008

Posts: 59

What is the error in the errorlog?

Reply With Quote

#3 (permalink)

Old

01-12-12, 11:45

pdreyer

pdreyer is offline

Registered User

Join Date: May 2005

Location: South Africa

Posts: 1,268

Haven't experienced this myself but guess that now that the process is no longer in lock wait it can do the I/O.

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules