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

G

greavette

Renowned Member
Apr 13, 2012
163
10
83
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.
 
  • Like
Reactions: macpip
I'm wondering the same thing :)
Did you try with and without T8038 flag and check the number of context switches ?
 
You must log in or register to reply here.
Top Bottom