using performance monitor to determine fill Factor for indexes. Read/write ratio
Posted on 2010-09-09
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?