You administer a Microsof

t 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

D