• Did you ever find a resolution to this? Since 3:23pm today we're suddenly getting log dumps every 1 minute and it's incredibly confusing perusing through these dump files.

    The gist of it looks like this...and appear to have something to do with our transactional replication i.e. (s p _ M S u p d...)

    Also, I keep getting these alerts

    DESCRIPTION:Replication-Replication Distribution Subsystem: agent NAS2-MSSQL1-COREISSUE-CI_PUB_TABLES-NAS2-DBR-12 failed. Unspecified error

    Current time is 15:20:30 09/30/11.

    =====================================================================

    BugCheck Dump

    =====================================================================

    This file is generated by Microsoft SQL Server

    version 10.0.4064.0

    upon detection of fatal unexpected error. Please return this file,

    the query or program that produced the bugcheck, the database and

    the error log, and any other pertinent information with a Service Request.

    Computer type is Intel(R) Xeon(R) CPU E5620 @ 2.40GHz.

    8 X64 level 8664, 2394 Mhz processor (s).

    Windows NT 5.2 Build 3790 CSD Service Pack 2.

    Memory

    MemoryLoad = 86%

    Total Physical = 16370 MB

    Available Physical = 2215 MB

    Total Page File = 32264 MB

    Available Page File = 17979 MB

    Total Virtual = 8388607 MB

    Available Virtual = 8364396 MB

    **Dump thread - spid = 0, EC = 0x00000000AC5820F0

    *

    * User initiated stack dump. This is not a server exception dump.

    *

    ***Stack Dump being sent to D:\SQL\LOG\SQLDump0004.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    * 09/30/11 15:20:30 spid 168

    *

    * ex_raise2: Exception raised, major=52, minor=42, state=9, severity=22

    *

    * Input Buffer 255 bytes -

    * ¨ 16 00 00 00 12 00 00 00 02 00 0b 19 00 00 a8 00 00 00

    * $ [ d b o ] . 01 00 00 00 24 00 5b 00 64 00 62 00 6f 00 5d 00 2e 00

    * [ s p _ M S u p d 5b 00 73 00 70 00 5f 00 4d 00 53 00 75 00 70 00 64 00

    * _ d b o A l l A u 5f 00 64 00 62 00 6f 00 41 00 6c 00 6c 00 41 00 75 00

    * t h s A c c o u n 74 00 68 00 73 00 41 00 63 00 63 00 6f 00 75 00 6e 00

    * t s ] 74 00 73 00 5d 00 00 00 00 02 1f 00 02 1f 00 02 1f 00

    * o n? ètü 02 1f 00 00 6f 08 08 6e 9f 00 00 e8 74 fc 00 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * & ß_] 00 02 1f 00 02 1f 00 02 1f 00 00 26 04 04 df 5f 5d 00

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f 00 02 1f

    * & ¥ 00 00 26 04 04 01 00 00 00 00 00 a5 09 00 09 00 10 00

    * ÿ$ [ d b o 00 00 00 00 00 02 00 ff 24 00 5b 00 64 00 62 00 6f 00

    * ] . [ s p _ M S u 5d 00 2e 00 5b 00 73 00 70 00 5f 00 4d 00 53 00 75 00

    * p d _ d b o A l l 70 00 64 00 5f 00 64 00 62 00 6f 00 41 00 6c 00 6c 00

    * A u t h s A c c o 41 00 75 00 74 00 68 00 73 00 41 00 63 00 63 00 6f 00

    * u n t s ] 75 00 6e 00 74 00 73 00 5d 00 00 00 00 02 1f 00 02 1f

    We have our End of Day and Month End processing occuring tonight at midnight (which generally runs for several hours into the morning) and then Corporate Reporting will "attempt" to start sending out 40,000+ reports from the data replicated into these tables...

    I'm a tad freaked. Did you find a solution?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience