Trace Flag in SQL Server 2016 - Is this still helpful/required?

[greavette]

Hello Forum,

We run SQL Server 2016 on a Windows 2019 VM in Proxmox 6.4-6.

I found this forum post from the proxmox tweaks page - https://forum.proxmox.com/threads/windows-guest-high-context-switch-rate-when-idle.5770/

This post mentions "Setting the trace flag -T8038 will drastically reduce the number of context switches when running SQL 2005 or 2008". Can anyone confirm that this setting would be useful within later versions of SQL in reducing cpu usage on the host?

Thank you.

 

[RCK]

I'm wondering the same thing
Did you try with and without T8038 flag and check the number of context switches ?