You need to reduce the I/O workload on the SAN at a minimal cost

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?

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

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Kevin Burgess

Kevin Burgess

How can TEMPDB files be moved to a local disk? They need to reside on shared storage (the SAN) and the same applies to the system databases.

In this case only C could work.

Reply