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 7412 is officially documented as having no effect in SQL Server 2019+, but not here #227

Closed ReeceGoding closed 1 month ago

ReeceGoding commented 8 months ago

The documentation for Trace Flag 7412 claims the following

Starting with SQL Server 2019 (15.x), this trace flag has no effect because lightweight profiling is enabled by default.

I see nothing in this document that reflects this. For example, it's not in the section for 7412 or the list of recommended Trace Flags (which includes 7412).

So who is wrong? This document or Microsoft's? I presume that someone with the relevant knowledge can test this and get a pull request in.

Karambir06 commented 1 month ago

Just used old version SQL server

ktaranov commented 1 month ago

@ReeceGoding thanks! update info via https://github.com/ktaranov/sqlserver-kit/commit/1ea0afce75c40109d35b5e8b9f84dad897d0cc45