Storage Considerations for SQL Server 2005
Now let’s put all the previous information together and relate it specifically to SQL Server storage needs. Knowing the type of data to be stored, whether shared files, archives, or SQL Server data, for example, will help you determine what system is best. SQL Server performance is very dependent on I/O performance. In other words, read and write latencies greatly affect SQL Server performance. Therefore, for the very best I/O performance with SQL Server you would choose a block-based data transport protocol, either SCSI, iSCSI, or FCP. NAS, which transports data in file form, is not really a viable choice for SQL Server data.
To determine whether to select less costly SCSI DAS or more expandable and flexible ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
