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.
0
Comments