debugsqlMinor
Weird SQL error
Viewed 0 times
sqlweirderror
Problem
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 ....................|0Solution
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.
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.
Context
StackExchange Database Administrators Q#44525, answer score: 4
Revisions (0)
No revisions yet.