Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel.
Here’s what we covered:
00:00 Start 04:40 neil: are there any ‘band aids’ a DBA can apply for a third-party application that deadlocks all the time or is it up to the vendor of the application? maybe maxdop=1 or just tweak some indexes & general performance tuning and hope for the best? 06:58 Yehudah: What is the best way to