Posted on 5:11 AM by Softminer and filed under ,

Usually after a long run time of SQL service, ther process takes a lot of memory resources. by restarting the service the token memory resource will be released.

restarting can be accomplished using the

net stop
net start
A full list of the exact services is found in the registry (run regedit.exe) under the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services key.

Alternatively, you can perform the stop and start using the name that is showed in the Services Control Panel applet by putting the name in quotes, i.e.
net stop ""
net start "
Responses to ... Restaring SQL Server Agent Service on Windows