You are the database administrator for a SQL Server 2005 computer named SQL1. Your company has five databases running on a single SQL Server 2005 instance. All indexes are created by using the SORT_IN_TEMPDB option to reduce the amount of time required and the amount of space used in the user databases to create and rebuild indexes.
You need to design the tempdb database for optimal performance. What should you do?
A.
Place the tempdb database on the same RAID-5 volume as the user databases.
B.
Place the tempdb database on a different RAID-5 volume from the user databases.
C.
Place the tempdb database on the same RAID-0 volume as the user databases.
D.
Place the tempdb database on a different RAID-0 volume from the user databases.
Explanation:
RAID-0 performs better than RAID-5 (the cost for the better performance is the lack of redundancy). Different volumes for user databases and tempdb database has better performance than a shared volume as it can read and write in both databases at the same time.