I am currently revising the IO setup in relation to our main SQL Server 2005 instance.
At the moment we have all data, logs and backups all on one LUN.
I have been allocated 4 LUNS which I was thinking of using as follows:
- LUN1 = Data Files
- LUN2 = Transaction Logs
- LUN3 = Backups
Now for LUN4 for I was thinking of either putting system databases here Master, Model, Temp or putting heavily used databases on here, which would be the most logical approach?
I guess I am just looking for suggestions as to how others would split this up.