Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Error Logs Going Out of Control

Tuned Listener
Posts: 38
Country: USA

SQL Error Logs Going Out of Control

[ Edited ]

Hello Act! family,

 

I've got an odd issue. SQL is generating error logs continuously, about 3 every 6 seconds. For some reason SQL doesn't clean-up the error logs, they just keep adding up. This fills up my hard drive in about 12 hours even though the files are small.

 

Here's a screen shot of the log folder for reference:

errors.png

 

 

That's just from the last hour or two.

 

The initial file "SQLDump0001.log" - 

2013-12-18 09:35:19.88 Server      Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) 
	Jun 28 2012 08:36:30 
	Copyright (c) Microsoft Corporation
	Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2013-12-18 09:35:19.88 Server      (c) Microsoft Corporation.
2013-12-18 09:35:19.88 Server      All rights reserved.
2013-12-18 09:35:19.88 Server      Server process ID is 8296.
2013-12-18 09:35:19.88 Server      System Manufacturer: 'System manufacturer', System Model: 'System Product Name'.
2013-12-18 09:35:19.88 Server      Authentication mode is MIXED.
2013-12-18 09:35:19.88 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG'.
2013-12-18 09:35:19.88 Server      This instance of SQL Server last reported using a process ID of 18496 at 12/17/2013 5:08:48 PM (local) 12/18/2013 1:08:48 AM (UTC). This is an informational message only; no user action is required.
2013-12-18 09:35:19.88 Server      Registry startup parameters: 
	 -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\master.mdf
	 -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG
	 -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\mastlog.ldf
