SQL Server :- Trace Flags and Upgrades

Background

In the last couple of weeks one of our customers complained about a downed database. Reviewed the SQL Server Error Log and noticed a few things.

Error Log

Error Log – Trace Flag – 1117

Image

traceFlag.1117.20190805_1000AM.PNG

Textual


Registry startup parameters: -d M:\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf -e M:\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG -l M:\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf -T 1117 -T 1118 -T 2371 -T 2562 -T 2549

Trace flag 1117 is discontinued. Use the options provided with ALTER DATABASE.

DBCC TRACEON 1117, server process ID (SPID) 84. This is an informational message only; no user action is required.

Error Log – Trace Flag – 1118

Image

traceFlag.1118.20190805_1004AM.PNG

Textual


Registry startup parameters:     -d M:\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf    -e M:\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG    -l M:\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf    -T 1117    -T 1118    -T 2371    -T 2562    -T 2549

Trace flag 1118 is discontinued. Use the options provided with ALTER DATABASE.

DBCC TRACEON 1118, server process ID (SPID) 84. This is an informational message only; no user action is required.

Resolution

To resolve the error, be sure to check version number of the SQL Server Engine.

Only enable trace flags if it is actually needed for the Version.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s