Friday afternoon at 5:30 and what am I doing? Figuring out how to fix my two-at-a-time powershell limit. Just update the system table, eh? Cool, cool. :D
mbourgon
- 45 Followers
- 54 Following
- 442 Posts
Invalids at Plus Fest, @AndysDenton, Texas. A fantastic #Mathrock festival! Day 2 is tomorrow (Sunday)!
Azure Automatic tuning FORCE_LAST_GOOD_PLAN right now after it caused an incident because it changed the plan and CPU spiked to 100%: #AzureSQL
I was listening to a story today talking about how social media makes you feel bad because people only ever post the most perfect photos of the things they’ve done. So, allow me to post an absolutely horrible photo of a cake I made. The lumps in the frosting are entirely accidental, no idea how they got there, no idea how to get rid of them. It’s unmelted chocolate chips.
Always fun when Microsoft's own tools throw errors checking your instance.
#AzureSQL
I'm guessing somewhere in that dynamic SQL.
That is the lowest key release notification for a major functionality I've seen in a while. This has been preventing us from fully using Azure Managed Instance, and they just drop it as a "oh by the way".
In other news WOOOOOOOOOOOHOOOOOOOOO MANAGED INSTANCE PRIVATE ENDPOINTS ARE HERE!
I wonder if the multiple tickets I've had, where they said they'll notify me when it's been "released", will actually notify me. What's the bet, 0, 1, or 10? :D
Does anybody know how long it takes on Azure SQL Database for the FORCE LAST GOOD PLAN to kick in? We had a very obvious regression this morning, and it ran in a bad state (causing issues with our system) for about 4 hours, CPU hitting 100% before (an hour later) it started forcing the last good plan. I thought this would happen sooner?
#Azure #AzureSQL #QueryStore #AutomaticPlanCorrection
#Azure #AzureSQL #QueryStore #AutomaticPlanCorrection