Memethread
Thanks for watching!
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 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.
Hey Erik-
What version and build are you running with here? I didn’t hear it at the beginning of the video and in looking at SSMS I believe it’s SQL Server 2017 RTM, but just wanted to confirm.
Thanks,
Erin
Yep, it’s 2017, but CU15. SSMS says RTM at the bottom no matter which CU you’re on ?
Microsoft SQL Server 2017 (RTM-CU15) (KB4498951) – 14.0.3162.1 (X64) May 15 2019 19:14:30
Thanks!
Ooh, could be! I checked for weird error log messages and stack dumps, but I didn’t see anything.
Thanks!
Ok, thanks for clarifying, I suspect you’re running into this issue:
https://support.microsoft.com/en-us/help/4501205/fix-non-yielding-scheduler-occurs-when-you-clean-up-in-memory-runtime
Which isn’t fixed in a 2017 CU yet (hopefully soon).