|
| Hi again,
I come back with my HD issues on a SAN.
I'm looking for sample scripts or tool to benchmark my system
we do some changes and we'll do some changes in our configuration.
so I want to benchmark before & after.
today I have a simple benchmark which is the creation then the loading of
5millions of rows.
then the test of the usage of these 5millions of rows.
maybe you have some tool or script with a lot of predefined queries etc...
also I'm using IOMeter to see the throughput of the disks.
Currently this tool indicate that the SAN and the local disk provides the
same throughput!!!
I compare only 1 local 36gb SCSI disk to a lot of disks on the SAN
(Raid5)!!!
so I have executed my 5millions rows test with these 3 configs:
1. target database files on the SAN
2. data files on the SAN log file on the local drive
3. data files on the SAN log file on the SAN too, but on another partition
letter (same disk, different partition)
So I presume that the config 2 can perform better because I share the usage
between 2 different controllers and set of disks.
but surprise... the solutions 2 & 3 are far slower!!!! the test 1 finish the
test in 6minutes while the test 2 & 3 do the same job in 10 minutes!!!!!!
The test here is a simple loading (bulk insert)
so I'm disappointed...
if all the files are on the same folder the test is better than if I
separate the files in different drives!!!
and the test 3 use the same "physical" disk which is the SAN
So... if you have any benchmark tool for a DW and ETL tests...
thanks,
jerome.
|
|