SQL Server Express going to sleep

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Stewart - 29 Feb 2008 21:34 GMT

I'm a developer using SQL Server Express to a vb.net application. On regular
occasions I get a query that normally returns in less than a second, timeout
(90secs). Searching forums I noticed a lot of other people of the same
issue, but without resolve. People mentioned the AutoClose feature which was
TRUE by default before SP2. It kind of explains the behaviour I'm getting
(fast while actively querying, but times out or very slow after a break in
querying).

How can I best determine the cause?

Currently running SQL Server Express 9.0.3042

Reply to this Message

Uri Dimant - 02 Mar 2008 07:47 GMT

Andrew
Turn OFF AUTO CLOSE option. Regarding time out , I would assume that you
upgrade sql server 2000 database into sql server 2005, am I right?
Please examine an execution plan of the queries, do not forget running
update statistics on updgraded database (details in the BOL)

> I'm a developer using SQL Server Express to a vb.net application. On
> regular
[quoted text clipped - 10 lines]
>
> Currently running SQL Server Express 9.0.3042

Reply to this Message