| Can you define some of the common trace flags used with SQl Server?
Trace flag sets the specific characteristic of the server in SQl Server. And this works as an "IF" condition for the Sql Server. Belw are the most common trace flags used with SQl Server are given below:-
(1)Disable Locking Hints: 8755
(2)Network Database files: 1807
(3)Deadlock Information : 1204, 1205, 1222
(4)Log Record for Connections: 4013
(5)Skip Startup Stored Procedures: 4022
(6)Do Force uniform extent allocations instead of mixed page allocations 1118 (Sql 2005,2008) | | |