Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Unanswered: Changing a database from All Pages locking to Data Pages locking...

    If changing all tables in the database, is it necessary to change the system tables aswell as the user tables?

    Also, if all of the databases on the Sybase server were going to go through this, should we change the locking schema for the system databases (master, model, etc) also?


    Thanks,

    Jeremy.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    from a couple of resources Rob Verschoor et.al. I learned and we praticesed
    to set row level locking on the tables which caused frequent deadlock/locking situations
    all others remain on Sybase' std locking mechanism

Posting Permissions

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