File Systems

Optimizing SQL Database Performance

Optimizing Database Performance

File Systems

Server performance is not affected by the file system used (FAT or NTFS). Your choice of file system should be determined by factors other than performance.

  • The File Allocation Table (FAT) file system allows dual booting with computers running Microsoft® MS-DOS®, Microsoft Windows® 95, or Microsoft Windows 98.

  • The Microsoft Windows NT® file system (NTFS) has security and recovery advantages.

    If you do not need to dual-boot Windows NT or Windows 2000 with MS-DOS, Windows 95, or Windows 98, NTFS is recommended.

Warning  Microsoft SQL Server™ 2000 data and transaction log files must not be placed on compressed file systems.

For more information about choosing the appropriate file system, see the operating system documentation.

Note  When running on Windows NT, SQL Server performance can be improved further if the databases are created on disks formatted using NTFS and, specifically, 64-KB extent sizes. For more information about formatting an NTFS disk, see the Windows NT documentation.