SQLCoffee - ReFS is supported on SQL Server 2014

[Company Logo Image]

ReFS is supported on SQL Server 2014

ReFS is supported on SQL Server 2014.

Applies to: Microsoft SQL Server 2014.

SQL Server 2012 and earlier versions of SQL Server do not support Resilient File System (ReFS). SQL Server 2014 introduces support for the ReFS.

SQL Server 2014 supports the DBCC command on databases allocated to ReFS volumes, since DBCC no longer uses named streams to create the internal snapshot database.

Advantages and disadvantages.

ReFS is a new file system introduced on Windows Server 2012. Some of the benefits for SQL Server instances are:

	ReFS was designed to storing massive amount of data making it perfect for Big Data and VLDB. It can handle partitions of 10²⁴ bytes. It has a limit of 18 million million files, and each file can have 64 Exabytes. Maximun path length is 32K.
	It is made to support large scales of write operations on the storage.
	Self-healing. It repairs it self automatically from corruption without the need to put volumes offline. Disk integrity tools are no longer needed. ReFS has a B Tree file system structure that uses 64-bit checksums at each level of the file system structure.
	Slight performance improvement when using ReFS without Integrity Streams. Please read thread contribution of Kevin Farlee (Microsoft SQL Server Storage Engine PM) listed below on the references section.

The main disadvantage of using ReFS is the lack of support for Sparse Files.

References.

DBCC CHECKDB behavior when the SQL Server database is located on an ReFS volume.

How to use SQL Server in Windows and Windows Server environments.

Resilient file system on SQL 2014 (MSDN thread).

ReFS is supported on SQL Server 2014.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.