Databases Reference
In-Depth Information
How to do it...
Follow the ensuing steps to configure Trace Flag 1204 at instance level, to log the deadlock
information into SQL Server error log:
1. Start SQL Server Configuration Manager from Configuration Tools, in the Microsoft
SQL Server 2012 Program group in the Start menu.
2.
Select the SQL Server Services node in the left-hand side pane, right-click the
instance of SQL Server Service in the right-hand side pane, and select Properties
from the context menu, as shown in following screenshot:
3.
In the SQL Server (MSSQLSERVER) Properties window, select the Startup
Parameters tab. Type
-t1204
in the textbox provided under Specify a startup
parameter:. Click on the Add button to add this new parameter to the list of Existing
parameters. The following screenshot shows the Startup Parameters tab with the
added trace flag:
Search WWH ::
Custom Search