Solved

SQL Server 2008 R2 Running on Dell Equallogic SAN

Posted on 2011-09-06
6
400 Views
Last Modified: 2012-05-12
We are thinking of migrating our current SQL Server database to a Dell Equallogic SAN Storage box.  Previously we have used locally attached storage in a RAID 10 configuration.  Does anyone have experience running SQL on the Dell Equallogic and are there any pitfalls that I should be aware of?
I would very grateful for any response / insights / enlightening examples that you may be able to provide.
0
Comment
Question by:Evolution-Recruitment
6 Comments
 
LVL 21

Accepted Solution

by:
mastoo earned 250 total points
ID: 36489595
We do that.  I was concerned about the iScsi point-to-point bandwidth limitation, and losing some flexibility on choosing Raid (IIRC raid type is set at the member level).  The increased spindle count turns out to be such an improvement in our case that both those concerns became moot.
0
 

Author Comment

by:Evolution-Recruitment
ID: 36489707
Thanks mastoo, I will leave this open for awhile as I would like to gather as much feedback "from the field" as possible.  However, just so you know, I will be, accepting this as a solution when I eventually close this question.

0
 
LVL 21

Expert Comment

by:mastoo
ID: 36489802
No problem.  The other thing that comes to mind was the level of expertise required.  We're a small place without a dedicated storage person and EqualLogic seemed fairly easy to work with.  We're two years into it and no complaints on ease of use.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 55

Expert Comment

by:andyalder
ID: 36490567
If it's just for performance you would be better off adding more disks in DAS enclosures plus good RAID controllers. There's no performance advantage in moving your disks further away from your CPU by separating them with iSCSI.
0
 
LVL 42

Assisted Solution

by:kevinhsieh
kevinhsieh earned 250 total points
ID: 36492683
I would read the EqualLogic release notes for information on modifying iSCSI timeouts, NTFS partition alignments, and other such tweaks. If you are using Windows 2008 or better, NTFS partition alignment isn't a problem. You should use 64K NTFS formatting per SQL Server Team recommendation. You can install multiple NICs and use MPIO. Install the Dell EqualLogic Host Integration Toolkit; current version is 3.5.1.

I run my SQL inside of Hyper-V VMs. I don't bother with jumbo Ethernet frames. It is okay to thin provision the volumes. I provision the volumes first from the EqualLogic GUI and then I just mount them using the iSCSI control panel. iSCSI HBAs or TCP offload is not required.

It isn't required, but you should load the SAN Headquarters 2.1.0 reporting tool on a workstation or server.

I have been an EqualLogic customer for nearly 4 years.
0
 
LVL 42

Expert Comment

by:kevinhsieh
ID: 36492686
I put logs and databases on separate volumes for manageability. It doesn't make a performance difference because everything goes back to the same set of physical spindles.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now