Home Forums Database Design Hardware Placement of SQL Server Data and TLog files in a SAN Infrastructure and Monolith Storage Environment RE: Placement of SQL Server Data and TLog files in a SAN Infrastructure and Monolith Storage Environment

  • Hi,

    You have Tiered Storage - what process decides which storage is used? Does the SAN automatically move frequently-accessed data to SSDs, or do you have 3 classes of LUN (one for each storage tier)?

    You would need to talk to your SAN guru to find out how each Physical Node of the new Cluster is connected to the SAN; if you have a true Switched Fabric, then you need to look at the distribution of the fibre channel switches.

    For the rest, I agree with you. The individual physical disks, or spindles, are so far removed from the Drive Partition visible in the OS, that fine-tuning the setup seems to be fruitless. I separate mdf/ldf/tempdb from the C: drive, to minimise the potential for consuming all space on the system drive, but apart from that, I have so little influence over the performance of the SAN that further tweaking is not worth it.