March 21, 2018 at 5:39 am
Hi,
So I'm having a bit of health check on my servers and one thing I got thinking about was trace flags, now I know each is different and should only really be turned on if needed.
So I wondered are there any that you may use regularly and if so why? I'm just being curious of course.
Thanks,
Nic
March 21, 2018 at 6:51 am
On anything < 2016, I use TF 1118 (always). Rather than me posting "why" I use it, please read about it.
https://www.sqlskills.com/blogs/paul/misconceptions-around-tf-1118/
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
I also use the "G" parameter". The default is 256. I set mine to 384 with the understanding that there are some severe caveats that you need to be aware of and that the setting should probably only be changed if you have gobs of memory on the box. Rather than me posting "why" I use it, please read about it.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-service-startup-options
Since I also do Transaction Log backups like a madman, I also use TF 3226 to suppress "Backup Successful" messages in the SQL Logs.
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
--Jeff Moden
Change is inevitable... Change for the better is not.
March 22, 2018 at 12:43 am
Hi,
we use trace flag "3226".
We take log backups every 5 minutes, and we won't spam the errorlog with the successfully backup information.
Kind regards,
Andreas
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply