MilesB
Dabbler
- Joined
- Nov 26, 2014
- Messages
- 16
Hi
I work at a very large financial institution and am assembling a proof of concept SQL environment. Our IT department has a history of building expensive low performance systems. I obtained some POC funding and have begged/borrowed some hardware and am now ready to build. I am intending to run MS SQL 2014 on a separate machine and use FreeNAS to manage the storage. My goals are max IOPS, min latency, and absolutely must have adequate redundancy and encrypted storage. Snapshots are not really a concern for me. SSDs will be used in the SQL machine for index storage but would not be suitable for cache in the FreeNAS table storage. My FreeNAS hardware:
ex-Dell T5500 motherboard with 2x Xeon X5650 (hex core 2.66-3.06GHz)
144GB DDR3 ECC RAM
LSI SAS 9201-16e connected to 3 Chenbro 23601 expanders
Each expander connected to 24 Toshiba 7200 rpm 4TB HDDs = total 72 x 4TB HDD
Chelsio S320e-SR 10gbe card to connect to identical card in SQL Server with twinax cable
I am looking for suggestions on pool/general configuration and whether to use iSCSI or NFS. I am leaning towards 36 mirrored pairs and iSCSI. If I understand correctly, this will give me read IOPS of 72 disks and write IOPS of 36 with capacity of 36 (adequate). Please let me know if I'm wrong and any other advice you may have. I'm very new to all of this but am trying to get this technology accepted in my workplace so that we can expand.
I work at a very large financial institution and am assembling a proof of concept SQL environment. Our IT department has a history of building expensive low performance systems. I obtained some POC funding and have begged/borrowed some hardware and am now ready to build. I am intending to run MS SQL 2014 on a separate machine and use FreeNAS to manage the storage. My goals are max IOPS, min latency, and absolutely must have adequate redundancy and encrypted storage. Snapshots are not really a concern for me. SSDs will be used in the SQL machine for index storage but would not be suitable for cache in the FreeNAS table storage. My FreeNAS hardware:
ex-Dell T5500 motherboard with 2x Xeon X5650 (hex core 2.66-3.06GHz)
144GB DDR3 ECC RAM
LSI SAS 9201-16e connected to 3 Chenbro 23601 expanders
Each expander connected to 24 Toshiba 7200 rpm 4TB HDDs = total 72 x 4TB HDD
Chelsio S320e-SR 10gbe card to connect to identical card in SQL Server with twinax cable
I am looking for suggestions on pool/general configuration and whether to use iSCSI or NFS. I am leaning towards 36 mirrored pairs and iSCSI. If I understand correctly, this will give me read IOPS of 72 disks and write IOPS of 36 with capacity of 36 (adequate). Please let me know if I'm wrong and any other advice you may have. I'm very new to all of this but am trying to get this technology accepted in my workplace so that we can expand.