• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 523
  • Last Modified:

Out of control MSSQL 2005 DUMP files

MSSQL 2005 has decided to create massive quantities of dump files at about as fast as the harddrive can write.  The drive quickly fills up and crashes the server.  As a temporary measure I have tried to turn off the dump fil in the SQL configuration panel by turrning off error logging.  However, this did nothing.  How do I fix the condition that is casuing the dump?
BugCheck Dump                                                                                             
=====================================================================                                            
                                                                                                                 
This file is generated by Microsoft SQL Server                                                                   
version 9.00.1399.06                                                                                             
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 AT/AT COMPATIBLE.                                                                               
Bios Version is PTLTD  - 6040000                                                                                 
Ver 1.00PARTTBL                                                                                                  
Current time is 08:07:09 02/24/09.                                                                               
4 Intel x86 level 6, 1595 Mhz processor (s).                                                                     
Windows NT 5.2 Build 3790 CSD Service Pack 2.                                                                    
                                     
Memory                               
MemoryLoad = 49%                     
Total Physical = 2046 MB             
Available Physical = 1032 MB         
Total Page File = 5979 MB            
Available Page File = 5037 MB        
Total Virtual = 2047 MB              
Available Virtual = 328 MB           
***Stack Dump being sent to F:\SQL_LOG\SQLDump0936.txt                                                           
SqlDumpExceptionHandler: Process 66 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is 
terminating this process.                                                                                        
* *******************************************************************************                                
*                                                                                                                
* BEGIN STACK DUMP:                                                                                              
*   02/24/09 08:07:09 spid 66                                                                                    
*                                                                                                                
*                                                                                                                
*   Exception Address = 01105772 Module(sqlservr+00105772)                                                       
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION                                                      
*   Access Violation occurred reading address 00000000                                                           
* Input Buffer 104 bytes -                                                                                       
*    d b o . p r o c  12 00 64 00 62 00 6f 00 2e 00 70 00 72 00 6f 00 63 00                                      
*  _ M S S _ C r a w  5f 00 4d 00 53 00 53 00 5f 00 43 00 72 00 61 00 77 00                                      
*  l     &        &   6c 00 00 00 00 00 26 04 04 01 00 00 00 00 00 26 04 04                                      
*        &        &   07 00 00 00 00 00 26 04 04 02 00 00 00 00 00 26 04 04                                      
*  รท/    &        &   f7 2f 00 00 00 00 26 04 04 00 00 00 00 00 00 26 04 04                                      
*        &    &       00 00 00 00 00 01 26 04 00 00 01 26 04 00                                                  
*                                                                                                                
*                                                                                                                
*  MODULE                          BASE      END       SIZE                                                      
* sqlservr                       01000000  02BA7FFF  01ba8000                                                    
* ntdll                          7C800000  7C8BFFFF  000c0000                                                    
* kernel32                       77E40000  77F41FFF  00102000                                                    
* MSVCR80                        78130000  781CAFFF  0009b000                                                    
* msvcrt                         77BA0000  77BF9FFF  0005a000                                                    
* MSVCP80                        7C420000  7C4A6FFF  00087000                                                    
* ADVAPI32                       77F50000  77FEAFFF  0009b000                                                    
* RPCRT4                         77C50000  77CEEFFF  0009f000                                                    
* Secur32                        76F50000  76F62FFF  00013000                                                    
* USER32                         77380000  77410FFF  00091000                                                    
* GDI32                          77C00000  77C47FFF  00048000                                                    
* CRYPT32                        761B0000  76242FFF  00093000                                                    
* MSASN1                         76190000  761A1FFF  00012000                                                    
* MSWSOCK                        71B20000  71B60FFF  00041000                                                    
* WS2_32                         71C00000  71C16FFF  00017000                                                    
* WS2HELP                        71BF0000  71BF7FFF  00008000                                                    
* USERENV                        76920000  769E1FFF  000c2000                                                    
* opends60                       333E0000  333E6FFF  00007000                                                    
* NETAPI32                       71C40000  71C96FFF  00057000                                                    
* SHELL32                        7C8D0000  7D0CEFFF  007ff000                                                    
* SHLWAPI                        77DA0000  77DF1FFF  00052000                                                    
* IMM32                          76290000  762ACFFF  0001d000                                                    
* comctl32                       77420000  77522FFF  00103000                                                    
* psapi                          76B70000  76B7AFFF  0000b000                                                    
* instapi                        48060000  48069FFF  0000a000                                                    
* sqlevn70                       4F610000  4F7A0FFF  00191000                                                    
* SQLOS                          344D0000  344D4FFF  00005000                                                    
* rsaenh                         68000000  68034FFF  00035000                                                    
* AUTHZ                          76C40000  76C53FFF  00014000                                                    
* MSCOREE                        34190000  341D4FFF  00045000                                                    
* ole32                          77670000  777A8FFF  00139000                                                    
* msv1_0                         76C90000  76CB6FFF  00027000                                                    
* iphlpapi                       76CF0000  76D09FFF  0001a000                                                    
* kerberos                       61BD0000  61C27FFF  00058000                                                    
* cryptdll                       766E0000  766EBFFF  0000c000                                                    
* schannel                       76750000  76776FFF  00027000                                                    
* COMRES                         77010000  770D5FFF  000c6000                                                    
* XOLEHLP                        61C90000  61C95FFF  00006000                                                    
* MSDTCPRX                       61CA0000  61D18FFF  00079000                                                    
* OLEAUT32                       77D00000  77D8AFFF  0008b000                                                    
* msvcp60                        61D20000  61D84FFF  00065000                                                    
* MTXCLU                         61D90000  61DA8FFF  00019000                                                    
* VERSION                        77B90000  77B97FFF  00008000                                                    
* WSOCK32                        71BB0000  71BB8FFF  00009000                                                    
* CLUSAPI                        61DB0000  61DC1FFF  00012000                                                    
* RESUTILS                       61DD0000  61DE2FFF  00013000                                                    
* DNSAPI                         76ED0000  76EF9FFF  0002a000                                                    
* winrnr                         76F70000  76F76FFF  00007000                                                    
* WLDAP32                        76F10000  76F3DFFF  0002e000                                                    
* rasadhlp                       76F80000  76F84FFF  00005000                                                    
* security                       62220000  62223FFF  00004000                                                    
* msfte                          628C0000  62B17FFF  00258000                                                    
* dbghelp                        62B30000  62C47FFF  00118000                                                    
* WINTRUST                       76BB0000  76BDAFFF  0002b000                                                    
* imagehlp                       76C10000  76C37FFF  00028000                                                    
* dssenh                         68100000  68126FFF  00027000                                                    
* hnetcfg                        62FE0000  63039FFF  0005a000                                                    
* wshtcpip                       71AE0000  71AE7FFF  00008000                                                    
* NTMARTA                        77E00000  77E20FFF  00021000                                                    
* SAMLIB                         7E020000  7E02EFFF  0000f000                                                    
* ntdsapi                        766F0000  76703FFF  00014000                                                    
* xpsp2res                       63200000  634C4FFF  002c5000                                                    
* CLBCatQ                        777B0000  77832FFF  00083000                                                    
* sqlncli                        634D0000  636EDFFF  0021e000                                                    
* COMCTL32                       77530000  775C6FFF  00097000                                                    
* comdlg32                       762B0000  762F8FFF  00049000                                                    
* SQLNCLIR                       007C0000  007F2FFF  00033000                                                    
* msftepxy                       637F0000  63804FFF  00015000                                                    
* dbghelp                        63CC0000  63DD2FFF  00113000                                                    
*                                                                                                                
*        Edi: 15523838:  15230028  15523840  0110300C  027AD960  01103308  0000001E                              
*        Esi: 15523838:  15230028  15523840  0110300C  027AD960  01103308  0000001E                              
*        Eax: 6278EF80:  6278EFB4  02450AD1  FFFFFFFF  6278EFC0  013804D2  15523838                              
*        Ebx: 00000000:                                                                                          
*        Ecx: 00000000:                                                                                          
*        Edx: 00000040:                                                                                          
*        Eip: 01105772:  108B038B  CB8B016A  4D8BD2FF  F88B560C  FFDE39E8  89C033FF                              
*        Ebp: 6278EF8C:  6278EFC0  013804D2  15523838  15706028  00000000  6278DC66                              
*      SegCs: 0000001B:                                                                                          
*     EFlags: 00010202:  0075006C  00740073  00720065  006C002E  0067006F  00430000                              
*        Esp: 6278EF70:  6278DC2A  15523838  15706028  155237E0  6278EFB4  02450AD1                              
*      SegSs: 00000023:                                                                                          
* *******************************************************************************                                
* -------------------------------------------------------------------------------                                
* Short Stack Dump                                                                                               
01105772 Module(sqlservr+00105772)                                                                               
013804D2 Module(sqlservr+003804D2)                                                                               
01439AD1 Module(sqlservr+00439AD1)                                                                               
0143995C Module(sqlservr+0043995C)                                                                               
01380F7A Module(sqlservr+00380F7A)                                                                               
01380EAF Module(sqlservr+00380EAF)                                                                               
01380EAF Module(sqlservr+00380EAF)                                                                               
01380EAF Module(sqlservr+00380EAF)                                                                               
01380EAF Module(sqlservr+00380EAF)                                                                               
01380EAF Module(sqlservr+00380EAF)                                                                               
01380EAF Module(sqlservr+00380EAF)                                                                               
013810A9 Module(sqlservr+003810A9)                                                                               
0125362A Module(sqlservr+0025362A)                                                                               
01253CCA Module(sqlservr+00253CCA)                                                                               
013CDC85 Module(sqlservr+003CDC85)                                                                               
013CDD56 Module(sqlservr+003CDD56)                                                                               
0125B712 Module(sqlservr+0025B712)                                                                               
0125B0B5 Module(sqlservr+0025B0B5)                                                                               
01320C83 Module(sqlservr+00320C83)                                                                               
0125B99F Module(sqlservr+0025B99F)                                                                               
0102C51D Module(sqlservr+0002C51D)                                                                               
010438E5 Module(sqlservr+000438E5)                                                                               
01041C35 Module(sqlservr+00041C35)                                                                               
0100889F Module(sqlservr+0000889F)                                                                               
010089C5 Module(sqlservr+000089C5)                                                                               
010086E7 Module(sqlservr+000086E7)                                                                               
010D764A Module(sqlservr+000D764A)                                                                               
010D7B71 Module(sqlservr+000D7B71)                                                                               
010D746E Module(sqlservr+000D746E)                                                                               
010D83F0 Module(sqlservr+000D83F0)                                                                               
781329BB Module(MSVCR80+000029BB)                                                                                
78132A47 Module(MSVCR80+00002A47)    
 
PSS @0x14F5F2F0

Open in new window

0
TedgCl
Asked:
TedgCl
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>version 9.00.1399.06

means you have the retail version of sql 2005.
please update to at least sp2, if not sp3.

that should fix those issues, normally.
0
 
TedgClAuthor Commented:
This was the solution.  Thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now