Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: How to set fill factor?

    Hellow, everyone"

    I have a web online table that is inserted about 1500 record one day. Each night, a DST is running to pull all data to anther database. How to set fill factor on a one column index to get the best performance? Current fill factor is 80%.

    Thanks

    ZYT

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You are having performance issues with just 1500 records per day?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2003
    Posts
    223
    Quote Originally Posted by blindman
    You are having performance issues with just 1500 records per day?
    Yes, about 1500 records everyday. This table has not been maintained about five years. Someone created it that time. I take over and want to imporve performance.

    ZYT

  4. #4
    Join Date
    Jul 2007
    Posts
    96
    I'm not really into the fill factor thing. In fact I'm still learing my way in SQL Server.

    Also, I really don't know if setting a fill factor would benefit your particular case. However, as far as I know, you should be able to determine the fill factor (0-100) of a particular index by using the ALTER INDEX command.

    Not really sure if this was the answer you were looking for. There's the chance that I didn't understand your question.

    Best regards.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Well, lets have the whole story then. Post the DDL for the table, along with any indexes on it.
    Also, how many records are in it?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Keep in mind fillfactor only comes into play at the time you create the index, or rebuild the index. It has absolutely nothing to do with how the data is maintained over time.

  7. #7
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Do you defrag/rebuild indexes regularly, let's say based on that volume, every couple of weeks ?

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by blindman
    You are having performance issues with just 1500 records per day?
    If I may - the nature of the records inserted bares some scrutiny. We had a guy on recently (I forget who) who's records averaged 4KB per record. As such I agree - we need to at least see the DDL to get an idea of what might be inserted.

    We could also do with knowing if rows are likely to be updated regularly (and if those updates are likely to dramatically change the size of the rows).

    ...and finally - we need to know (as MCrowley says) what the reindexing processes are for this table.

    @OP - there is a lot of factors that determine the optimum fillfactor. Please provide the information requested
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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