It’s quite often when we face problems of Random Service Crash in Windows VPS. You may come across the situations wherein;
- Some of VPS services MS SQL, MySQL, SmarterMail, WebsitePanel stop automatically.
- Random service crash occurs and it reappears after some hours/days.
- Your applications failed to connect to MS SQL database, you go ahead and check MS SQL service, you found MS SQL service in stopped status. After restarting the MS SQL service manually, application - database connection becomes normal.
- You cannot connect to SmarterMail web interface due to SmarterMail service crash.
- Your web pages with MySQL database backend throw database connectivity errors.
- After loading for long time, WebsitePanel URL ends in error.
Check CPU and RAM Usage of VPS through Windows Task Manager >> Performance
- Right click on Task Bar, Select Start Task Manager.
You will see current RAM and CPU usage of your VPS. Some of your VPS services wont function expectedly if RAM and CPU usage of your VPS is above 90%.
Check Diskspace Usage of VPS
- Go to Start → Click Computer.
Configure Service Recovery Properties
Services can also be configured to recover automatically after crash. Follow below mentioned steps:
<ol "start=1">
- Go to Start → Run → Type services.msc Click OK.
- In Services Window, locate the service you want to configure, Right click on the service name, Click on Properties.
- In Service Properties Window, Click on Recovery tab.
- Select the option Restart the Service in First failure Drop down.
- Select the option Restart the Service in Second failure Drop down.
- Select the option Restart the Service in Third failure Drop down.
- Click on Apply and then OK.
You can also set several other properties like, Reset Failure Counter after x days and Restart the service after 1 minute since crash. Repeat above steps for each service you want to configure for the automatic recovery.
Determine the Root Cause of Service Crash Through Event Viewer
- Go to Start → Run → Type eventvwr, Click OK.
- In Event Viewer Window, Under Windows Logs, Check Application and System logs.
- Locate the Error logs recently registered for the service in question.
- Click on Log entry.
Under General tab, you will see full description of the logged error. The important details which the application event log gives us is Source, Event ID, User, Exception Code etc. Exception code explains what exactly this error means. You can also google the exception code for more information on a registered log.