Diagnosing instance performance through waits, resources, monitoring, and baselines.
405 associated posts180 primary posts
When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, "Who in their right mind would actually use this?" I was so horrified that I wrote a presentation about it and gave it at a couple of conferences:
https://www.youtube.com/watch?v=Nlrc56Q4ABQ
Lots of good questions on today's broadcast! If you'd like to submit one, go to https://pollgab.com/room/brento and upvote the ones you'd like to see me cover.
https://youtu.be/phAwmrItoCY
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
Normally, y'all post and upvote great questions at https://pollgab.com/room/brento, but in today's episode, y'all upvoted some stinkers. Buckle up.
https://youtu.be/FF6QOt4Y6dM
Every time I think, "There can't be any more SQL Server questions left," y'all post more great ones at https://pollgab.com/room/brento!
https://www.youtube.com/watch?v=ZcF2sG5J4sk
Y'all post questions at https://pollgab.com/room/brento, upvote the ones you'd like to see me cover, and then I talk through 'em.
https://youtu.be/aEe-uz2Ikvc
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.
https://youtu.be/iuv-HOqlKBw
Over the past month (plus or minus a couple days), Erik Darling churned out dozens of posts to show how he uses different SQL Server Community Tools that are free and open source to troubleshoot SQL Server issues. You should read all of them. I did. (I also shamelessly copy/pasted this intro, plus the below, directly from his blog.)
Got questions about the Microsoft data platform? Post 'em at https://pollgab.com/room/brento and upvote the ones you'd like to see me cover. Today's episode finds me in my home office in Vegas:
https://youtu.be/QRRFAW7rgVo
When your SQL Server's top wait stat is ASYNC_NETWORK_IO, that indicates SQL Server is waiting on the app to ask for the next part of the result set.
This is a real pain in the rear to troubleshoot because often these waits happen for really short duration each time - think milliseconds, not seconds. It's an issue of death by a thousand cuts.
Post your questions at https://pollgab.com/room/brento and upvote the ones you'd like to see me cover. In today's episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions:
https://www.youtube.com/watch?v=IQxkIULzKZY
This month on the blog is Community Tools Month, and I'm going to be talking about some of the most useful and influential tools out there.
You can't learn them all - *I* can't learn them all - because there just aren't enough hours in the day to do your work, keep your skills sharp, take care of yourself, and take care of the ones you love.
I hopped down to Cabo San Lucas and sat at the End of the World to answer the questions you posted & upvoted at https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=KnhFkaCVv_8
Got questions for me? Post 'em at https://pollgab.com/room/brento and upvote the ones you'd like to see me cover. I filter out the ones that are too short for video answers, and here's the latest batch: Thomas Franz: When I have a very large table with no statistics (or not on a specific column in the…
It seems obvious: add some memory, and SQL Server should be able to cache data, thereby making queries run faster ... right?
Well, if you can't cache everything you need for a query, you might be surprised to find that SQL Server may still read the entire table up from disk, regardless of what parts of the table are currently cached in memory.
Not all of the questions you post at https://pollgab.com/room/brento are hard. Some of 'em can be answered in one line:
Q: accidentalDBA: Hi Brent, My friend is moving from two physical servers (production + failover) to VMs on the same host and SAN. His manager wants to keep log shipping as a DR solution. I advised against this as most disasters would affect both VMs equally. Am I missing something?
In ten minutes, let's cover as many questions as possible from https://pollgab.com/room/brento:
https://www.youtube.com/watch?v=VwW-orDLwDY
Not all of the questions y'all post at https://pollgab.com/room/brento are hard - some of 'em can be answered in just a line or two:
Q: Hany: Hello Brent, Who's "Brent Ozar" in the Azure world?
On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=TbrGmJGOL_o
Some questions that come in at https://pollgab.com/room/brento have such straightforward answers that I don't need to cover them on video. It's time for a rapid-fire speed round:
Q: Uncle Buck: Is there a good way to tell if a given include column for a NC index is being used at all?
