Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round:
Here’s what we covered:
00:00 Start 00:34 Alain Térieur: Hi Brent. I started the restore of a (big) DB. And it took more than 2h before the resore actually started. What was SQL doing all that time? And more generally, how to know what SQL is doing in the background? And how can an admin have control over those tasks? 01:08 The Questioner: Hi Brent! How do I see the actual execution plan for the top query in sp_BlitzCache? To