You administer a Microsoft SQL Server 2012 instance that has multiple databases. You have a twonode 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
For me should be D. Dont know why I’ve seen B as correct.
D
Check the comments here:
http://www.aiotestking.com/microsoft/you-need-to-reduce-the-io-workload-on-the-san-at-a-minimal-cost-2/
Meant the comments here
http://www.aiotestking.com/microsoft/you-need-to-reduce-the-io-workload-on-the-san-at-a-minimal-cost/