SQL SERVER 2016 AND RAID 5

%3CLINGO-SUB%20id%3D%22lingo-sub-3287676%22%20slang%3D%22en-US%22%3ESQL%20SERVER%202016%20AND%20RAID%205%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3287676%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ECan%20we%20implement%20RAID%205%20architecture%20on%20a%20machine%20running%20Windows%20Server%202016%20and%20SQL%20Server%202016%20Standard%20edition%20with%201TB%20each%2C%203%20SATA%20SSD's.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEveryday%2C%20around%20350%20Mb%20of%20data%20is%20pushed%20in%20the%20user%20defined%20databases.%20The%20application%20demands%205%20user%20defined%20databases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20yes%2C%20how%20should%20the%20database%20administration%20be%20carried%20out%20for%20this%20particular%20configuration%20and%20data%20size%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288962%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20SERVER%202016%20AND%20RAID%205%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288962%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35851%22%20target%3D%22_blank%22%3E%40Robin%20Shanab%3C%2FA%3E%26nbsp%3Bthanks%20for%20writing.%20Actually%20I%20have%20a%20business%20application%20that%20demands%20a%20DELL%20SERVER%20(not%20yet%20decided)%20and%20SQL%20SERVER%202016%20Standard%20edition.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20existing%20machine%20(already%20supplied%20in%20April%202021)%20with%20s%2Fw%20RAID%201%20(2%20HDD's%201%20TB%20each)%20and%20SQL%20SERVER%202014%20EXPRESS%20takes%20a%20lot%20of%20time%20to%20read%20data%20from%20the%20databases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHence%20I%20am%20looking%20into%20upgrading%2Ftuning%20the%20upcoming%20machines%20in%20the%20areas%20of%20data%20structuring%20and%20database%20administration.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20advice%20on%20how%20to%20design%20the%20system%20consuming%20~350%20Mb%20of%20data%20per%20day%20in%20the%20databases.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288867%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20SERVER%202016%20AND%20RAID%205%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288867%22%20slang%3D%22en-US%22%3ESQL%20Server%20uses%20the%20logical%20drives%20Windows%20presents%20to%20the%20application.%20You%20can%20talk%20to%20your%20hardware%20vendor.%3C%2FLINGO-BODY%3E
New Contributor

Hello,

Can we implement RAID 5 architecture on a machine running Windows Server 2016 and SQL Server 2016 Standard edition with 1TB each, 3 SATA SSD's.

 

Everyday, around 350 Mb of data is pushed in the user defined databases. The application demands 5 user defined databases.

 

If yes, how should the database administration be carried out for this particular configuration and data size?

2 Replies
SQL Server uses the logical drives Windows presents to the application. You can talk to your hardware vendor.

@Robin Shanab thanks for writing. Actually I have a business application that demands a DELL SERVER (not yet decided) and SQL SERVER 2016 Standard edition.

 

The existing machine (already supplied in April 2021) with s/w RAID 1 (2 HDD's 1 TB each) and SQL SERVER 2014 EXPRESS takes a lot of time to read data from the databases.

 

Hence I am looking into upgrading/tuning the upcoming machines in the areas of data structuring and database administration.

 

Can you advice on how to design the system consuming ~350 Mb of data per day in the databases.