Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    114

    Unanswered: PAD_INDEX : activating or not ?

    Hi all,

    On SQL Server 7 SP4.

    3 tables with about 100 000 rows each one, frequently updated.
    1 clustered index on primary key, and 2 non clustered index on columns used by JOIN and by queries.

    Fillfactor for index : 90.
    PAD_INDEX : not activated.

    I have some deadlocks problems, probably due to index pages and key locking (as precised in error log). Is it possible that the cause of that is splitting index pages while UPDATE ?

    May I activate PAD_INDEX to solve part of this problem ?

    Thanks for any help

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It's a performance issue thing, I don't think that's your problem

    http://www.sql-server-performance.co...erformance.asp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Well, the nature of deadlocks has NOTHING to do with performance, thus cannot be fixed by recommendations given in the link. The only applicable advice which is not even in the section implied is to keep your transactions short. This will minimize the possibility of deadlocks, but will not eliminate them. As you all know, it deals with object access order, and should be addressed accordingly, by examining all possible transactions involving the same set of objects in reverse order.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Mar 2004
    Posts
    114
    Thanks all, I'm going to have a look at it.

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    pad index is really not neccesary. i have chased this guy down many roads
    i even had extended conversations with kimberly tripp and kalen delaney on this and everyone i have talked to has told me that pad index is just not gonna provide any real advantage.

Posting Permissions

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