Hi,
I restart the services each night via a batch file. According to Task Scheduler, the task is completed every night. Yet, half the time, databases are loaded into memory that have not been accessed since the previous day - indicating that the services did not restart. The main issue is high memory usage before the overnight data uploads which slows the process down significantly. Is there any log information which may reveal why this (sometimes) happens?
Below is the script used in the batch file. When launched manually it has always worked.
net stop "Board Engine"
Rem -- Wait for 5 minutes
timeout/t 300
Rem -- Now Start the service
net start "Board Engine"
Do you use a different script?
Thanks,
Ben
------------------------------
Ben Campbell
Business Intelligence Developer
L & Q
United Kingdom
------------------------------