How to enable Trace flag without restarting SQL Server immediately
Many times when DBA has to enable a Trace flag permanently we have to go to Customer and ask for a downtime or wait for monthly or quarterly agreed downtime. However we can avoid this wait time in two simple steps:
1. Enable Trace flag at global level with DBCC command as below.
DBCC TRACEON( 3226, -1) , this trace flag helps not to log successful backup completions.
2. Add trace flag as startup parameter with help of -T
When we restart Windows box or SQL Services during OS or SQL patching, trace flag enabled using -1 will get disabled at shutdown of SQL Services and Trace flag added part of startup parameter will take effect from SQL Server startup.
This is one of the short article, hope this finds helpful to someone. Stay tunned for more knowledge sharing.
No comments:
Post a Comment