Forum Discussion

Hrishikesh_Lele's avatar
Hrishikesh_Lele
Copper Contributor
Apr 17, 2022

SQL SERVER 2016 AND RAID 5

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

  • Robin Shanab's avatar
    Robin Shanab
    Iron Contributor
    Apr 18, 2022
    SQL Server uses the logical drives Windows presents to the application. You can talk to your hardware vendor.
    • Hrishikesh_Lele's avatar
      Hrishikesh_Lele
      Copper Contributor
      Apr 19, 2022

      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.

Resources