SQL Server Files Local or NAS or SAN?

NAS Definitely not NAS for SQL Server. SMB/CIFS does not have adequate support for file locking to support a DBMS (at least it didn’t a few years ago, ca. 2002-2003). Note that NFS does and you can actually do this with Oracle on an NFS server. However, SQL Server on a CIFS share is not … Read more

Choosing a SAN technology for 100s of VM Web Servers

The key to a good VMWare storage platform is understanding what kind of load VMWare generates. First, since you host a lot of servers, the workload is typically random. There are many IO streams going at the same time, and not many of them can be successfully pre-cached. Second, it’s variable. During normal operations, you … Read more

SAS vs. Nearline/MDL SAS – What is the difference?

Marketing. 7.2K drives are slower and easier to produce, and with higher error thresholds which improves yields (and capacity). However, in terms of I/O operations each discrete disk can support, the 7.2K drives are markedly less performant than their faster brethren. Therefore they get the ‘Nearline’ moniker, as they’ll hit I/O saturation much faster than … Read more

Are there no downsides to NetApp SAN solutions other than price? [closed]

We have had some ups and downs. Including finding our first ONTAP bug before we’d deployed and producing some certain benchmark conditions that weren’t quite what we expected. But that probably makes it sound worse than it really is. In service it has functioned very well and I wouldn’t hesitate recommending them to someone else. … Read more