Scalability and performance is one of the core areas of SQL Server that we should take care of. Today, I was searching for something on MSDN and came across an exciting page (Scalability and Performance Enhancements). In this page, I found few Scalability and Performance Enhancements shipped with SQL Server 2012. The exciting topic was flashing & encouraging me to test was FILESTREAM Filegroups Can Contain Multiple Files
The purpose of this enhancement is to increase the performance of your database because now you can place multiple files in multiple drives under one file group.
Let me create a sample to explain how you can contain multiple files in a single file group.
CREATE DATABASE [Personal_DB] CONTAINMENT = NONE ON PRIMARY ( NAME = N'Personal_DB', FILENAME = N'C:\Data\Personal_DB.mdf', SIZE = 100MB, MAXSIZE = UNLIMITED, FILEGROWTH = 1MB ), FILEGROUP [FS] CONTAINS FILESTREAM DEFAULT ( NAME = N'Music', FILENAME = N'C:\Data\Music', MAXSIZE = UNLIMITED ), ( NAME = N'Videos', FILENAME = N'C:\Data\Videos', MAXSIZE = 100MB ) LOG ON ( NAME = N'Personal_DB_log', FILENAME = N'C:\Data\Personal_DB_log.ldf', SIZE = 100MB, MAXSIZE = 1GB, FILEGROWTH = 1MB ) GO
Do share with me if you implemented this enhancement in the real world.