2013-12-18 09:35:19.88 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-12-18 09:35:19.88 Server      Detected 8 CPUs. This is an informational message; no user action is required.
2013-12-18 09:35:19.90 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2013-12-18 09:35:19.91 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-12-18 09:35:19.92 spid7s      Starting up database 'master'.
2013-12-18 09:35:19.93 spid7s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2013-12-18 09:35:19.94 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'ACT7'.
2013-12-18 09:35:19.95 spid7s      SQL Trace ID 1 was started by login "sa".
2013-12-18 09:35:19.95 spid7s      Starting up database 'mssqlsystemresource'.
2013-12-18 09:35:19.95 spid7s      The resource database build version is 10.50.4000. This is an informational message only. No user action is required.
2013-12-18 09:35:19.97 spid10s     Starting up database 'model'.
2013-12-18 09:35:19.97 spid7s      Server name is 'HAF\ACT7'. This is an informational message only. No user action is required.
2013-12-18 09:35:19.97 spid7s      Informational: No full-text supported languages found.
2013-12-18 09:35:19.97 spid7s      Starting up database 'msdb'.
2013-12-18 09:35:19.99 spid10s     Clearing tempdb database.
2013-12-18 09:35:20.06 spid10s     Starting up database 'tempdb'.
2013-12-18 09:35:20.07 Server      A self-generated certificate was successfully loaded for encryption.
2013-12-18 09:35:20.07 Server      Server is listening on [ 'any' <ipv6> 49255].
2013-12-18 09:35:20.07 Server      Server is listening on [ 'any' <ipv4> 49255].
2013-12-18 09:35:20.07 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\ACT7 ].
2013-12-18 09:35:20.07 Server      Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$ACT7\sql\query ].
2013-12-18 09:35:20.07 Server      Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
2013-12-18 09:35:20.08 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2013-12-18 09:35:20.08 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2013-12-18 09:35:20.08 spid13s     The Service Broker protocol transport is disabled or not configured.
2013-12-18 09:35:20.08 spid13s     The Database Mirroring protocol transport is disabled or not configured.
2013-12-18 09:35:20.08 spid13s     Service Broker manager has started.
2013-12-18 09:35:20.08 spid7s      Recovery is complete. This is an informational message only. No user action is required.
2013-12-18 09:35:20.09 spid7s      Launched startup procedure 'PRC_MASTER_AUTOSTARTUPS'.
2013-12-18 09:35:20.11 spid26s     ISENABLED = 1
2013-12-18 09:35:20.11 spid26s     NUM_DATABASES = 3
2013-12-18 09:35:20.11 spid26s     NUM_DAYS = 30
2013-12-18 09:35:20.13 spid26s     ************************* HayesCon (2013-12-18T01:05:55.777) *************************
2013-12-18 09:35:20.13 spid26s     Starting up database 'HayesCon'.
2013-12-18 09:35:20.38 spid26s     Recovery is writing a checkpoint in database 'HayesCon' (7). This is an informational message only. No user action is required.
2013-12-18 09:35:22.59 spid26s     Error: 515, Severity: 16, State: 2.
2013-12-18 09:35:22.59 spid26s     Cannot insert the value NULL into column 'GRABFIELD', table 'tempdb.dbo.#TEMPTB_____________________________________________________________________________________________________________000000000005'; column does not allow nulls. INSERT fails.
2013-12-18 09:35:40.91 spid51      Starting up database 'ACT2014Demo'.
2013-12-18 09:35:40.92 spid51      Recovery is writing a checkpoint in database 'ACT2014Demo' (5). This is an informational message only. No user action is required.
2013-12-18 09:35:42.20 spid53      Starting up database 'HayesCon'.
2013-12-18 09:35:45.53 spid16s     ex_raise2: Exception raised, major=52, minor=42, state=9, severity=22, attempting to create symptom dump
2013-12-18 09:35:45.53 spid16s     Using 'dbghelp.dll' version '4.0.5'
2013-12-18 09:35:45.53 spid16s     **Dump thread - spid = 0, EC = 0x0000000080926B20
2013-12-18 09:35:45.53 spid16s     * 
2013-12-18 09:35:45.53 spid16s     * User initiated stack dump.  This is not a server exception dump.
2013-12-18 09:35:45.53 spid16s     * 
2013-12-18 09:35:45.53 spid16s     ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\LOG\SQLDump0001.txt
2013-12-18 09:35:45.53 spid16s     * *******************************************************************************
2013-12-18 09:35:45.53 spid16s     *
2013-12-18 09:35:45.53 spid16s     * BEGIN STACK DUMP:
2013-12-18 09:35:45.53 spid16s     *   12/18/13 09:35:45 spid 16
2013-12-18 09:35:45.53 spid16s     *
2013-12-18 09:35:45.53 spid16s     * ex_raise2: Exception raised, major=52, minor=42, state=9, severity=22
2013-12-18 09:35:45.53 spid16s     *
2013-12-18 09:35:45.53 spid16s     *  
2013-12-18 09:35:45.53 spid16s     *
2013-12-18 09:35:45.53 spid16s     *  MODULE                          BASE      END       SIZE
2013-12-18 09:35:45.53 spid16s     * sqlservr                       0000000000FE0000  0000000004BF1FFF  03c12000
2013-12-18 09:35:45.53 spid16s     * ntdll                          0000000077A20000  0000000077BC8FFF  001a9000
2013-12-18 09:35:45.53 spid16s     * kernel32                       0000000077900000  0000000077A1EFFF  0011f000
2013-12-18 09:35:45.53 spid16s     * KERNELBASE                     000007FEFDBB0000  000007FEFDC1AFFF  0006b000
2013-12-18 09:35:45.53 spid16s     * ADVAPI32                       000007FEFDDF0000  000007FEFDECAFFF  000db000
2013-12-18 09:35:45.53 spid16s     * msvcrt                         000007FEFE2F0000  000007FEFE38EFFF  0009f000
2013-12-18 09:35:45.53 spid16s     * sechost                        000007FEFDFB0000  000007FEFDFCEFFF  0001f000
2013-12-18 09:35:45.53 spid16s     * RPCRT4                         000007FEFEB70000  000007FEFEC9CFFF  0012d000
2013-12-18 09:35:45.53 spid16s     * MSVCR80                        000000006F0D0000  000000006F198FFF  000c9000
2013-12-18 09:35:45.53 spid16s     * MSVCP80                        00000000521D0000  00000000522D8FFF  00109000
2013-12-18 09:35:45.53 spid16s     * sqlos                          0000000071F80000  0000000071F86FFF  00007000
2013-12-18 09:35:45.53 spid16s     * Secur32                        000007FEFD3C0000  000007FEFD3CAFFF  0000b000
2013-12-18 09:35:45.53 spid16s     * SSPICLI                        000007FEFD670000  000007FEFD694FFF  00025000
2013-12-18 09:35:45.53 spid16s     * pdh                            000007FEF8810000  000007FEF885DFFF  0004e000
2013-12-18 09:35:45.53 spid16s     * SHLWAPI                        000007FEFFC10000  000007FEFFC80FFF  00071000
2013-12-18 09:35:45.53 spid16s     * GDI32                          000007FEFE000000  000007FEFE066FFF  00067000
2013-12-18 09:35:45.53 spid16s     * USER32                         0000000077800000  00000000778F9FFF  000fa000
2013-12-18 09:35:45.53 spid16s     * LPK                            000007FEFE070000  000007FEFE07DFFF  0000e000
2013-12-18 09:35:45.53 spid16s     * USP10                          000007FEFE170000  000007FEFE238FFF  000c9000
2013-12-18 09:35:45.53 spid16s     * USERENV                        000007FEFCB20000  000007FEFCB3DFFF  0001e000
2013-12-18 09:35:45.53 spid16s     * profapi                        000007FEFD800000  000007FEFD80EFFF  0000f000
2013-12-18 09:35:45.53 spid16s     * WINMM                          000007FEFA140000  000007FEFA17AFFF  0003b000
2013-12-18 09:35:45.53 spid16s     * IPHLPAPI                       000007FEFAC90000  000007FEFACB6FFF  00027000
2013-12-18 09:35:45.53 spid16s     * NSI                            000007FEFE240000  000007FEFE247FFF  00008000
2013-12-18 09:35:45.53 spid16s     * WINNSI                         000007FEFAC80000  000007FEFAC8AFFF  0000b000
2013-12-18 09:35:45.53 spid16s     * opends60                       0000000071F50000  0000000071F57FFF  00008000
2013-12-18 09:35:45.53 spid16s     * NETAPI32                       000007FEFA950000  000007FEFA965FFF  00016000
2013-12-18 09:35:45.53 spid16s     * netutils                       000007FEFA940000  000007FEFA94BFFF  0000c000
2013-12-18 09:35:45.53 spid16s     * srvcli                         000007FEFD2B0000  000007FEFD2D2FFF  00023000
2013-12-18 09:35:45.53 spid16s     * wkscli                         000007FEFA920000  000007FEFA934FFF  00015000
2013-12-18 09:35:45.53 spid16s     * LOGONCLI                       000007FEFCFA0000  000007FEFCFCFFFF  00030000
2013-12-18 09:35:45.53 spid16s     * SAMCLI                         000007FEF97E0000  000007FEF97F3FFF  00014000
2013-12-18 09:35:45.53 spid16s     * BatchParser                    0000000071F20000  0000000071F4CFFF  0002d000
2013-12-18 09:35:45.53 spid16s     * IMM32                          000007FEFDFD0000  000007FEFDFFDFFF  0002e000
2013-12-18 09:35:45.53 spid16s     * MSCTF                          000007FEFE390000  000007FEFE498FFF  00109000
2013-12-18 09:35:45.53 spid16s     * nvinitx                        000007FEFD7D0000  000007FEFD7FEFFF  0002f000
2013-12-18 09:35:45.53 spid16s     * psapi                          0000000077BE0000  0000000077BE6FFF  00007000
2013-12-18 09:35:45.53 spid16s     * instapi10                      0000000071F10000  0000000071F1CFFF  0000d000
2013-12-18 09:35:45.53 spid16s     * cscapi                         000007FEF8890000  000007FEF889EFFF  0000f000
2013-12-18 09:35:45.53 spid16s     * sqlevn70                       00000000667A0000  00000000669A3FFF  00204000
2013-12-18 09:35:45.53 spid16s     * CRYPTSP                        000007FEFD290000  000007FEFD2A6FFF  00017000
2013-12-18 09:35:45.53 spid16s     * rsaenh                         000007FEFCD80000  000007FEFCDC6FFF  00047000
2013-12-18 09:35:45.53 spid16s     * CRYPTBASE                      000007FEFD700000  000007FEFD70EFFF  0000f000
2013-12-18 09:35:45.53 spid16s     * BROWCLI                        000007FEFC050000  000007FEFC061FFF  00012000
2013-12-18 09:35:45.53 spid16s     * AUTHZ                          000007FEFD250000  000007FEFD27EFFF  0002f000
2013-12-18 09:35:45.53 spid16s     * MSCOREE                        000007FEF7240000  000007FEF72AEFFF  0006f000
2013-12-18 09:35:45.54 spid16s     * mscoreei                       000007FEECCA0000  000007FEECD2FFFF  00090000
2013-12-18 09:35:45.54 spid16s     * ole32                          000007FEFE4A0000  000007FEFE6A2FFF  00203000
2013-12-18 09:35:45.54 spid16s     * credssp                        000007FEFCC70000  000007FEFCC79FFF  0000a000
2013-12-18 09:35:45.54 spid16s     * msv1_0                         000007FEFCFD0000  000007FEFD020FFF  00051000
2013-12-18 09:35:45.54 spid16s     * cryptdll                       000007FEFD3D0000  000007FEFD3E3FFF  00014000
2013-12-18 09:35:45.54 spid16s     * kerberos                       000007FEFD0A0000  000007FEFD153FFF  000b4000
2013-12-18 09:35:45.54 spid16s     * MSASN1                         000007FEFD8A0000  000007FEFD8AEFFF  0000f000
2013-12-18 09:35:45.54 spid16s     * schannel                       000007FEFCE10000  000007FEFCE67FFF  00058000
2013-12-18 09:35:45.54 spid16s     * CRYPT32                        000007FEFD960000  000007FEFDACBFFF  0016c000
2013-12-18 09:35:45.54 spid16s     * security                       0000000071EE0000  0000000071EE2FFF  00003000
2013-12-18 09:35:45.54 spid16s     * WS2_32                         000007FEFE080000  000007FEFE0CCFFF  0004d000
2013-12-18 09:35:45.54 spid16s     * SHELL32                        000007FEFECA0000  000007FEFFA27FFF  00d88000
2013-12-18 09:35:45.54 spid16s     * OLEAUT32                       000007FEFDED0000  000007FEFDFA6FFF  000d7000
2013-12-18 09:35:45.54 spid16s     * ncrypt                         000007FEFD200000  000007FEFD24CFFF  0004d000
2013-12-18 09:35:45.54 spid16s     * bcrypt                         000007FEFD1D0000  000007FEFD1F1FFF  00022000
2013-12-18 09:35:45.54 spid16s     * mswsock                        000007FEFD040000  000007FEFD094FFF  00055000
2013-12-18 09:35:45.54 spid16s     * wship6                         000007FEFD030000  000007FEFD036FFF  00007000
2013-12-18 09:35:45.54 spid16s     * wshtcpip                       000007FEFC9E0000  000007FEFC9E6FFF  00007000
2013-12-18 09:35:45.54 spid16s     * ntmarta                        000007FEFC670000  000007FEFC69CFFF  0002d000
2013-12-18 09:35:45.54 spid16s     * WLDAP32                        000007FEFDC30000  000007FEFDC81FFF  00052000
2013-12-18 09:35:45.54 spid16s     * ntdsapi                        000007FEF8740000  000007FEF8766FFF  00027000
2013-12-18 09:35:45.54 spid16s     * apphelp                        000007FEFD6A0000  000007FEFD6F6FFF  00057000
2013-12-18 09:35:45.54 spid16s     * bcryptprimitives               000007FEFCCE0000  000007FEFCD2BFFF  0004c000
2013-12-18 09:35:45.54 spid16s     * SAMLIB                         000007FEFA500000  000007FEFA51CFFF  0001d000
2013-12-18 09:35:45.54 spid16s     * dbghelp                        0000000065C20000  0000000065D7DFFF  0015e000
2013-12-18 09:35:45.54 spid16s     *
2013-12-18 09:35:45.54 spid16s     *     P1Home: 0044004C00510053:  
2013-12-18 09:35:45.54 spid16s     *     P2Home: 0000000000368164:  0022002500210023  0024002900230027  0026002D0025002B  002800310027002F  002A003500290033  002C0039002B0037  
2013-12-18 09:35:45.54 spid16s     *     P3Home: 0000000000369BD0:  0000000009917530  0000000009917530  0000000000000000  0000000000000000  0000000000000000  0000000000000000  
2013-12-18 09:35:45.54 spid16s     *     P4Home: 0000000000000000:  
2013-12-18 09:35:45.54 spid16s     *     P5Home: 005C004C00A0009E:  
2013-12-18 09:35:45.54 spid16s     *     P6Home: 0000000009966AA8:  0050005C003A0043  00720067006F0072  00460020006D0061  00730065006C0069  00630069004D005C  006F0073006F0072  
2013-12-18 09:35:45.54 spid16s     * ContextFlags: 000000000010004F:  
2013-12-18 09:35:45.54 spid16s     *      MxCsr: 0000000000001FA0:  
2013-12-18 09:35:45.54 spid16s     *      SegCs: 0000000000000033:  
2013-12-18 09:35:45.54 spid16s     *      SegDs: 000000000000002B:  
2013-12-18 09:35:45.54 spid16s     *      SegEs: 000000000000002B:  
2013-12-18 09:35:45.54 spid16s     *      SegFs: 0000000000000053:  
2013-12-18 09:35:45.54 spid16s     *      SegGs: 000000000000002B:  
2013-12-18 09:35:45.54 spid16s     *      SegSs: 000000000000002B:  
2013-12-18 09:35:45.54 spid16s     *     EFlags: 0000000000000202:  
2013-12-18 09:35:45.54 spid16s     *        Rax: 000000002657B9E0:  
2013-12-18 09:35:45.54 spid16s     *        Rcx: 000000000D07B2A0:  0044004C00510053  0000000000368164  0000000000369BD0  0000000000000000  005C004C00A0009E  0000000009966AA8  
2013-12-18 09:35:45.54 spid16s     *        Rdx: 0000000000000000:  
2013-12-18 09:35:45.54 spid16s     *        Rbx: 0000000000000000:  
2013-12-18 09:35:45.54 spid16s     *        Rsp: 000000000D07B8B0:  0000000000000000  0000000080926B20  000000000D07BAE0  000007FFFFF7C000  00000000000042AC  0000000000000000  
2013-12-18 09:35:45.54 spid16s     *        Rbp: 000000000340A25B:  0030250C8B486590  D54254058B480000  0000C0018C8B4800  00009024848B4800  000003D081894800  000030250C8B4865  
2013-12-18 09:35:45.54 spid16s     *        Rsi: 0000000080926B20:  0000000080926B20  0000000080926A20  0000000000000000  0000000000000004  0000000080926B40  0000000080926B40  
2013-12-18 09:35:45.54 spid16s     *        Rdi: 000000000D07BAE0:  0000000009966AA0  000004B4E6858FD3  00000000FFFFFFFE  000000000D07BB88  000000000D07BB76  0000000000FE0000  
2013-12-18 09:35:45.54 spid16s     *         R8: 0000000000000000:  
2013-12-18 09:35:45.54 spid16s     *         R9: 0000000000000000:  
2013-12-18 09:35:45.54 spid16s     *        R10: 0000000000000000:  
2013-12-18 09:35:45.54 spid16s     *        R11: 000000000D07C0C0:  0044004C00510053  0000000000368164  0000000000369BD0  0000000000000000  005C004C00A0009E  0000000009966AA8  
2013-12-18 09:35:45.54 spid16s     *        R12: 0000000000000001:  
2013-12-18 09:35:45.54 spid16s     *        R13: 0000000080926A20:  0000000080926080  0000000080926240  0000000000000000  00000000809269D0  0000000080926A90  00000000804765C0  
2013-12-18 09:35:45.54 spid16s     *        R14: 000000000D07D060:  0072005F00780065  0065007300690061  00450020003A0032  0070006500630078  006E006F00690074  0069006100720020  
2013-12-18 09:35:45.54 spid16s     *        R15: 00000000FFFFFFFF:  
2013-12-18 09:35:45.54 spid16s     *        Rip: 000007FEFDBB940D:  C3000000C8C48148  9090909090909090  8348C48B48909090  FFFFFEC0F74178EC  480001631C850FFF  4810708948085889  
2013-12-18 09:35:45.54 spid16s     * *******************************************************************************
2013-12-18 09:35:45.54 spid16s     * -------------------------------------------------------------------------------
2013-12-18 09:35:45.54 spid16s     * Short Stack Dump
2013-12-18 09:35:45.54 spid16s     000007FEFDBB940D Module(KERNELBASE+000000000000940D)
2013-12-18 09:35:45.54 spid16s     00000000030B974D Module(sqlservr+00000000020D974D)
2013-12-18 09:35:45.54 spid16s     00000000030BDC86 Module(sqlservr+00000000020DDC86)
2013-12-18 09:35:45.54 spid16s     00000000030BD7E9 Module(sqlservr+00000000020DD7E9)
2013-12-18 09:35:45.54 spid16s     00000000018C7FA2 Module(sqlservr+00000000008E7FA2)
2013-12-18 09:35:45.54 spid16s     000000000131F1C6 Module(sqlservr+000000000033F1C6)
2013-12-18 09:35:45.55 spid16s     000000000340A25B Module(sqlservr+000000000242A25B)
2013-12-18 09:35:45.55 spid16s     00000000017A49A3 Module(sqlservr+00000000007C49A3)
2013-12-18 09:35:45.55 spid16s     00000000014BC1CB Module(sqlservr+00000000004DC1CB)
2013-12-18 09:35:45.55 spid16s     00000000014BC82F Module(sqlservr+00000000004DC82F)
2013-12-18 09:35:45.55 spid16s     00000000014BC77C Module(sqlservr+00000000004DC77C)
2013-12-18 09:35:45.55 spid16s     000000000103EE29 Module(sqlservr+000000000005EE29)
2013-12-18 09:35:45.55 spid16s     000000000103E7E1 Module(sqlservr+000000000005E7E1)
2013-12-18 09:35:45.55 spid16s     00000000010132EC Module(sqlservr+00000000000332EC)
2013-12-18 09:35:45.55 spid16s     0000000001012FA3 Module(sqlservr+0000000000032FA3)
2013-12-18 09:35:45.55 spid16s     0000000001011F93 Module(sqlservr+0000000000031F93)
2013-12-18 09:35:45.55 spid16s     0000000000FFE313 Module(sqlservr+000000000001E313)
2013-12-18 09:35:45.55 spid16s     0000000000FFE174 Module(sqlservr+000000000001E174)
2013-12-18 09:35:45.55 spid16s     0000000000FF7B45 Module(sqlservr+0000000000017B45)
2013-12-18 09:35:45.55 spid16s     0000000000FFDFB5 Module(sqlservr+000000000001DFB5)
2013-12-18 09:35:45.55 spid16s     0000000000FEAB94 Module(sqlservr+000000000000AB94)
2013-12-18 09:35:45.55 spid16s     0000000000FEB05E Module(sqlservr+000000000000B05E)
2013-12-18 09:35:45.55 spid16s     0000000000FEAD57 Module(sqlservr+000000000000AD57)
2013-12-18 09:35:45.55 spid16s     00000000014C51DE Module(sqlservr+00000000004E51DE)
2013-12-18 09:35:45.55 spid16s     00000000014C5395 Module(sqlservr+00000000004E5395)
2013-12-18 09:35:45.56 spid16s     00000000014C8925 Module(sqlservr+00000000004E8925)
2013-12-18 09:35:45.56 spid16s     00000000014C59D6 Module(sqlservr+00000000004E59D6)
2013-12-18 09:35:45.56 spid16s     000000006F0D37D7 Module(MSVCR80+00000000000037D7)
2013-12-18 09:35:45.56 spid16s     000000006F0D3894 Module(MSVCR80+0000000000003894)
2013-12-18 09:35:45.57 spid16s     000000007791652D Module(kernel32+000000000001652D)
2013-12-18 09:35:45.57 spid16s     0000000077A4C541 Module(ntdll+000000000002C541)
2013-12-18 09:35:45.59 spid16s     * -------------------------------------------------------------------------------
2013-12-18 09:35:45.60 spid16s     Stack Signature for the dump is 0x000000004AC40693

 

 

 The second log file (SQLDump0001.txt) is way too large to paste but it starts:

