Please Help With Windows Server 2008 Lockup Problem

[chapmjw]

Please help with windows Server 2008 lockup problems.

I've got a new hp server running windows server 2008. This servers role is to write data from 12 or so plcs to a mssql 2008 database that it hosts. It also displays this data using its web server; only 10 users or so. The load is very light. The problem I have occurs on regular intervals in the range of 7 to 8 days. MsSql will continue to log data but the web server will not work, nor can you log in when things go wrong. A login attempt at the machine or by remote desktop will just pause indefinitely after you supply a password. I can't find anything in the event viewer that would show where the error is coming from. But I do see the consequences of the problem:

over and over I get timeout messages like these.
1. A timeout (60000 milliseconds) was reached while waiting for a transaction response from the ReportServer$SLSQL service.
2. A process serving application pool 'MyxWebsite' exceeded time limits during start up. The process id was '3092'.

MsSql memory is limited to 1Gig and stays there.
no other programs use more memory than 150 megs or so and don't grow in size.
Any suggestions are greatly appreciated, we are at a loss.
thanks
jim

 

[ICTCity]

Hi there.

First of all let's try to determine if the problem is really the timeout or not.

So, increase the timeout (let's say 120000 ms = 2 mins), after this modify you need to restart your server.

When you say "every 7 or 8 days" you mean that this problem occurs on a specific day AND time? If so, you could check if there's any scheduled task (backup, defrag, ...) which runs at that day / time.

Another thing you could do, is to enable PERFORMANCE MONITOR LOG. This utility (installed by default on windows), allows you to write values on a text file (csv I think...), and then analyze it. Enable this log (don't use an interval too short), and let it register until you have this issue again. By doing this, you simply have the chance to understand if your server goes out of memory / cpu / disk / ... when this happens.


Let me know.