Question

  Asked: Apr 8 2008   10:48 PM GMT
  Asked by: SQL Server Ask the Experts


What are the best practices for storing SQL Server application/program files on a SAN?


Storage Area Networks, SQL Server, SAN

We have a non-clustered SQL Server with a Storage Area Network (SAN) on it. What are industry standards/best practices for the location of the application/program files? Is it okay to put the app files on the SAN? We usually put them on local disk storage, but due to an incorrect installation, they wound up on the SAN.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



Putting the actual EXEs on the SAN shouldn't really be a problem. I generally prefer to put them on local storage as local storage is cheaper than SAN storage. As SQL shouldn't be reading from them very often except on starting the service it shouldn't be a problem. If the system isn't in production I'd correct the install if it were me.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Storage and SQL Server.

Looking for relevant Storage Whitepapers? Visit the SearchStorage.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Apr 9 2008  12:20AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.