Hello,
I'm either looking for clarification or redirection.
I'm commissioning a new database that will eventually grow into a very large OLTP database.
Traditionally I've always separated the physical disks that Data and Log files are on and used a separate Filegroup for non system objects and data.
My new system is going to be on a SAN and although they have allocated separate drives for me they are all on the same LUN.
So is there any reason to separate the non system objects and data out of the Primary Filegroup?
Out of intererest I'm also pushing for a separate drive for the TempDB too, so we can size it to fill the drive, if you'd like to comment on that too?
Thanks
Giles