Home > IT Answers > Storage > SQL Server on SAN
Needplease
5 pts.
 SQL Server on SAN
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: March 31, 2012  8:12 PM
RELATED QUESTIONS
Answer Wiki:
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?
Last Wiki Answer Submitted:  July 27, 2011  1:14 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

ErroneousGiant
 3,120 pts.