Common trace flags used
in SQL Server
Deadlock Information:
1204, 1205, 1222
Network Database files:
1807
Log Record for
Connections: 4013
Skip STARTUP Stored
Procedures: 4022
Disable Locking Hints:
8755
Forces uniform extent
allocations instead of mixed page allocations 1118
(SQL 2005 and 2008) To
reduces TEMPDB contention.
To disable Lock
escalation 1211
To disable lock
escalation only when no memory pressure 1224
No comments:
Post a Comment