Hello -
I'm new to this group, but not SQL Server. I have a question regarding SQL
Server Storage Allocations, and I'm hoping this is the proper forum. If
not, please suggest where I should post this message.
I'm at a location that wants to migrate from one SAN to another (4
terabytes) - the current layout will move straight, and then we'll design a
better layout in time.
I am familiar with spreading out logs and tempdb from data storage, and I
also understand placing indexes and heavily used tables on their own
devices. We're talking about a SAN here, so even those basic assumptions
get a little fuzzy depending on the vendor.
What I'm after is where to find the deeper issues for planning these
database file groupings and layouts. A sort of "best practices" guide for
storage, if you will. I'm not talking about vendor documents from EMC or
IBM, those all seem to deal with backups and so forth. I need to plan this
properly, above and beyond the basic assumptions I've made above.
Any pointers from the group?
Thanks!
