Home » trace flags
Testing Trace Flag 2861 and Zero-Cost Plans on SQL Server 2019 and 2025
· by Hannah Vernon · in performance
Does SolarWinds DPA’s trace flag 2861 keep zero-cost plans in the plan cache? A test on SQL Server 2019 and 2025 found no measurable effect.
SQL Server Trace Flags
· by Hannah Vernon · in configuration
Maintaining an up-to-date list of SQL Server Trace Flags is time consuming, and difficult since the majority are undocumented. Aaron over at SQLCrossJoin.wordpress.com maintains an incredibly detailed and comprehensive list of trace flags at https://sqlcrossjoin.wordpress.com/category/trace-flags/….