Big Ideas
The more I used third party monitoring tools, the more annoyed I get. So much is missing from the details, configurability, and user experience.
I often find myself insisting on also having Query Store enabled. As much as …
Category: Query Store
Common SQL Server Consulting Advice: Enabling Query Store
Captain, Captain
Third party monitoring tools are in rough shape these days. That’s all I’m gonna say about the situation. I get enough letters from lawyers on account of my BTS fanfic sites.
With that out of the way, let’s …
Working With A SQL Server Consultant Checklist: Monitoring Tools And Query Store
Forensics
I get called in to help with a lot of interesting performance problems. I’m gonna say something that sounds harsh right up front: very few people are prepared for sudden issues.
After the fact (and usually after a reboot …
SQL Server Query Store Improvements I’d Like To See
Not Love Or Hate
I like Query Store, I do. I don’t love the GUI, though. In fact, I kinda hate it — enough that I spent a hundred or so hours writing a script called sp_QuickieStore to avoid it …
Query Store Improvements I’d Like To See For SQL Server: Get The Full Query Text From The GUI
Spirited Away
This week’s posts are a series of short, and, admittedly lazy ones about improvements I’d like to see in Query Store.
I’m away from home for the Holiday Week, and I don’t have a lot of time to …
Query Store Improvements I’d Like To See For SQL Server: Choose Queries To Ignore
Spirited Away
This week’s posts are a series of short, and, admittedly lazy ones about improvements I’d like to see in Query Store.
I’m away from home for the Holiday Week, and I don’t have a lot of time to …
Query Store Improvements I’d Like To See For SQL Server: Forced Plan Association
Spirited Away
This week’s posts are a series of short, and, admittedly lazy ones about improvements I’d like to see in Query Store.
I’m away from home for the Holiday Week, and I don’t have a lot of time to …
Query Store Improvements I’d Like To See For SQL Server: Memory Grant Columns
Spirited Away
This week’s posts are a series of short, and, admittedly lazy ones about improvements I’d like to see in Query Store.
I’m away from home for the Holiday Week, and I don’t have a lot of time to …
Query Store Improvements I’d Like To See For SQL Server: Recent Actual Plans
Spirited Away
This week’s posts are a series of short, and, admittedly lazy ones about improvements I’d like to see in Query Store.
I’m away from home for the Holiday Week, and I don’t have a lot of time to …
SQL Server Features I Still Need To Talk People Into Using
Booze Schmooze
As a counterpart to yesterday’s post, I have a list of Great Ideas™ that sometimes it’s hard to get people on board with, for some reason.
Don’t get me wrong, some people can’t jump on this stuff fast …