PrepAway - Latest Free Exam Questions & Answers

What other actions can be taken to optimize SQL performance?

The SQL database and transaction logs have been physically isolated on separate RAID groups.
What other actions can be taken to optimize SQL performance?

PrepAway - Latest Free Exam Questions & Answers

A.
Use RAID 1/0 for transaction logs only.

B.
Use RAID 5 for transaction logs and tempDB.

C.
Use RAID 5 for tempDB only.

D.
Use RAID 1/0 for transaction logs and tempDB.


Leave a Reply