You administer a Microsoft SQL Server 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
You administer a Microsoft SQL Server instance that has multiple databases. You have a two-node SQL Server failover clus
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You administer a Microsoft SQL Server instance that has multiple databases. You have a two-node SQL Server failover clus
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!