SQL Server Performance Forum – Threads Archive
SQL Named Instance Stack Dump on Startup
Microsoft SQL Server 2000 – 8.00.194 (Intel X86)Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4) I have a SQL server for a document imaging application. SQL is installed along with a named instance that is necessary for the application. I was not involved in the installation or setup of this machine, but now the responsibility has fallen to me to maintain it. The named instance occasionally (once every other month) generates a stack dump upon startup. Generally all I have to do to "clean" this up is to stop and restart SQL and it’s services, or a reboot. Yesterday I found myself in this situation again, but the normal "fixes" did not resolve it. This morning I was searching the net for clues, and still attempting to shutdown and restart SQL, when SQL finally cooperated and started clean – the app works fine now. I have never found anything in the event viewer to give me a hint. The information in the logs has not provided me with any answers, though I am pretty inexperiened in that area. I have not been able to find any of the log contents in MSKB or elsewhere. I am confident enough to reinstall SQL, to see if any of this is fixed, but the application’s consultant is afraid that the app will break if I do that. I need to take the time to FIX this rather than band-aiding it when it breaks. I inherited this last summer, but the issue has been occurring for 2 years, and the server’s previous caretaker did not deal with it. The other hindrance is that our company will be closing this time next year, so the attitude here is to just keep things running, without any new investment. Any help with this is much appreciated! Thank-you!!! Part of the log is listed below:
—————
2005-03-22 08:37:42.80 server Microsoft SQL Server 2000 – 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4) 2005-03-22 08:37:42.80 server Copyright (C) 1988-2000 Microsoft Corporation.
2005-03-22 08:37:42.80 server All rights reserved.
2005-03-22 08:37:42.80 server Server Process ID is 696.
2005-03-22 08:37:42.80 server Logging SQL Server messages in file ‘C
![Stick Out Tongue :p :p](styles/default/xenforo/smilies/tongue.png)
2005-03-22 08:37:42.82 server SQL Server is starting at priority class ‘normal'(2 CPUs detected).
2005-03-22 08:37:42.92 server SQL Server configured for thread mode processing.
2005-03-22 08:37:42.92 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2005-03-22 08:37:43.08 spid2 Starting up database ‘master’.
2005-03-22 08:37:43.17 spid2 0 transactions rolled back in database ‘master’ (1).
2005-03-22 08:37:43.17 spid2 Recovery is checkpointing database ‘master’ (1)
2005-03-22 08:37:43.21 server Using ‘SSNETLIB.DLL’ version ‘8.0.194’.
2005-03-22 08:37:43.21 spid5 Starting up database ‘model’.
2005-03-22 08:37:43.22 spid2 Server name is ‘HGINT10LASERFICHE’.
2005-03-22 08:37:43.28 spid8 Starting up database ‘msdb’.
2005-03-22 08:37:43.30 spid9 Starting up database ‘Reports’.
2005-03-22 08:37:43.39 spid5 Clearing tempdb database.
2005-03-22 08:37:44.88 server SQL server listening on TCP, Shared Memory, Named Pipes.
2005-03-22 08:37:44.88 server SQL server listening on 157.154.121.239:3977, 127.0.0.1:3977.
2005-03-22 08:37:44.88 server SQL Server is ready for client connections
2005-03-22 08:37:45.47 spid5 Starting up database ‘tempdb’.
2005-03-22 08:37:45.50 spid2 Recovery complete.
2005-03-22 08:37:58.50 server Using ‘sqlimage.dll’ version ‘4.0.5’
Stack Dump being sent to C
![Stick Out Tongue :p :p](styles/default/xenforo/smilies/tongue.png)
2005-03-22 08:37:58.50 server process_loginread: Process 2072 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
.
.
.
2005-03-22 09:00:52.91 server SQL Server is aborting. Fatal exception c0000005 caught. Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten
First install SQL server service pack 3, because you don’t have install any services pack.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
Thanks, I have tried numerous time to install the SP3 or 3a, but it never installs. This SQL server has SP3, but I am unable to apply the sp to the named instance. It has been at least 6 months since I tried last. At that time I posted messages for help in forums, and I searched the net for help, to no avail. I am not able to attempt an SP install for a few days, as it has to be after hours and I have plans. Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten
Gee, I wish I had that flexibility. <img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
Thanks, Derrick. I can only do what I can within this job’s boundries. <img src=’/community/emoticons/emotion-6.gif’ alt=’
![Frown :( :(](styles/default/xenforo/smilies/frown.png)
SELECT CONVERT(char(20), SERVERPROPERTY(‘edition’))
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
That’s it, Luis. I will apply the sp ASAP. Thanks! Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten
<img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
Hi Derrick, It would be nice if the error messages when trying to install the sp would indicate that you are installing the wrong version… but that would be too simple… <img src=’/community/emoticons/emotion-5.gif’ alt=’
![Wink ;) ;)](styles/default/xenforo/smilies/wink.png)
Great reply. You’ll fit in just fine around here. <img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
Thank-you, thank-you very much… <img src=’/community/emoticons/emotion-5.gif’ alt=’
![Wink ;) ;)](styles/default/xenforo/smilies/wink.png)
]]>