Database Engine Service Startup Options in SQL Server 2012
- Add any new parameters after the first 3 default parameters –d, -e, -l. IMPORTANT never change sorting of these parameters!
- Specify the ";" delimiter between each parameter! SSCM uses ";" as the delimiter between parameters.
- Do NOT use a space after the delimiter and the parameter identifier (which is the "-" character). Copy it back to startup paramaters - save - RESTART the service!
- Check the current SQL Server error log and verify that each parameter shows up in a new line and starts at the same indentation.
But now in SQL Server 2012 we have a "Startup Parameters" Tab!
- Add any new parameters in the Textfield (NEVER REMOVE the first 3 default pramaters!!!)
- After restarting check the current SQL Server error log and verify that each parameter shows up in a new line and starts at the same indentation.
Where to find out about trace flags
- In Books Online
- SQLServerPedia
- And a great article by Yusuf Anis at SQLServerCentral - enjoy it!
Checking the status of trace flags
You can check the status of your trace flags by using the following command:
DBCC TRACESTATUS
If you want to know something about Trace Flag 3226, please read Christoph Muthmann's (aka cmu) post:
Trace Flag 3226
tosc
Print article | This entry was posted by tosc on 2012-06-28 at 15:01:00 . Follow any responses to this post through RSS 2.0. |
Tag cloud
backup «best practices» books bug configuration ctp «cumulative update» demo denali dmv ebook humor index indexoptimize integrity kbfix loginproperty maintenance «ms sql server 2008» pass performance php profiler reviews «ross mistry» «service pack» «service pack 2» «service packs» sharepoint «sql 2012» «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack «stacia misner» sysadmin t-sql technet «technical note» tempdb tools «trace flag» upgrade whitepapers