Wild, Wild Life
Note: this was fixed in CU11.
Thanks for reading!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
https://www.sqlskills.com/blogs/paul/capturing-spinlock-statistics-for-a-period-of-time/
Hey Erik, does this still happen since CU14 TF8101?
There’s a note immediately under the video that it was fixed in CU11. I have no idea how that trace flag interacts.