November 27, 2008 at 7:49 am
Should this be two posts ? hmm dont knwo .. closely related so I'll stick with the one i guess 🙂
Anyways ...
1. using perfmon to measure the amount of page splits per sec ... Im told that a too many may inidicate poor indexing etc ... so how many is too many ? is there a magick figure ? a formula to work out ?
2. Fill factors .. words of wisdom for selecting a starting fill factor.. I mean if its a static tables 90-100% and if its going to be filled up with lots of data later then 5% as the ball parks.. .. but can I be more precise in working out a fill factor ? (ignoring guids and identity columns of course) ..what if there truly is no way to work aout much other than the table will have a fair amount of reads and writes ?! the best I can get from people is "its kinda average"
anyways many thanks ... no replies expected today as I guess your all eating turkey etc .. happy thanksgiving whenever that might be ...
best wishes
simon
November 27, 2008 at 8:05 am
Simon
not so much bad indexing, but yes they are related. The fill factor is defined as a default at server level which is usually 0 and means 100%. When rebuilding indexes you can specify the factor and it will over ride the default. If you specify a fill factor too low (20% for example) you could end up with huge data files and the database engine having to read unnecessarily from too many pages. Its a trade off affair and i'm afraid there is no hard and fast rule that i know of. What values are you seeing in Perfmon for this counter. Try different values and see which is the best
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply