[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
ReFS is supported on SQL Server 2014

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

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:

bulletReFS was designed to storing massive amount of data making it perfect for Big Data and VLDB. It can handle partitions of 1024 bytes. It has a limit of 18 million million files, and each file can have 64 Exabytes. Maximun path length is 32K.
bulletIt is made to support large scales of write operations on the storage.
bulletSelf-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.
bulletSlight 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).


 

 

 

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