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.

Help: Query Timeout Expired

Hi,
I have a long running view (counting over 2,000,000 records) that regurns
"[ODBC SQL Server Driver] Timeout Expired" error after about 30 seconds.
Can somebody tell me how to increase the timeout period for running View?
Thanks in advance.
Regards
YeeYee,
were are you running the view from , EM? If you are don't. Try running it
from QA.
Timeouts are a client connection issue and can be adjusted via your ODBC
connection details, they are not a server problem.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.aspx. Free icon extraction
program
http://www.ag-software.com. Free programming tools
"Yee CN" <nospamxx_cn.yee@.attic-solutions.com> wrote in message
news:eZsXYag6DHA.2656@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a long running view (counting over 2,000,000 records) that regurns
> "[ODBC SQL Server Driver] Timeout Expired" error after about 30 seconds.
> Can somebody tell me how to increase the timeout period for running View?
> Thanks in advance.
> Regards
> Yee
>|||Hi Yee:
The timeout may haeepn in several place. You can change it by T-SQL for
database or in the ADO for for ODBC.
Because you do not let us know what kind of operation you are doing.
What I can do is give some suggestion.
For database, you can type "timeout" in book online then you can get
information of how to set the timeout property in diffirent situation
For ODBC you can see this link and see the timeout part.
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003JUL.1033/dnodbc/html/odbcsql.htm
Best Wishes
Wei Ci Zhou|||I was running it in EM. Just tried with QA, still the same problem.
I was managed to get it to run once earlier on though. It seems that the
timing the first row got returned is important here.
Regards,
Yee
"Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in
message news:eGGXBsg6DHA.2056@.TK2MSFTNGP10.phx.gbl...
> Yee,
> were are you running the view from , EM? If you are don't. Try running
it
> from QA.
> Timeouts are a client connection issue and can be adjusted via your ODBC
> connection details, they are not a server problem.
>
> --
> I hope this helps
> regards
> Greg O MCSD
> http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe
Documentation
> Builder, the quickest way to document your database
> http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
> Property Extended properties manager for SQL 2000
> http://www.ag-software.com/IconExtractionProgram.aspx. Free icon
extraction
> program
> http://www.ag-software.com. Free programming tools
>
> "Yee CN" <nospamxx_cn.yee@.attic-solutions.com> wrote in message
> news:eZsXYag6DHA.2656@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I have a long running view (counting over 2,000,000 records) that
regurns
> > "[ODBC SQL Server Driver] Timeout Expired" error after about 30 seconds.
> >
> > Can somebody tell me how to increase the timeout period for running
View?
> >
> > Thanks in advance.
> >
> > Regards
> > Yee
> >
> >
>|||I was opening the view from Enterprise Manager, then from Query Analyser.
Both gives the same error. I tried various things suggested in the help
file, including using sp_configure.
I also found the following from book online. The error message is what I
got - but I could not find the Tool->option screen mentioned below. Can you
shed any light?
----
--
ODBC error text
[Microsoft][ODBC SQL Server Driver]Timeout expired.
Explanation
The timeout can occur when you're updating the database with any
Transact-SQL changes.
Action
a.. Try again later to save the diagram or selected tables.
b.. Save a change script and apply it to the database at a later time.
c.. Increase the SQL Query Time-out value and try to save the diagram or
selected tables again.
To increase the SQL Query Time-out value
1.. From the Tools menu, choose Options.
2.. In the left pane, click Data Tools, and then click Data View.
3.. Type a new value in the SQL query time-out box.
----
--
Also the link that you suggested:
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003JUL.1033/dnodbc/html/odbcsql.htm
- can you tell me how to get there?
Thanks a lot for your help.
Best regards,
Yee
"Wei Ci Zhou" <weicizhou@.hotmail.com.discuss> wrote in message
news:eBoSXfh6DHA.3008@.TK2MSFTNGP09.phx.gbl...
> Hi Yee:
> The timeout may haeepn in several place. You can change it by T-SQL
for
> database or in the ADO for for ODBC.
> Because you do not let us know what kind of operation you are doing.
> What I can do is give some suggestion.
> For database, you can type "timeout" in book online then you can get
> information of how to set the timeout property in diffirent situation
> For ODBC you can see this link and see the timeout part.
> Best Wishes
> Wei Ci Zhou
>

