Question :
am seeing the error logs below on my SQL server, I’m not sure if they are related to trace flag 3604. I also see something to do with memory dump as well. Please advice.
15:15:53.81 spid594 m_pageId = (1:1172094) m_headerVersion = 1 m_type = 2|0
15:15:53.81 spid594 m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0|0
15:15:53.81 spid594 m_objId = 954538534 m_indexId = 6 m_prevPage = (1:1102845)|0
15:15:53.81 spid594 m_nextPage = (1:1172095) pminlen = 21 m_slotCnt = 212|0
15:15:53.81 spid594 m_freeCnt = 2584 m_freeData = 5880 m_reservedCnt = 0|0
15:15:53.81 spid594 m_lsn = (119582:10616:47) m_xactReserved = 0 m_xdesId = (0:753243376)|0
15:15:53.81 spid594 m_ghostRecCnt = 0 m_tornBits = -2147483127 |0
15:15:53.81 spid594 |0
Allocation Status|0
-----------------|0
15:15:53.81 spid594 GAM (1:1022464) = ALLOCATED |0
15:15:53.81 spid594 SGAM (1:1022465) = NOT ALLOCATED |0
15:15:53.81 spid594 PFS (1:1164672) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:1022470) = CHANGED|0
15:15:53.81 spid594 ML (1:1022471) = NOT MIN_LOGGED |0
15:15:53.81 spid594 |0
DATA:|0
-----|0
15:15:53.81 spid594 |0
Memory Dump @0x3CFF0000|0
-----------------------|0
15:15:53.81 spid594 3CFF0000: 01020000 00000600 fdd31000 01001500 7fe21100 ....................|0
15:15:53.81 spid594 3CFF0014: 0100d400 261ae538 180af816 7ee21100 01000000 ....&..8....~.......|0
15:15:53.81 spid594 3CFF0028: 1ed30100 78290000 2f000000 f094e52c 00000000 ....x)../......,....|0
15:15:53.81 spid594 3CFF003C: 09020080 00000000 00000000 00000000 00000000 ....................|0
15:15:53.81 spid594 3CFF0050: 00000000 00000000 00000000 00000000 1a2c0d00 .................,..|0
15:15:53.83 spid594 3CFF0064: 009c0300 00e30300 0097f79a 10000000 00040000 ....................|0
Answer :
Trace flag 3604 simply redirects DBCC command output to the client (instead of the error log).
It looks like someone has been running the DBCC PAGE command to take a closer look at individual database pages, but forgot that output gets redirected to the error log, and then ran in the 3604 trace flag to view the output.
@Eric213 already answered your question. To add more to it :
— find out what traceflags are enabled on the instance
dbcc tracestatus(-1)
— to Turn off the traceflag :
dbcc traceoff (traceNumber)
— To disable the trace flag globally, you have to use
dbcc traceoff (traceNumber, -1)