we have 2 SQL server running in a Cluster mode. The DB is located on a storage.
The servers and the storage are very old now and we want to buy new hardware and upgrade.
Now my DB is on a storage but I want to change this.
I want to buy to servers and want to have the DB´s directly on the servers, because of performance.
I want to create different Raid Sets for TempDB, DataBase FIles and Logfiles.
Can you help me which mode is recommended and useful ?
We have almost 300 users.
The DB´s almost 200 GB.