You might have to adjust MFS settings prior to creating database though (or backup, change MFS, restore).
It is documented in Best Practices document. Did you read that?
on 2/19/10 10:04:01 AM EST
Windows Server as a File Server
Tune Microsoft Windows 2003 server to be a file server.
See the Microsoft article
http://support.microsoft.com/kb/174619 about this.
Increase NTFS MFT (Master File Table, used to be FAT) to 50% of the disk space. The result is that small files
are being stored in the MFT and not as separate files in the NTFS. This helps a lot because we have thousands
of small files.
2. Go to
3. In the right pane, look for the Dword named
4. If exists change the Dword to
5. If not exists, create a new DWORD
NtfsMftZoneReservation in the registry and set its value to 4.
The default value for this key is
1. This is good for a drive that will contain relatively a few large files. Other
3 or 4 instead of the default value of 1—Maximum file allocation
Unfortunately, Microsoft doesn't give any clear guidelines as to what distinguishes Medium from Larger and
Maximum levels of files. Suffice it to say, if you plan to store lots of files on your workstation, you may want to
consider a value of—Larger file allocation—Medium file allocation