DRAG DROP
You are migrating an OLTP database from Windows Azure SQL Database to on-premise.
You are planning the installation of a Microsoft SQL Server 2012 server failover cluster. The
server has the following partitions:
You install the operating system on the C: drive.
The database solution will use row versioning, triggers, and cursors. The tempdb database
cannot be placed on the same disk subsystem as the OLTP database.
The OLTP database needs to be on the fastest disk subsystem possible. The database is
currently 200GB in size. It will not substantially increase in size in the next 3 years.
You need to plan the usage of the disk subsystems.
To which hard disk should each database belong? (To answer, drag the appropriate
database or databases to their corresponding hard disk or disks in the answer area. Answer
choices may be used once, more than once, or not at all. Answer targets may be used once
or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
SSD is not the fastest??? I think OLTP should be in SSD
No, raid level 10 is the fastest
@Ricardo, regardless of Speed, note that the OLTP database is currently 200GB in size and the SSD only has a capacity of 128GB.
Good job mister Holmes 😉
And SSD is Local… We are on a Failover Cluster, so need SAN disks