Is there a best practice to advise a storage admin how to set a SAN up best for SQL Server OLTP & OLAP? or is this entirely company dependent?
Posted by: Denny Cherry
SQL Server, Storage
There are some general best practices such as separate data and log LUNs, separate TempDB from everything else. For data warehouses make sure that the data is spread over as many disks as possible. Anything more specific however is very company specific and would require a good understanding of what the databases look like as well as what the storage array looks like.