Administrative#
Administrative stored procedures should be used by power users and administrators.
Stored procedure name |
Description |
|---|---|
Flushes the whole execution plan cache. |
|
Processes expired Job execution logs according to the Engine configuration. |
|
Attempts garbage collection to reclaim unused memory. |
|
Configures federator for an agent. Given connection will be the new default federator for the designated agent. |