A System Administrator can enable server-wide plan capture, association, and replacement modes with these configuration parameters:
abstract plan dump – enables dumping to the default abstract plans capture group, ap_stdout.
abstract plan load – enables loading from the default abstract plans loading group, ap_stdin.
abstract plan replace – when plan dump mode is also enabled, enables plan replacement.
abstract plan cache – enables caching of abstract plan hash IDs; abstract plan load must also be enabled. See “set plan exists check option” for more information.
By default, these configuration parameters are set to 0, which means that capture and association modes are off. To enable a mode, set the configuration value to 1:
sp_configure "abstract plan dump", 1
Enabling any of the server-wide abstract plan modes is dynamic; you do not have to reboot the server.
Server-wide capture and association allows the System Administrator to capture all plans for all users on a server. You cannot override he server-wide modes at the session level.
