filegroup distribution

Hi, I was wondering if anyone could give me a general rundown of filegroup
distribution. What performance monitor counters do you use to determine the
load on the disks and the way you distribute the filegroups. Generally what
i want to do is assess the current load on the disks and determine which
disk is taking the least load, and set the filegroup on that as the default.
Then later on when additional data files are added to the system, further
load analysis is used to determine the least used disk and then set that to
contain the default filegroup. Just what perf. mon. counters does one use to
do this, and what analysis does one go through to determine filegroup
distribution.
Thanks!
Hz.If you only have a single filegroup per disk array there are lots of disk
counters in perfmon to help with determining the load on that array. Check
out all the counters under Physical Disk. You can also use
fn_virtualfilestats to see which files are used most often for reads /
writes etc in conjunction with the perfmon counters.
Andrew J. Kelly
SQL Server MVP
"Hz" <Hz@.nospam.com> wrote in message
news:fFCFb.6016$xm.227280@.nasal.pacific.net.au...
> Hi, I was wondering if anyone could give me a general rundown of filegroup
> distribution. What performance monitor counters do you use to determine
the
> load on the disks and the way you distribute the filegroups. Generally
what
> i want to do is assess the current load on the disks and determine which
> disk is taking the least load, and set the filegroup on that as the
default.
> Then later on when additional data files are added to the system, further
> load analysis is used to determine the least used disk and then set that
to
> contain the default filegroup. Just what perf. mon. counters does one use
to
> do this, and what analysis does one go through to determine filegroup
> distribution.
> Thanks!
> Hz.
>