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
ZYTYou are having performance issues with just 1500 records per day?|||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|||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.|||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?|||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.|||Do you defrag/rebuild indexes regularly, let's say based on that volume, every couple of weeks ?|||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 :)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment