SQL Server Performance Forum – Threads Archive

MS SQLSERVER Service Stops Automaticaly. Why?

HI All, SQL Server Service stops automaticaly without any specific frequency. This is happening since last 2 weeks. There is not any specific frequency for this behaviour. There are no any messages in Sql Server logs before this error. Please help me to resolve this issue. Below pasted are the logs which I could retrive from SQL and System logs Microsoft SQL Server 2000 – 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) ============================== Application Log: —————– Date: 06.09.2005 Time: 09:49:19 Type: Error User: N/A Computer: SQL Source: MSSQLServer Category<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /><img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> Event ID: 19011 Description : SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5. ============================== System Log: Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7031 Date: 06.09.2005 Time: 09:49:19 User: N/A Computer: SQL Description: The MSSQLSERVER service terminated unexpectedly. It has done this 3 time(s). The following corrective action will be taken in 0 milliseconds: No action. ==============================

Check These http://support.microsoft.com/kb/892141
http://support.microsoft.com/kb/840856 says it can be due to SP3 and instruct you to install SP4 http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=5&messageid=106739

Dear Chech These, Currently, we are using SP3a. we are facing one issue in the SP4, our front-end is J.D.Edwards, which doesn’t support SP4.
Otherwise, we would have been tried that too. Anyone can help me in this issue?? Thanks and regards
-Johnson

There is a hotfix for the SP3, but you need to contact Microsoft Product Support Services to obtain the hotfix

Have you implement forced Encryption in connection !? and enable shared memory protocol !?
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

forced Encryption in connection : Unchecked
enable shared memory protocol : Checked

I believe you may need to look at JDEdwards website too for any support and compatibility with SQL SP4 and also as suggested with MS PSS. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Actually, we tried to install SP4, but then JDEdwards stopped functioning, then we immediatly revert back to SP3a, and we have checked with JDEdwards team, and they also not suggested SP4. But, it was working with SP3a till Aug 16.
Is there any thing related to the "A stack overflow exception may occur, and SQL Server 2000 may unexpectedly close when you submit a query that uses the UNION ALL operator more than 255 times
" -Johnson

Yes the error is referred in this KBAhttp://support.microsoft.com/kb/892141 and a hotfix is released too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi , As i ask you about "Enable Shared Memory" and "Forced Encryption in Connection" i found KB <a href=’http://support.microsoft.com/kb/815249′ target=’_blank’ title=’http://support.microsoft.com/kb/815249′<a target="_blank" href=http://support.microsoft.com/kb/815249>http://support.microsoft.com/kb/815249</a></a> <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by ghemant Have you implement forced Encryption in connection !? and enable shared memory protocol !? Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami <hr height="1" noshade id="quote"></blockquote id="quote"> to support my statement ,please look at WORKAROUND what it says is To work around this problem, turn off the shared memory protocol on the computer that is running SQL Server Service Pack 3 (SP3) This problem is corrected in SP4 but as it is not supported by JD Edwards,in my opinion you can go ahead with this option. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

Another workaround is to apply SP3a again and do what it was suggested by contacting JDEdwards too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

HI Johnson, have you look over the issue , please let us know if it is solved ! [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

Thanks to Hemantgiri and Satya, We are trying various option and possiblities. We doubt any probs with Windows 2000 SP4, so we applied it yesterday.. and so far, there is no stopage till now after that.. we don’t know that , is this a solution. Now we have put the trace On.. we want to identify the problem clearly… I will update you the details.. -Johnson

As there are third party tools involved, you must monitor the events closely in order to get granular results, let use know the outcome. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

This is to update you all about the progress in my production server. even after Win2k SP4, it was the same situation. There was one significant has been done after that. It was, Re-installed firmware for RAID Controller. Coz, one of our RAID controller had been replaced. We appllied new firmware which is downloaded from net. Now its more than 24 hours after that. SQL Server is running with out any termination. -Johnson

I don;t think there is any relation between RAID controller and SQL service pack to address the issue, anywya glad to see there is no issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Yes Satya,
We were trying our level best to resolve this issue.. We didn’t conclude this issue here.. let us observe this for 2 more days.. Till now we did these steps: 1-Re-installed SQL Server and Attached user databases and recreate logins and msdb jobs
2-Re-installed SP3(SQL)
3-Re-installed SP4(Win2k) the last step is Re-installation of RAID controller.. Let us see.. what will happen..

Oh that seems a block to do, I guess if the problem crops up within next week or so then you may need to check from third party vendor as we have seen from SQL side from logs and monitoring tools. As a best bet running PROFILER and PERFMON periodically may give some insight too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

yes Satya, We do run the trace… occassionaly.. but trace itself gives performance issue a lot. its not possible to put server-side trace, I do it client side with "Roll-over". still it consumes my local harddisk… We are on regular watch of the profiler.. lets see where it goes. -Johnson

You can take help ofhttp://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm link in order to schedule server side trace. KBAhttp://support.microsoft.com/?kbid=822853 too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I think we could conclude this topic till we get any other solution or such incidents,
coz, my Server running since the RAID Controllor driver is re-installed.. Its very strage that this issue is resolved like this. Its almost 4 Days with out any stoppage. thanks guys.. anyway, coz of this, I learned the possibilities of such issues.. great learning from you all.. thanks once more. -Johnson

]]>