raf.figueroa (5/27/2015)
Hi,I plan to implement the disk spanning feature in Windows Server 2012 in order to create a single 12 TB volume (using 2 x 6TB disks). The new volume will hold a 10TB database while using SQL Server 2012.
The question is: Are there any known performance or stability issues when using SQL Server 2012 with the Widows Server disk spanning feature?
Regards,
-r
The answer to your question is irrelevant. You have NO HOPE of decent performance running a 10TB database on 6 disks!!!!!!! Do the math: 100-150MB/sec on sequential IO (WAY less if random IO) per disk. So how long would it take to scan your largest object??
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service