| Author |
Topic |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-06-14 : 23:57:45
|
| Hi all, I have a testing server which often auto shuts down by itself. It looks pretty like a hardware/OS problem, however, it only happens when we are running something on the SQL Server, so I wish to know if any of you has some opinion whether any SQL Server tuning/configuration can help ... My server is Windows 2000 server with SP4, one single Pentium 4 2.8 GHz CPU, with 2 GB physical memory. SQL Server 2000 SP3a is installed on it. At the beginning, there were only 256 MB memory on the server. We found that the server auto shuts down by itself even if we are not running any queries/data transfer/backup. We just make a connection to it, e.g. through Query Analyzer. Then we added memory to make it 2 GB. The problem occurs less frequently. However, it still happens when we do some fairly large data transfer jobs, e.g. use DTS to copy a table with 200,000 rows (run locally), backup through Veritas, etc. There is no special error log in event log or SQL Server log, and there is no Dr. Watson or memory dump log. Initially we set the SQL Server instance to use all maximum available memory (i.e. 2 GB). Then we tried to set this lower in EM (lowered it to 600 MB) as maximum memory, but the problem still happens. The problem does not occur when we are copying large OS-level files. Is this a server/hardware problem? Or there is seomthing we can configure in SQL Server? Thanks for your opinion,delpiero |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-06-15 : 06:08:53
|
| What else runs on the server?Maybe it's overheating or a power related problem. Does it have UPS and sufficient ventilation?-------Moo. :) |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-15 : 08:44:38
|
| Is it a database shutting down or does the SQL Server Service just up and stop?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
delpiero
Yak Posting Veteran
98 Posts |
Posted - 2005-06-15 : 21:23:32
|
| Hi,Nothing else runs on the server. Just SQL Server 2000. Not only the database or the service is shut down, but the entire machine just goes black screen with only the keyboard lights still on. We have to manually press the power button to shut it down and press it again to start it up ...........Thanks,delpiero |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-15 : 21:41:07
|
| Get a new server my friend. I'm being serious.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-06-16 : 04:43:09
|
| If this is a pre-built server then either get the after-sales support guys to fix it or do as Derrick says and buy a new server.If this is a custom server that you have built, then make sure all the components are working, that the power supply is quality, that you have suitable cooling and that your UPS is working.If you have system diagnostics, check for power irregularities and overheating.-------Moo. :) |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-06-16 : 05:12:37
|
| it sounds like it is going into a standby or hibernation mode (like a laptop does). Is there anything in the system or application event during the times this happens?What power features are enabled in your bios? Is this a major brand server, or something put together with off the shelf parts?-ec |
|
|
|
delpiero
Yak Posting Veteran
98 Posts |
Posted - 2005-06-16 : 06:10:18
|
| It is a test server lent to us by our vendor. All hardware configurations are from their default. There is no UPS configured.Anyway, I do agree to get a new one, but I've got to give some explanations to my boss ........delpiero |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-06-16 : 07:48:43
|
| It's probably power or hardware. If you don't have the tools or the knowledge to diagnose the problem though then I would have thought that it's not really up to you to do so and that "the server doesn't work" is all you need to say.-------Moo. :) |
|
|
|
|
Server auto-shutdown