I am looking for some advice on a SQL 2000 configuration I have inherited.
The configuration looks like this.
EMC SAN with two disk pools
DISK Pool #1 - 7x300GB SAS 10K drives - RAID 5 (1xHot Spare)
DISK Pool #2 - 11x1TB SATA 7200K drives - RAID 5 (1xHot Spare)
On DISK Pool #1 I have 1 Virtual Disk that is exposed to 3 hosts running VMware ESX 4.1
On DISK Pool #2 I have multiple virtual disks - all exposed to the 3 hosts.
Each virtual disk contains one datastore that is the same size of the virtual disk.
The datastore on DISK Pool #1 is dedicated to our SQL Server.
The datastores on DISK Pool #2 are mostly used of other VM's (file server, domain controllers, Exchange, Front End application servers)
The SQL Server has 4 partitions all separate VMDK's stored on that same datastore.
A SQL Backup runs against our databases twice daily and drops them in the backup partition. (each backup totals 90GB)
Here is the million dollar question... am I best to leave the logs/data/backup all on the faster storage or should I separate out the BACKUPS data to a NAS we have and put the Logs on the lower tier storage on DISK pool 2?
I know ideally I want more spindles and preferably RAID 10, but I don't really have the space/time/budget to juggle servers.
Any feedback is appreciated!