HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

Weird SQL error

Submitted by: @import:stackexchange-dba··
0
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  ....................|0

Solution

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.

Context

StackExchange Database Administrators Q#44525, answer score: 4

Revisions (0)

No revisions yet.