Hello:
I have a SQL server with various databases in the same disk. I need to
reconfigure it, and I want to analyze the I/O over the different data base
files. The information I am looking for is the I/O, like read count and
write count, to decide how to put the files over different disks (RAID 5 and
RAID 1).

The only I/O counters I found are for all the SQLserver usage (all the
databases). The idea is create some script to get the statistic info from
some system table (periodically), and after with the information get
relations in the different databases. The question is which table can be
usefull to get this information. And also use the perfmon counters to adjust
other parameters.

Thanks in advance.

Claudio Tantignone.



MS Sql Server LazyDBA home page