https://community.hpe.com/t5/disk-enclosures/configuring-msa500-for-sql-server/m-p/4134927#M25988 Hi,<BR /><BR />I am just about to build 2 database servers in a windows cluster and connect them to a high available msa500.<BR /><BR />The servers will host a number of sql2005 databases.<BR /><BR />My question is...<BR /><BR />(i) Do I configure the 14 disks in the disk enclosure as one lun and then configure seperate logical partitions for each database function (i.e. user databases, tempdb, logs, etc.).<BR /><BR />or<BR /><BR />(ii) Do I configure the physical and logical partitions of the disk enclosure for each database function. So my database logs would be hosted on a 3 disk lun with 1 partition spanning these 3 disks - and no other physical disk or partition involved.<BR /><BR />I've heard that option (i) is better for performance but is this a recommended practice for database servers.<BR />Also does option (i) allow failover of the seperate logical drives? Or is failover of the user database volume only possible if the partition is configured physically.<BR /><BR />I hope this is understandable to you.<BR /><BR />Joe<BR />joeyd@mcfc.org.uk Thu, 24 Jan 2008 14:03:05 GMT joe doherty_1 2008-01-24T14:03:05Z https://community.hpe.com/t5/disk-enclosures/configuring-msa500-for-sql-server/m-p/4134927#M25988 Hi,<BR /><BR />I am just about to build 2 database servers in a windows cluster and connect them to a high available msa500.<BR /><BR />The servers will host a number of sql2005 databases.<BR /><BR />My question is...<BR /><BR />(i) Do I configure the 14 disks in the disk enclosure as one lun and then configure seperate logical partitions for each database function (i.e. user databases, tempdb, logs, etc.).<BR /><BR />or<BR /><BR />(ii) Do I configure the physical and logical partitions of the disk enclosure for each database function. So my database logs would be hosted on a 3 disk lun with 1 partition spanning these 3 disks - and no other physical disk or partition involved.<BR /><BR />I've heard that option (i) is better for performance but is this a recommended practice for database servers.<BR />Also does option (i) allow failover of the seperate logical drives? Or is failover of the user database volume only possible if the partition is configured physically.<BR /><BR />I hope this is understandable to you.<BR /><BR />Joe<BR />joeyd@mcfc.org.uk Thu, 24 Jan 2008 14:03:05 GMT https://community.hpe.com/t5/disk-enclosures/configuring-msa500-for-sql-server/m-p/4134927#M25988 joe doherty_1 2008-01-24T14:03:05Z