sqlserver-kit icon indicating copy to clipboard operation
sqlserver-kit copied to clipboard

Update SQL Server Trace Flag.md

Open danrcarollo opened this issue 1 year ago • 0 comments

I added clarifying message about using Trace Flag 3895. You should NEVER enable this manually as a Startup Trace flag! It puts the Configuration into an inconsistent state if you later try to disable it! If you add the trace flag, the only way to disable TempDB Memory Optimized MetaData is to first remove the trace flag from the startup parameters and then use either sp_configure or ALTER SERVER CONFIGURATION to set the feature OFF

danrcarollo avatar Jul 03 '24 21:07 danrcarollo