SQL Server on SAN

5 pts.
Tags:
SAN
SAN Configuration
SQL Server
SQL Server configuration
I a two server set up. Server one for my application and server two a SAN for my SQL Server.  Should I install the SQL server on the SAN?  I have read about 10 articles and some state to install the SQL Server on the app server while others say on the SAN and yet others say it really does not matter.  Help please.
Thanks!


Software/Hardware used:
SQL Server SAN
ASKED: July 26, 2011  5:35 AM
UPDATED: January 7, 2014  6:47 PM

Answer Wiki

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

It all depends on what the requirements of your application’s database and your application are. Sometimes it makes more sense to put the application and database on the same server, sometimes it makes more sense to separate them.

What’s the config of the two servers? How large is the database?

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
  • ErroneousGiant
    I would lean towards installing SQL on the app server and having the actual data on the SAN. This means you have segregated out the layers, data, app, interface so troubleshooting is easier and maint is easier also.
    3,120 pointsBadges:
    report
  • Needplease
    [...] 3. Mrdenny and ErroneousGiant have some ideas for a member setting up a SQL server on a SAN. [...]
    0 pointsBadges:
    report

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