Terminates Monitor Server.
sms_shutdown [no_wait]
terminates Monitor Server immediately, without waiting for commands executing on other client connections to complete. This parameter allows Monitor Server to release all resources, such as shared memory, before termination.
If this parameter is omitted, Monitor Server terminates after waiting for active commands executing on other client connections to complete. No new commands are accepted.
Only the “sa” or the Monitor Server superuser can use this command.
The Monitor Server heartbeat feature detects when Adaptive Server is down and shuts down Monitor Server as a result. See “Heartbeat interval” for more information.
