Posted by: bhikari September 20, 2010
Login in to Rate this Post:
0
?
Hi I am new to dba. I am analyzing page splits and disk IO to determine optimal fill factor for my indexes. I am using performance moniter to find page splits but I also need to look at disk IO to determine the correct fill factor. Does disk IO basicly tell me read/write ratio correct?
how do i determine that? do i use performance moniter for that? if so what counters should i be using and how do i read the data.
Also I have installed sql server performance dashboard report but I dont know how i can use that for my advantage. Your help is appreciated.
thanks.