CompTIA Server+ SK0-005 Practice Question
Users complain that queries against the company's production SQL Server cluster are much slower than usual this morning. Reports show the slowdown began shortly after last night's maintenance window, when the storage team expanded the SAN LUN that holds the cluster's data files and the Windows team applied cumulative OS patches to both nodes. You have just begun the troubleshooting process.
Which first question to the relevant stakeholders would BEST help you determine the scope of the problem?
Should we immediately fail over the SQL cluster to the secondary node to see if that restores normal performance?
Can someone provide the 24-hour growth trend for tempdb so we can compare it to yesterday's baseline?
What exact changes were made during the SAN LUN expansion-including size, pathing or zoning adjustments-and at what time did the work complete?
Have we already run DBCC CHECKDB to verify the integrity of every database on the cluster?