Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Age old SQL and RAID Expand / Collapse
Author
Message
Posted Wednesday, October 9, 2013 2:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 14, 2013 12:26 PM
Points: 1, Visits: 32
Hi all,
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.
OS
DATA
LOGS
BACKUP

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!

BF
Post #1503297
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse