What should you do?

You administer a Microsoft SQL Server 2016 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.

View Answer

Answer: D

Explanation:

You can configure TempDB on a local disk when you, for example, installing your SQL Server cluster.

References: https://www.mssqltips.com/sqlservertip/2817/sql-server-2012-cluster-with-tempdb-on-local-disk/