You administer a Microsoft SQL Server 2012 instance that has multiple databases. You
have a two-node SQL Server failover cluster. The cluster uses a storage area network
(SAN).
You discover I/O issues. The SAN is at capacity and additional disks cannot be added.
You need to reduce the I/O workload on the SAN at a minimal cost.
What should you do?
A.
Move user databases to a local disk.
B.
Expand the tempdb data and log files.
C.
Modify application code to use table variables.
D.
Move the tempdb files to a local disk.
I think the answer should be Expand the temp data and log files
any one agree with me ?
It doesn’t help in reducing I/O read write on SAN. If we move tempdb to a local drive (which is a feature in 2k12) we can reduce the load.
The Questions says, the disk is at capacity, so there wouldn’t be space to expand them.
I think it would be A.
Move user databases to a local disk.
Not possible, you are on a Failover Cluster Instance
D is the correct Answer, As SQL 2012 onwards you can have the tempdb onto local drives.
Also it gets re-created, when you start the SQL Server, or a failover happens.
A -> Not possible (Failover Cluster)
B -> Don’t know where is stored the TempDB and don’t think it’ll help
C -> Don’t think it’ll help
D -> The best answer for me
D – while SAN is at capacity the only solution is to move temp data to local disk.