What should you do ?

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. modify application code to use table variable
C. expand the tempdb data and log files
D. move the tempdb files to a local disk

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.