| Author |
Topic |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2007-04-26 : 20:19:19
|
| currently we are running sql server 2000 on a 1 quad core cpu server with 4 GB ram, the SQL SERVER service will terminate suprisingly every now and then, although the server will still be running fine, we usually reboot to resolve issue... does anyone know why this could be cause or any suggestions on things to check?its very strange because it is a new server (1 month new) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 22:59:47
|
| Any useful message in sql server log or windows event logs? |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-04-29 : 21:12:15
|
| When sql server Fails.The server locks due to SQL and when we restart we have to disable SQL databases, else it will just lockup again,The SQL log has nothing in it,Windows Events has nothing in it, |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-29 : 21:34:59
|
| Who is server manufacturer? Are all drivers and firmwares up to date? |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-04-29 : 21:49:00
|
| HP ProLiant DL360 G5 Server all drivers upto date as of last month |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-30 : 13:15:41
|
| I'll check with HP in this case, may have bad parts on the server. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-30 : 14:17:43
|
| Any Triggers / SPRocs / etc. calling COM objects or similar? (Although Bad Code in this regard normally results in a Memory Dump file, which will be in the SQL Log folder)Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-30 : 14:40:41
|
| When a service terminates unexpectedly, there will be events in Event Viewer associated with it. Are you positive that there aren't any events in either the Application Log or the System Log in Event Viewer on this failed service? If there aren't any events, then you need to contact Microsoft. If there are events, then we can most likely help you.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-04-30 : 18:27:55
|
| last thing in sql log is:----------------------------------------------------SQL Server is terminating due to 'stop' request from Service Control Manager.----------------------------------------------------Performance monitor shared memory setup failed: -1---------------------------------------------------- |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-30 : 18:42:54
|
| Someone or something is initiating a stop of the service.When it is unexpected, you won't see that message in the SQL Server Error Log.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-04-30 : 19:02:53
|
| okay we know no one is initiating it , so now have to identify WHAT is issueing a stop service |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-04-30 : 19:06:57
|
| my mistake ive checked with team member, and it looks like that message is occuring after reboot by himself which is done in order to restart jobs etc...so this error occurs after reboot and not the cause of reboot |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-30 : 19:21:15
|
| It isn't an error. Things in the SQL Server Error Log are not necessarily errors. They can be informational messages too.Ask your team member what the actual problem is so that we can help you with this. Rebooting is not the answer.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-04-30 : 19:54:12
|
| thanx but the problem is as mensioned at the start of this thread, as a result of the problem he reboots the server in order ot bring it up again, once server is rebooted he then stop SQL service to start some jobs then starts SQL server again...so we're still to find what the problem is ...? we have tried a few things at 4pm yesterday hasn't crashed yet hopefully this has fixed it |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-01 : 11:54:00
|
| At the start of the thread, you start the service is terminating unexpectedly. We learned that it wasn't true based upon the messages in the SQL Server Error Log. The service is terminating as a result of a stop. So please explain exactly what the problem is, so we know how to help you.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-05-01 : 18:21:07
|
| thats okay i really appreciate your help guys but we think it may be okay now, probably caused by a ram issues... which has now been resolved... |
|
|
|
|
sql server random crashes?