We have a SQL Server with 32GB of RAM, 8 CPU 16 Cores, using SAN.
On our production database (1 database only) we have 3 file groups Primary, Core, Index with 1 file in the PRIMARY Group, 16 Files in the Core Group, and 16 Files in the Index Group. Each file group including all data files belonging to the file group is in its own drive on the SAN.
Is that a correct way to setup your database files and file groups?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!