Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time:
Here’s what we covered in this episode:
00:00 Start 02:17 Tanchenglai: Hi Brent, recently we always ran into thread pool issue. I checked Performance Dashboard and found that CPU spiked over 80% occasionally. I suspect apps can’t connect after CPU over 80%. 03:55 Janis : I’m facing a puzzling issue with a simple join query, warns excessive 1/2 GB memory grant when joining the final table. I wonder where to dig deeper for a solution. 05:02 Novice Consultant: Hey Brent!