Diagnosing instance performance through waits, resources, monitoring, and baselines.
405 associated posts180 primary posts
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.
You posted SQL Server questions and upvoted the ones you'd like to see at https://pollgab.com/room/brento, and before the Cabo Clasico finals start for the day, I sat by the pool to talk through 'em:
https://www.youtube.com/watch?v=--nU3K47Eyc
For my Office Hours streams on my Twitch channel, y'all post questions at PollGab and upvote the ones you'd like to see me discuss on the stream. However, not all questions require a video answer. Here are some simple no-brainer ones:
Q: BehindTheScenesDBA: With all its limitations, what do you think about memory-optimized tables? Have you recommended to a client to use it?
It's the last San Diego balcony edition of Office Hours! You posted your questions at https://pollgab.com/room/brento and upvoted the ones you'd like to see.
https://www.youtube.com/watch?v=YLA2O4m99lE
You're investigating your SQL Server's top wait stats, and you're noticing a lot of LCK% waits. Normally, that indicates blocking and deadlocks, but you're just not getting complaints from your end users, and you're wondering what's causing it.
It might be overzealous index rebuilds.
Ask me questions at https://pollgab.com/room/brento and upvote the ones you'd like to see covered. I can pretty well guarantee that your favorite question this time is going to be the last one I answered.
https://www.youtube.com/watch?v=grzauq0qiV8
Got SQL Server questions? Post 'em at https://pollgab.com/room/brento and upvote the questions you'd like to see me discuss.
https://www.youtube.com/watch?v=hmmaAwf4r4k
Most of the time, when you need to change SQL Server's behavior - like how it handles memory or parallelism - there are easy-to-use switches to get the job done. In SQL Server Management Studio, just right-click on the server's name, go into Properties, and there are all kinds of things you can mess with. Most of the time, you're going to make things worse, but whatever.
You posted and voted on questions at https://pollgab.com/room/brento and I answer 'em on the beach. It's not your eyes: the camera's hunting for focus a lot in this video.
https://www.youtube.com/watch?v=nSfJmaY5sL8
I've got a really sensitive lens (Sigma 16mm f/1.4) on my camera, so often when I record these at sunrise, it's already too bright for you to see the sun. This time, I went down to the beach a little earlier, and through the video, you can see the light really pick up.
https://www.youtube.com/watch?v=QcPyx-5jWGM
Let's pick up right where we left off yesterday. I've got more time and champagne, so let's keep going through your top-voted questions from PollGab.com/room/brento.
https://www.youtube.com/watch?v=raWyoVlW0lc
Out of all of the scripts in our free First Responder Kit, sp_BlitzBackups is probably the one you've used the least. Let's talk about what comes out of it, and why you should use it more often.
First, let's define two terms:
I hang out on my balcony in San Diego with a gin & tonic and a bunch of your highly upvoted questions from https://pollgab.com/room/brento.
https://youtu.be/kAzUupChX_Y
In my free How to Think Like the Engine class, we start out by measuring query performance using logical reads. That's the number of 8KB data pages that SQL Server has to read in order to find your query's results. That's the measure I use the most because generally speaking, the less data your server has to read, the faster your query will finish.
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
It's a beach day! Let's hang out at Silver Strand State Beach and I'll take your highly voted questions from https://pollgab.com/rooms/brento.
https://www.youtube.com/watch?v=qTocbvnQgFs
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
On a very chilly morning, I went through your highly-upvoted questions from here and talked through 'em:
https://www.youtube.com/watch?v=lpklTAJdrBE
I stopped at a waterfall in Iceland to answer your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=tWguvLfHaNA
I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/.
https://www.youtube.com/watch?v=K4l522V4h08
