Question 8 of 10Pro Only
You receive an alert at 2 AM that database response times have tripled compared to normal. Walk through your complete investigation methodology from the moment you receive the alert to identifying and resolving the root cause.
Sample answer preview
A production performance incident at 2 AM requires a structured, methodical approach that balances urgency with thoroughness. Panic-driven random troubleshooting wastes time and can make the situation worse. My first action is to assess the severity and scope.
incident responsewait statistics baselineplan regressionsp_WhoIsActivetempdb contentiontransaction log