using performance monitor to determine fill Factor for indexes. Read/write ratio

I am trying to determine fill factor for my indexes. To do that I think the best idea is to use windows performance moniter to moniter the amount of reads and amount of writes. I have set up 2 counters:
'Disk Reads/sec' and 'Disk Writes/sec' from 'Physical Disk' performance object. I am running all this in a virtual box so that my sql server is not connected to any of the client softwares. So the only 'read' that will happen is when i run a query. My question is what about the writes?

Reason i ask is, when i look at the graphs i see there are some perks on the graphs(for writes) even if i dont do anything! what is the reason for that. Why is there an activity on 'writes' on my physical disk even if i dont do anything. When I run a query(ie read), there is a tweak on the read graph which makes sense to me.

Is this the best way to determine my write/read ratios for my fill factor for indexes?
Who is Participating?
Ted BouskillConnect With a Mentor Senior Software DeveloperCommented:
Why aren't you querying the database directly to get the level of fragmentation?

Plus Microsoft provides some great free reports for analyzing performance issues;
itbossmanAuthor Commented:
It is running in 2005 sql server in 2000 windows server
Anthony PerkinsCommented:
If copying and pasting some code and then executing from the query window is too much work for you, consider displaying the Index Physical Statistics Standard Report.  You get there by using the Object Explorer in SSMS, right clicking the database and selecting Standard Reports and then choosing Index Physical Statistics.
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

itbossmanAuthor Commented:
tedbilly, I have a script i run to find the level of fragmentation which i can rebuild my indexes. My question is how to determine the correct fill factor for my indexes. To better predict that I need to analyze the read/write ratio. right now all the fillfactors are defaulted to 0 which should only be the case for read only tables. There are lots of updates/inserts going on our databases daily.

Is there a tool to determine fill factor? I will look into your second link if I can get anyting out of that.

acperkins, when i right click on database there is no 'Standard Reports' as a selection.

thanks for feedback
Ted BouskillSenior Software DeveloperCommented:
Predicting a good fill factor requires data gathered over time.

So, you'll have to watch the database and record the rate of fragmentation.  I'd rebuild the indexes at a time when the database is not in use, then every day record the fragmentation percentage.  Then if you knew that realistically you could rebuild the indexes every week, total the fragmentation for the week and set the fill factor to cover that percentage with some additional space for anomalies.

If you can rebuild the indexes daily, then you could use a smaller factor.
itbossmanAuthor Commented:
thanks, tedbilly i installed the performance moniter dashboard. It is a great tool
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.