I have recently noticed an issue on our DB hosted server where our DB services are taking a very long time to start after a system reboot. We are talking 20 minutes or so on a small DB running on a server with 8GB of RAM.
We have 3 services in question and it does not matter which combination of them are stopped or disabled, one or all of them will not start until at least 20 minutes has elapsed. One of the services is set as follows:
-n SVRNAME -x TCPIP(port=2639) -c 2g -gp 4096 D:\XXXDatabases\CentralDB\XXX.db -n DBNAME -ec Simple
What could be holding this up, we have tried to monitor start-up applications and services with no joy. When the DB is started using just DBSRV16.exe without being controlled by a service it starts with no problem, the issue does appear to be when it is controlled by a service. Once it has started the first time (using a service) we can stop and start easily, it is just after a reboot it has issues.
asked 16 Oct '15, 11:52