Computer type is Intel(R) Core(TM) i7-2600K CPU @ 3.40GHz.                                                       
Bios Version is ALASKA - 1072009                                                                                 
BIOS Date: 02/05/10 19:13:52 Ver: 08.00.10                                                                       
8 X64 level 8664, 3 Mhz processor (s).                                                                           
Windows NT 6.1 Build 7601 CSD Service Pack 1.                                                                    
                                     
Memory                               
MemoryLoad = 26%                     
Total Physical = 16288 MB            
Available Physical = 12041 MB        
Total Page File = 32574 MB           
Available Page File = 27132 MB       
Total Virtual = 8388607 MB           
Available Virtual = 8371984 MB       
**Dump thread - spid = 0, EC = 0x0000000080926B20                                                                
*                                                                                                                
* User initiated stack dump.  This is not a server exception dump.                                               
*                                                                                                                
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\LOG\SQLDump0001.txt      
* *******************************************************************************         

 

This issue first began with Act 2014. When I contacted support they didn't really have any suggestions. So I formatted the computer, reinstalled windows, reinstalled just Act and SQL and the issue persisted.

 

This has been going on now for 3 months or so and I'd love to be releived of it. 

 

Anyone have any recommendations or suggestions? If posting more of the log file helps, let me know.

 

Thank you in advance,

 

Marshall Hayes
ACT! Certified Consultant
Hayes Consulting LLC
www.HayesConsultingOnline.com
Moderator
Posts: 704
Country: USA

Re: SQL Error Logs Going Out of Control

Mr. Hayes,

 

  Here's what I would like to do, if you're up for it.  

 

1. Disable the ACT7 instance of sql.

2. Install the Default instance of SQL Server Express

3. Check to see if these mini-dumps are still happening.

 

 

We're checking to see if there is a hardware issue, like bad ram or the like, that is causing the mini-dumps.  If that instance works fine, then I would want to contact you directly to try and come up with a solution.

Billy Clark
Swiftpage
Act! Knowledgebase: http://kb.act.com