Diagnosing instance performance through waits, resources, monitoring, and baselines.
405 associated posts180 primary posts
I've always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I ended up walking right past it while visiting Barcelona! It's one of the most important beginnings of modern architecture, and I loved it. I brought you along with me and talked through your top-voted questions from https://pollgab.com/room/brento.
Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of myself for that one.
https://www.youtube.com/watch?v=nUqIJtps8Y4
Most of the time, we use wait stats to identify SQL Server's bottleneck and focus on what to tune.
However, let's say you've got a really well-tuned SQL Server where:
I strapped on my Apple Vision Pro, updated its OS, and recaptured my persona with the latest updates, and... it's still pretty weird. Let's go through your top-voted questions from https://pollgab.com/room/brento and have a laugh at my hot dog fingers.
https://www.youtube.com/watch?v=tLAEqItBnuI
Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I joined in this year, and before the tournament, sat on the shores of Lake Napissing to answer your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/49Ycmorwk_g
I'm back home after a 2-week Iceland vacation. Let's catch up with your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=PV6MuFQkf5k
tl;dr: if you use Azure SQL DB Hyperscale's auto-scaling, it's probably not cutting your bill down because like SQL Server, Hyperscale doesn't automatically relinquish memory, and it'll be up to you to manually manage your own memory if you wanna cut your bill.
Now for the long story.
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=f0chyzVLFYw
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We used to get full-blown knowledge base articles about fixes, but these days, we get a collection of footnotes with deceiving hyperlinks that look like they're going to lead to more information - but they simply lead back to themselves.
Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=gkeEKyzc01M
This entire blog post is driven by the #1 feature in this list. I think about the #1 feature a lot, like at least once a week. I think about it so much that I had to stop and think about what other similar great things Microsoft has done over the years, and be thankful for what a nice platform this is to work with. Let's go through 6 of my favorite Microsoft decisions.
I've already explained that no, it doesn't make your database server more reliable - and in fact, it's the exact opposite. But what about performance? The answer is going to depend on your hardware and workload, but let's work through an example. I'll take the first lab workload from the Mastering Server Tuning class and…
For the last Office Hours of the year, I'm coming to you from Tokyo, the last stop on my 3-week tour of China and Japan. This was a big Epic Life Quest task for me, for sure, something I've wanted to do for decades. Let's bring you along and go through your top-voted questions from https://pollgab.com/room/brento:
Kon'nichiwa! My vacation tour continues in Osaka, Japan, a city famous for its street food, nightlife, and host and hostess clubs. I'm usually the kinda guy who does classy dinners at 5PM and then hits the sack by 9PM at the latest, so you might wonder how I got here. The answer is that Yves planned this trip out, hahaha, so here we are. As long as we're here, let's go through your top-voted questions from https://pollgab.com/room/brento.
For the rest of December, I'm out vacationing in China and Japan. For this episode, I'm coming to you from the People's Park in Zhengzhou, China, which is kinda like the Chicago of China. It's in the middle of the US, bigger than people think (13 million people), and has beautiful parks.
https://youtu.be/BT9L-Qiv64c
I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your questions from the rooftop deck of the adorable Petit Ermitage hotel.
https://www.youtube.com/watch?v=0MtdQkAw9a8
What, doesn't everyone park a convertible in their dining room? I address the pink elephant in the room, and then take your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=9utvLk9K9Qc
I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats - hang in there, I get it fixed in a few seconds.
https://www.youtube.com/watch?v=PC9JokmIkuM
There's a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take the top-voted ones, but today, see if you can spot the thing they all have in common:
https://www.youtube.com/watch?v=reaEWQ1TzLg
That face I'm making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out loud at this one. Anyhoo, let's get to answering your top-voted questions from https://pollgab.com/room/brento:
https://www.youtube.com/watch?v=a0zOllaozX4
