My db is currently around 650mb but is is increasing with around 500 concurrent users doing transactions and reporting at the same server. Please let me know whether the following changes can improve the performance or not.
1. Moving mdf,ldf,tempdb to seperate drives.
2. Create 2 server one for transactions and one for reporting ,replicating data to second server through always on or replication mechanism.
3- changing the current raid 5 to raid 10 in first server or both.
What other changes i need to bring to improve performance , becouse some of the query is performing very slowin the server . can i expect performance gain by doing the above tasks.