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.
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.