Perry Whittle (9/12/2012)
You're mixing dissimilar I\O patterns on the same physical array, they should be separated for maximum performance. 2 logical drives on the same array will have I\O pattern conflicts with the sequential log I\O and random database I\O.
What do you think about SAN LUNs? My storage guys here just give me LUNs for each SQL component(tempdb, data files, log files, system dbs, backups) Technically it's 5 different LUNs but they all live on the same physical array. I think it would be better to set up a physical array on the SAN that is used ONLY for SQL logs and then create LUNs on that array for the logs of all of the SQL instances. Really, the logs are the only component that is sequential, correct? The rest of the LUNs could all exist on the same physical array?
Maybe I'll start a new thread to discuss this. 🙂