November 1, 2009 at 11:44 pm
Hello Experts
Can anyone pls suggest me - 'How to calculate fill factor for a page'?
Pls give me the general calculation so that it can be easily calculated based on the no of rows in the table.
E.g, I have a table with 1 Lakh records. I want to add another 1 Lakh records. Then how to calculate the 'fill factor' of the table?
Will wait for the response at the earliest!
Regards,
Sourav
Thanks.
November 2, 2009 at 3:12 am
maybe if you can explain what Lakh is, that might help.
Calculating fill factor can depend on many things, it is not just number of rows that you take into account
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 2, 2009 at 5:05 am
1 Lakh: 1,00,000 in nos.
Thanks.
November 2, 2009 at 7:40 am
There's no easy calculation for an 'optimal' fill factor. Depends on the clustered index key, depends on how fast the clustered index fragments, how much you want to reduce fragmentation, how much you're willing to degrade IO performance initially and the type of the table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply