Installing SQL Server over a SAN

Tags:
SAN
SQL Server installation
Storage Area Networks
I am trying to install and configure my SQL Server over my Storage Area Network (SAN). Can you give me the best steps for doing so?

Answer Wiki

Thanks. We'll let you know when a new response is added.

The first thing to do is to decide how you want to use the disks. A standard SQL installation will have one LUN for the data and another LUN for the logs. Ideally the logs will be on a different set of disks so if you lose one set, your recovery time is decreased by having the other set.

Next you need to choose your raid levels. Most people want RAID 10 for their logs, but are willing to use RAID 5 for the data. Figure out how large your data and logs will get, and size an appropriate RAID group in the SAN. If you plan on using an existing RAID, ensure that there’s enough room for the new storage, and that there’s enough spindles to handle the load of this new SQL workload as well as whatever else you have on it. Once you have the space available, create the LUNs.

Here’s what we do to get your server seeing the storage:

1) Build out Windows server
2)Install HBA/multipath drivers
3)Set up zoning on the switches
4)Set up LUN masking if the SQL server is not the only server attached to the SAN
5)Present LUNS to the SQL server
5)Install SQL on the newly presented storage

Good luck!

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following