Post reply

SQL Server data files in a Dell PowerVault 745N

  • September 6, 2005 at 5:26 am

    #363575

    Hello,

    I'm thinking in moving our database files to a Dell NAS device with Windows Storage Server. We will configure that device with hardware RAID 5 and four SATA 160 GB hard disks.

    Is there anyone with a similiar configuration running?

    What do you think of that environment.

    All comments will be very appreciated.

    Regards,

    Alfredo

  • September 6, 2005 at 6:29 am

    #587740

    I think it'll be slow

    fine for a development or QA environment but i wouldn't do it for anything production related.

  • September 7, 2005 at 9:11 am

    #588117

    That might be a fine piece of equipment (I have no idea), but using any NAS device for your data files means you have network bottlenecks between the server and the disks.

    If this is the hardware you've got to work with, it might be livable if you have an isolated gigabit ethernet segment connecting the server and the NAS.  If it is a slower connection, or it has to share the network with other traffic, or if the NAS is being used for other file sharing at the same time, it will be a pig.  You can mitigate it somewhat by keeping tempdb and log files on the server, put only .MDB files on the NAS.

    You'd be much better off with direct-attached storage.

  • September 7, 2005 at 9:55 am

    #588143

    I couldn't agree more

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply