ktaranov / sqlserver-kit

Useful links, scripts, tools and best practice for Microsoft SQL Server Database
http://sqlserver-kit.org
MIT License
2.14k stars 669 forks source link

Trace flag 8099 should be 8101 ? #211

Closed CrazySwimmer closed 1 year ago

CrazySwimmer commented 1 year ago

According to the KB article linked in the TF description, it is TF 8101 that should be used to enable the fix.

TF Description: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md#8099

KB Article: https://support.microsoft.com/en-us/topic/kb4538688-fix-severe-spinlock-contention-occurs-in-sql-server-2019-43faea65-fdcb-6835-f7fe-93abdb235837

ktaranov commented 1 year ago

Great thanks! Fixed via 5b779da