Do you know which 1% they are, and what you’re going to do to mitigate their performance reductions? You can’t just test your slow queries on 2019: you’ve also gotta test your currently-fast queries to make sure they don’t slow down unacceptably. Just to pick a number, say 99% of your queries go faster, but 1% go slower. You’re good at load & performance testing – because 2019 adds a lot of cool performance features when you enable 2019 compatibility mode, but it also makes big changes in your existing execution plans.You’re comfortable learning via experimentation, not documentation – because as you get to these cutting edge features below, your experimentation & learning time goes up, because there are WAY less established industry best practices around the below stuff. You only want to apply patches every 60 days, or less – because after a couple dozen Cumulative Updates, this version is stable enough that most of the big bugs feel like they’ve been found. I love new versions, but most of us have to stick on a version as long as possible, and 2019 gives you a lot of runway.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |