?
Solved

SQL Server 2008 R2 Running on Dell Equallogic SAN

Posted on 2011-09-06
6
Medium Priority
?
432 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 1000 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 56

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 1000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

809 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