0
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 "
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 "
Post a Comment