I think this article is the nearest you will come to determining what goes on under the hoods:
Where Does SQL Server Store the Source for Stored Procedures? (improve.dk)
In his article Mark S. Rasmussen digs into finding out where several (SQL Server) internal views retrieve base definitions fr...
> I work as a Contributor Success PM in the Skilling organization at Microsoft, and I am reaching out to you because you have been nominated by **** from Database Doc team for your contributions to content on the Microsoft Learn platform.
> We’d like to highlight you and spotlight your work in a series called “Contributor Stories” with the hope that it inspires others to follow your path and share their valuable expertise by contributing to the Microsoft Learn platform too. This article will be published on the Microsoft Learn - Microsoft Community Hub. I
So today I took a look at the sys.fn_hadr_backup_is_preferred_replica function and I'm not surprised it's at the top of the Scalar function CPU usage list
The problem I'm experiencing is that the function takes a long time to run (about 3 seconds per database)
It's possible that this is among a growing list of dynamic management objects that don't support predicate push-down, so you will probably notice higher delays as the number of AGs and/o...
That function is gross. Looks like someone doesn't know how to write joins. Or EXISTS.
You break all the bones by putting them in a bag and beating them senseless with the traditional Irish hurley, then you boil them all day with barley and a bit of cabbage - yummy!
@ErikDarling Might depend on what's in the November 17 finance package, how the winter period goes, and a few other things. There'll be high resistance to another change of PM, so something pretty dramatic would need to happen. That wouldn't be entirely a new thing, of course.
@ErikDarling Why do you think they'll win? They've been in power for 12 years, British get bored after about that amount of time. Same happened with Labour before that.
I think this article is the nearest you will come to determining what goes on under the hoods:
Where Does SQL Server Store the Source for Stored Procedures? (improve.dk)
In his article Mark S. Rasmussen digs into finding out where several (SQL Server) internal views retrieve base definitions fr...
The problem I'm experiencing is that the function takes a long time to run (about 3 seconds per database)
It's possible that this is among a growing list of dynamic management objects that don't support predicate push-down, so you will probably notice higher delays as the number of AGs and/o...
