Coraid is a provider of network storage solutions featuring their line of EtherDrive and EtherCloud solutions. Designed from the ground up for virtualization and cloud architectures, Coraid's platform has been deployed by more than 1,700 customers worldwide. For more information on network storage solutions visit Coraid.com
About the Author:
Feature Article: November 2013
When working with large SQL databases, deciding on the best storage option is rarely straightforward. One option that has both positives and negatives is a network attached storage (NAS) solution.
NAS is a file-level storage solution connected to a network that provides data access. While NAS works as a file server, its hardware, software, and configuration will dictate its actual use. It is normally not a “general purpose” computer. SQL can function well on a NFS services for UNIX, however, most of the time NAS is used on a Windows-type file service, such as a Common Internet File System/Server Message Block (CIFS/SMB). By default, use of network database files is not enabled for SQL Server.
A NAS unit looks like a standard network servers and operates through the network layer. It does not require any specialized hardware, such as a FibreChannel card, and is generally considered inexpensive since network card slots are not very expensive. Ultimately, a NAS device is a worthwhile consideration for a SQL server. They are very fast and offer plenty of features that would cost much more when using other storage solutions. They also have enough internal and network bandwidth to support multiple SQL servers. They generally use Alpha or PowerPC designs instead of Intel processors.
While NAS solutions have plenty of great positives for SQL management, they do have a few detractors. The initial investment can be higher than other solutions, depending on how many servers are connected to the NAS. Additionally, a NAS solution is really best for read-only databases. There is a greater risk of data loss when working with a read-write database. A NAS solution is not generally the first consideration for SQL management, however, it can work well.
As mentioned previously, use of network database files is not enabled by default. Therefore, it is important to remember that NAS devices need to be accessed using UNC (Universal Naming Convention) names (\\Servername\Sharename). That means you will need to set trace flag 1807 to access the SQL server, as this is not set it its default state.
Ultimately, a NAS solution offers many different positives for SQL management. It is important, however, that some additional work is done prior to setup and client access in order to avoid potential issues down the road.
This 2015 article by Craig Mullins is a part of a multi-part series on database systems from TechTarget.
|What is a Database?|
|The History and Future of Database Change Management|
|Fixing Corrupt Microsost Access Databases|
|How to Work Remotely and Still Be The Best|
|Social Data Has Become Social Big Data|
|The Future of Data Centers: Achieving Agility in a Rapidly Shifting World|
|Here’s a News Year’s Resolution: Master Your Database|
|Making the Grade: Cost Savings Upgrades for Today's Data Center|
|How to Choose the Best DBA for Your Company|
|Virtualization: Wading Through the Deluge of Data|
|SQL Databases and Network Attached Storage|
|Why Big Data Needs Cloud|
|Ten reasons why you should use data models to build apps|
|Beware Big Schema|
|How to Implement Successful Data Integration Cross-Regionally|
|Forging a Path Beyond Hadoop - Software Database Mgmt Sys for Big Data Analytics|
|Database Tips and Tricks|
|Why Data Still Matters|