HHEEEELLLPPP :o( .... My aspnet / sqlserver falls asleep??

Hi,
About every half hour, my sqlserver falls asleep.
When I try to browse my homepage (uses aspnet/sqlserver), I get this error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
If I stop and start the SQL server service, everything works fine (for
the next half hour, then it stops again).
The service manager says, that the service is running and the "SQL
server service manager util" also shows, that the service is running.
The SQL serverlog does not state any errors.
I have 2 gigs of free hdd space.
My eventlog (this is also strange) is empty. Not a single entry in
either Application, Security or System.
The server has worked fine until now. Nobody has changed anything
(besides updating the server with MS security patches).
Any idea'
Heeeellllppp!!! :o(
M O J OLooks like you are not closing database connections.
So eventually SQL runs out of them.
George.
"M O J O" <mojo@._no_spam_delete_this_newwebsolutions.dk> wrote in message
news:eVoGG8soDHA.3612@.TK2MSFTNGP11.phx.gbl...
> Hi,
> About every half hour, my sqlserver falls asleep.
> When I try to browse my homepage (uses aspnet/sqlserver), I get this
error:
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding.
> If I stop and start the SQL server service, everything works fine (for
> the next half hour, then it stops again).
> The service manager says, that the service is running and the "SQL
> server service manager util" also shows, that the service is running.
> The SQL serverlog does not state any errors.
> I have 2 gigs of free hdd space.
> My eventlog (this is also strange) is empty. Not a single entry in
> either Application, Security or System.
> The server has worked fine until now. Nobody has changed anything
> (besides updating the server with MS security patches).
> Any idea'
> Heeeellllppp!!! :o(
> M O J O
>|||Hi George,
Thanks for answering my post.
I've looked at the performance manager. I have max. 5 connections.
Any other suggestions?
Thanks,
M O J O
George Ter-Saakov wrote:
> Looks like you are not closing database connections.
> So eventually SQL runs out of them.
> George.
>
> "M O J O" <mojo@._no_spam_delete_this_newwebsolutions.dk> wrote in message
> news:eVoGG8soDHA.3612@.TK2MSFTNGP11.phx.gbl...
>>Hi,
>>About every half hour, my sqlserver falls asleep.
>>When I try to browse my homepage (uses aspnet/sqlserver), I get this
> error:
>>Timeout expired. The timeout period elapsed prior to completion of the
>>operation or the server is not responding.
>>If I stop and start the SQL server service, everything works fine (for
>>the next half hour, then it stops again).
>>The service manager says, that the service is running and the "SQL
>>server service manager util" also shows, that the service is running.
>>The SQL serverlog does not state any errors.
>>I have 2 gigs of free hdd space.
>>My eventlog (this is also strange) is empty. Not a single entry in
>>either Application, Security or System.
>>The server has worked fine until now. Nobody has changed anything
>>(besides updating the server with MS security patches).
>>Any idea'
>>Heeeellllppp!!! :o(
>>M O J O
>
>|||Have you tried just going into SQL Query Monitor or isql and entering a
query?
If this works your problem isn't SQL Server.
"M O J O" <mojo@._no_spam_delete_this_newwebsolutions.dk> wrote in message
news:eVoGG8soDHA.3612@.TK2MSFTNGP11.phx.gbl...
> Hi,
> About every half hour, my sqlserver falls asleep.
> When I try to browse my homepage (uses aspnet/sqlserver), I get this
error:
> Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding.
> If I stop and start the SQL server service, everything works fine (for
> the next half hour, then it stops again).
> The service manager says, that the service is running and the "SQL
> server service manager util" also shows, that the service is running.
> The SQL serverlog does not state any errors.
> I have 2 gigs of free hdd space.
> My eventlog (this is also strange) is empty. Not a single entry in
> either Application, Security or System.
> The server has worked fine until now. Nobody has changed anything
> (besides updating the server with MS security patches).
> Any idea'
> Heeeellllppp!!! :o(
> M O J O
>|||>--Original Message--
>About every half hour, my sqlserver falls asleep.
Only 1% this could be the reason, but... which screen
saver do you use on the server? We had about the same
problem, when we realised that the server always went back
up every time someone touched the mouse. Apparantly
the "3D Pipes" screen saver used that much processor power
nothing that the server went virtually down. Setting the
screen saver to "Blank screen" solved the problem.
Just my 2ct.