Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    4

    Unanswered: 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

  2. #2
    Join Date
    Mar 2008
    Posts
    96
    What is the error in the errorlog?

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Haven't experienced this myself but guess that now that the process is no longer in lock wait it can do the I/O.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •