Diagnosing instance performance through waits, resources, monitoring, and baselines.
405 associated posts180 primary posts
I'm in Seattle this week for the PASS Data Community Summit. Before the pre-conference sessions started, I sat down to take your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=fqKEvcJ3hlU
On an unbelievably calm sea day off the shores of Canada, aboard the Norwegian Jewel, I enjoyed a nice cup of completely alcohol-free coffee (as far as you know) and took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=5NzgNMkQ8gU
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers.
https://www.youtube.com/watch?v=XDx-OnTHezA
I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento:
https://www.youtube.com/watch?v=R98zeXqpBRQ
Today's Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can't see the questions onscreen. Nonetheless, there are good answers in here, so let's do it:
https://www.youtube.com/watch?v=Nv0Wnli6kaE
I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones:
https://youtu.be/GefrKvKfG1Q
I went through your top-voted questions from https://pollgab.com/room/brento while in front of the National Gallery for Foreign Art in Sofia.
https://www.youtube.com/watch?v=12E_6VWKb_4
When I went through the top-voted questions at https://pollgab.com/room/brento, I didn't have all the answers today:
https://www.youtube.com/watch?v=g6fqxTPnDd0
I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver.
https://youtu.be/sd6yO-nHDx0
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/lDdQqlsyGN8
Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go through your top-voted questions from https://pollgab.com/room/brento. Why caffeine-free? Because I slug multiple coffees first thing in the morning when I wake up (usually around 3am-4am), and by the time I stream with y'all, I don't need any more go juice.
For this week's Query Exercise, your challenge is to find out who keeps messing up the rows in the Users table.
Take any size version of the Stack Overflow database, and the Users table looks like this:
On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is a little rough on this one because I used a new wireless microphone and forgot to put the wind shield on it. If you'd like to watch the spatial video version on an Apple Vision Pro or…
Not all of the questions y'all post at https://pollgab.com/room/brento require long-winded answers. Let's conquer 22 questions in 15 minutes!
https://www.youtube.com/watch?v=XGvqkIRwupk
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution plan (then executes <500ms) if multiple SPIDS all submit that query (different param values) when there's no plan at start, does each SPID calc the execution plan, one after the other after waiting for the prior SPID…
Today's Office Hours comes from a very different office! I climbed into the hot tub to review your top-voted questions from https://pollgab.com/room/brento. Don't worry, the webcast is completely safe for work.
https://www.youtube.com/watch?v=e1jg1_uHBxM
For this month's T-SQL Tuesday, I asked y'all to write about the most recent ticket or issue that you closed. (If you want to see other peoples' posts, you can check out the comments on that invite post, or wait til next week and I'll publish a wrap-up of everyone's answers.)
A past client emailed me with a performance emergency. Things had been going just fine, and then out of nowhere, things suddenly slowed down.
I answer your top-voted Azure SQL DB and SQL Server questions from https://pollgab.com/room/brento and lose my temper about what you're doing.
https://youtu.be/64e2r7sn130
The last Office Hours of 2023 featured some oddball questions from https://pollgab.com/room/brento. Not bad, just ... odd.
https://youtu.be/prkpWssHsaE
Most of the https://pollgab.com/room/brento questions from this episode had really short and sweet answers. Let's take a break for the holidays and knock 'em out:
https://youtu.be/nhB-dT8_VTg
