Solved

SQL Server 2008 R2 Running on Dell Equallogic SAN

Posted on 2011-09-06
6
406 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql server insert 12 29
TSQL - How to declare table name 26 28
Query Syntax 17 32
why sql server only update some statistics in the database ? 3 19
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

813 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

13 Experts available now in Live!

Get 1:1 Help Now