[Video] Office Hours at the Last Spike
I drove the Graffiti Gulf out to The Last Spike (video) outside of Las Vegas and took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=XcNJVJ1-XaE
Instance Resource Pressure and Tempdb
CPU, memory, tempdb, and related instance-level bottlenecks.
53 associated posts51 primary posts
Performance Tuning
The Version Store Won’t Clear If ANY Database Has Open Transactions.
Short story: what the title says.
This is especially problematic for folks who merge multiple databases onto the same server. All it takes is one badly-behaving application to leave its transactions open, and suddenly it causes the rest of the databases to run TempDB out of space. That app's transaction might not even be changing anything, and it might have never caused problems for that application before - but once it shares a TempDB with other apps, it causes cascading problems.
Performance Tuning
TempDB Filling Up? Try Resource Governor.
TempDB is one of the banes of my existence.
Anybody, anybody who can query your server can run a denial-of-service attack in a matter of seconds just by filling it up with a simple query:
[Video] Office Hours: Database Questions & Answers
In between clients, I hopped onto my Twitch channel to take your top-voted questions from https://pollgab.com/room/brento. If you'd like to get notified whenever I do one of those live streams, you can follow my channel for free and you'll get email notifications automatically. I do 'em whenever I have time, usually about once a week when I'm at home.
SQL Server 2025 Makes Memory Troubleshooting Easier.
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently.
To show how it works, let's run a bunch of simultaneous high-memory-grant queries in the Stack Overflow database:
[Video] Office Hours on the Cruise Ship
I'm on a Med cruise, and I stopped the boat today in Corsica to make sure your questions from https://pollgab.com/room/brento got the answers they deserve. I started by mentioning that I'm using a 360 degree camera, but the file size on that video was so huge that I couldn't upload it from the cruise ship, so you just get the 180 version.
[Video] Office Hours: Back in the Home Office
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
[Video] Office Hours: Car in the Dining Room Edition
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
[Video] Office Hours on a Calm Sea Day Off Canada
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
[Video] Office Hours: Abrupt Intro Edition
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
[Video] Office Hours: Ask Me Anything About #SQLServer
I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones:
https://youtu.be/GefrKvKfG1Q
[Video] Office Hours in Snowy Telluride, Colorado
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…
Performance Tuning
What Happens When Multiple Queries Compile at Once?
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…
[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/5lF0RtdBPP8
[Video] Office Hours: Stump Me On SQL Server
I went through the top-voted questions from https://pollgab.com/room/brento and discussed 'em live on my Twitch channel.
https://youtu.be/tyu0JN7H_hQ
[Video] Office Hours: Extended Answers Edition
Y'all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time:
https://www.youtube.com/watch?v=f3sFkvgPPFQ
[Video] Office Hours: Ask Me Anything About SQL Server
Y'all just never run out of interesting questions at https://pollgab.com/room/brento! I'm impressed, got another great round today.
https://youtu.be/LouW_Vxr7Yg
[Video] Office Hours: Cabo Balcony Edition
Post your questions at https://pollgab.com/room/brento and upvote the questions you'd like to see me discuss.
The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing in the background and just listen to it rather than watch.
[Video] Office Hours in Malibu: Ask Me Anything About SQL Server
I'm up bright and early in Malibu, so let's talk through your highly upvoted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=VwKeu4WAPuI
[Video] Office Hours: Ask Me Anything About SQL Server
It's time for the first live Office Hours in my new home studio in San Diego! I took your highest-upvoted questions from https://pollgab.com/room/brento/ and answered 'em:
https://www.youtube.com/watch?v=1ZS3Hcpry_A
