A Self-Tuning Fill Factor Technique for SQL Server – Part 1

  • Mike Byrd

    Ten Centuries

    Points: 1285

    Comments posted to this topic are about the item A Self-Tuning Fill Factor Technique for SQL Server – Part 1

    Mike Byrd

  • bmelker

    Valued Member

    Points: 66

    Very interested to try your technique. should line 386 end in air1?

  • Edwin de Jonge

    Grasshopper

    Points: 11

    Had some trouble getting it to work though.

    First of all, as stated in the above comment, line 386 has the wrong alias and should be air1 indeed. And I'd like to suggest three small adjustments on lines 463, 476 and 535 to put a QUOTENAME around the @indexname ...

    ALTER INDEX ' + QUOTENAME(@indexname) +' ON [' + @schemaname

    It appeared that someone in our organization came up with the excellent idea to put dots (.) in a couple of indexnames, obviously resulting in a failing command.

    Looking forward to see what's going to happen over time and can't wait to read part 2.

    Cheers

  • Mike Byrd

    Ten Centuries

    Points: 1285

    Actually the script has evolved some since I wrote the article.  Have attached latest script (currently in production on one of client's databases).  (Change file extension from txt to sql)

    • This reply was modified 6 months, 1 week ago by  Mike Byrd.
    • This reply was modified 6 months, 1 week ago by  Mike Byrd.
    Attachments:
    You must be logged in to view attached files.

    Mike Byrd

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 717429

    I'll ping Mike for updated images.

  • ThatSteveCena

    Grasshopper

    Points: 13

    I'm trying to use this on SQL Server 2014 Std. I'm using the most recent script listed above. However it keeps crashing with:

    Msg 25704, Level 16, State 1, Line 8

    The event session has already been stopped.

    Is this happening to anyone else? I'm going to try the original script in a moment.

  • ThatSteveCena

    Grasshopper

    Points: 13

    This is the script I reworked to run on SQL Server 2014 STD taking into account everything mentioned in this thread up to this point. It uses the code base from the original posting.

    UPDATE: Forgot to rename the extension from .SQL to .TXT 🙂

    • This reply was modified 6 months, 1 week ago by  ThatSteveCena. Reason: Forgot to fix file extension
    • This reply was modified 6 months, 1 week ago by  ThatSteveCena.
    Attachments:
    You must be logged in to view attached files.
  • Mike Byrd

    Ten Centuries

    Points: 1285

    I'm not seeing your attachment. 🙁

    Mike

    Mike Byrd

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply