Event-ID 17401 on SQL Express

Wigi
Wigi Member Posts: 13
edited 2009-05-13 in SQL Performance
We have a customer who uses Entrepreneur with a SQL Express database server. The customer complains that the response time is, at times, very slow. I checked the eventviewer of the server and it contained the ID 17401 "Server resumed execution after being idle <number> seconds: user activity awakened the server. This is an informational message only. No user action is required.".
In order to prevent the SQL server from going into Idle state, I created a SQL script which does a select on the Company table and I created a scheduled task to run the script every 22 minutes (SQL Express seems to go into idle state after 25 minutes).
I am not completely happy with this workaround and therefore my questions is whether anyone has a better solution to solve this issue.
Thanks in advance. Wim.

Comments

  • Buba
    Buba Member Posts: 24
    It is designed to fell asleep after 25 minutes. There are no better tweaks than what you are already are using to avoid this. Or do what Microsoft wants you to do, upgrade to standard or enterprise version.

Categories