Add trace flags 8670 and 1252
jobbish-sql opened this issue · 1 comments
jobbish-sql commented
Trace flag 8670 is mentioned here: https://www.sql.kiwi/2012/05/query-optimizer-deep-dive-part-4.html
Trace flag 1252 is totally unrelated and something that I found while fooling around. It prints some kind of lock related information when 3604 is also enabled. Don't know anything else. Example:
SELECT * FROM master..spt_values
OPTION (QUERYTRACEON 1252, QUERYTRACEON 3604);