Help: Query Timeout Expired

Hi,
I have a long running view (counting over 2,000,000 records) that regurns
"[ODBC SQL Server Driver] Timeout Expired" error after about 30 seconds.
Can somebody tell me how to increase the timeout period for running View?
Thanks in advance.
Regards
YeeYee,
were are you running the view from , EM? If you are don't. Try running it
from QA.
Timeouts are a client connection issue and can be adjusted via your ODBC
connection details, they are not a server problem.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.aspx. Free icon extraction
program
http://www.ag-software.com. Free programming tools
"Yee CN" <nospamxx_cn.yee@.attic-solutions.com> wrote in message
news:eZsXYag6DHA.2656@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hi,
> I have a long running view (counting over 2,000,000 records) that regurns
> "[ODBC SQL Server Driver] Timeout Expired" error after about 30 seconds.
> Can somebody tell me how to increase the timeout period for running View?
> Thanks in advance.
> Regards
> Yee
>

---

|||Hi Yee:
The timeout may haeepn in several place. You can change it by T-SQL for
database or in the ADO for for ODBC.
Because you do not let us know what kind of operation you are doing.
What I can do is give some suggestion.
For database, you can type "timeout" in book online then you can get
information of how to set the timeout property in diffirent situation
For ODBC you can see this link and see the timeout part.
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003JUL.1033/dnodbc/html/odbcsql.htm
Best Wishes
Wei Ci Zhou|||I was running it in EM. Just tried with QA, still the same problem.
I was managed to get it to run once earlier on though. It seems that the
timing the first row got returned is important here.
Regards,
Yee
"Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in
message news:eGGXBsg6DHA.2056@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Yee,
> were are you running the view from , EM? If you are don't. Try running

---

it

quote:

---

> from QA.
> Timeouts are a client connection issue and can be adjusted via your ODBC
> connection details, they are not a server problem.
>
> --
> I hope this helps
> regards
> Greg O MCSD
> http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe

---

Documentation

quote:

---

> Builder, the quickest way to document your database
> http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
> Property Extended properties manager for SQL 2000
> http://www.ag-software.com/IconExtractionProgram.aspx. Free icon

---

extraction

quote:

---

> program
> http://www.ag-software.com. Free programming tools
>
> "Yee CN" <nospamxx_cn.yee@.attic-solutions.com> wrote in message
> news:eZsXYag6DHA.2656@.TK2MSFTNGP11.phx.gbl...
regurns[QUOTE]
View?[QUOTE]
>

---

|||I was opening the view from Enterprise Manager, then from Query Analyser.
Both gives the same error. I tried various things suggested in the help
file, including using sp_configure.
I also found the following from book online. The error message is what I
got - but I could not find the Tool->option screen mentioned below. Can you
shed any light?
----
--
ODBC error text
[Microsoft][ODBC SQL Server Driver]Timeout expired.
Explanation
The timeout can occur when you're updating the database with any
Transact-SQL changes.
Action
a.. Try again later to save the diagram or selected tables.
b.. Save a change script and apply it to the database at a later time.
c.. Increase the SQL Query Time-out value and try to save the diagram or
selected tables again.
To increase the SQL Query Time-out value
1.. From the Tools menu, choose Options.
2.. In the left pane, click Data Tools, and then click Data View.
3.. Type a new value in the SQL query time-out box.
----
--
Also the link that you suggested:
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003JUL.1033/dnodbc/html/odbcsql.htm
- can you tell me how to get there?
Thanks a lot for your help.
Best regards,
Yee
"Wei Ci Zhou" <weicizhou@.hotmail.com.discuss> wrote in message
news:eBoSXfh6DHA.3008@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Hi Yee:
> The timeout may haeepn in several place. You can change it by T-SQL

---

for

quote:

---

> database or in the ADO for for ODBC.
> Because you do not let us know what kind of operation you are doing.
> What I can do is give some suggestion.
> For database, you can type "timeout" in book online then you can get
> information of how to set the timeout property in diffirent situation
> For ODBC you can see this link and see the timeout part.
> Best Wishes
> Wei Ci Zhou
>

---