search

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: 8048 #195

Closed erikdarlingdata closed 3 years ago

erikdarlingdata commented 3 years ago

There is incorrect information about TF 8048 in your document: "Note: Beginning with SQL Server 2014 SP2 and SQL Server 2016 this behavior is controlled by the engine and trace flag 8048 has no effect."

The trace flag does still has effect. The engine behavior will partition memory if CMEMTHREAD contention is detected. Turning on TF 8048 forces the partitioning without having to hit the internal thresholds.

ktaranov commented 3 years ago

@erikdarlingdata great thanks, fixed via https://github.com/ktaranov/sqlserver-kit/commit/51ccb46464fbc551f87fa0ae0e84f0888d41c956