February 15, 2019 at 3:36 pm
Thanks for this impressively comprehensive list!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
September 11, 2019 at 6:41 am
One more TF from Microsoft support (SQL Server 2012):
833 - disables superlatch
Needs SQL Services restart.
September 11, 2019 at 2:07 pm
Hi, przemyslawkus. Thanks for this trace flag. Could you provide some extra information.
What is scope for this flag: session, global, query?
What is versions (except 2012) SQL Server it works?
September 11, 2019 at 2:13 pm
This article is awesome! Thanks for putting it together.
Alan, the migration to the "improved" SSC website has broken all of the links in your signature line.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 11, 2019 at 2:16 pm
One more TF from Microsoft support (SQL Server 2012):
833 - disables superlatch
Needs SQL Services restart.
My recommendation would be not to use those types of trace flags. Instead, fix the code that's causing a problem because queries on larger data (and it's forever getting larger) may be adversely affected. Trace Flags are generally not meant to be a panacea of performance (there are exceptions but they are rare).
--Jeff Moden
Change is inevitable... Change for the better is not.
September 17, 2019 at 12:59 pm
One more TF from Microsoft support (SQL Server 2012):
833 - disables superlatch
Needs SQL Services restart.
Added, great thanks for new undocumented flag (just 2 flags left for 600).
https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md#833
June 18, 2021 at 3:00 pm
Hello! I've only tested in SQL Server 2019 but trace flag 835 no longer seems to disable LPIM.
Viewing 9 posts - 31 through 39 (of 39 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy