Category: Articles
-
Day 11–Trace Flag 1204– Capture Deadlock information focused on nodes
Have you ever wonder to capture Deadlock information? If so we have wonderful trace flags available in SQL server which will give you bunch of information about deadlock information. Today we are going to see one of the trace flag 1204 which will capture deadlock information focused on two nodes that is involved in deadlock.
-
Day 10–Trace Flag 4022–Bypass startup procedures in SQL Server
Do you have startup procedures? In some scenarios we might be having some startup procedures in our SQL Server system and we might face some issue during starting SQL server. So for troubleshooting purpose we might need to bypass the startup procedures so that SQL Server don’t need to grant worker thread for each procedure.
-
Day 9–Trace Flag 3608–Bypass recovery for all databases except Master db
This is one of the familiar trace flag for every DBA. If you are working with SQL Server 2000 then to move the system databases you will be using this trace flag frequently. What does this trace flag do? When you enable this trace flag in startup parameter it will bypass recovery for all databases…
-
Day 8 – Trace Flags 2544 & 2546 – Generate Full dump from SQL Server
Today we are going to see two trace flags which is going to help for troubleshooting purposes. These two trace flags will get you full SQL Server dump by using the undocumented DBCC command.
-
Day 7–Trace flag 2528 disable parallelism in maintenance DBCC
Happy Weekend folks. Today let me discuss about trace flag 2528 which will disable parallelism on maintenance DBCC. By using this trace flag it disables parallel checking of objects by DBCC CHECKDB, DBCC CHECKFILEGROUP, and DBCC CHECKTABLE commands. By default parallelism is enabled and it will look for max degree of parallelism to utilize parallel…