3.25 Recommended Knowledge Script Groups

You can find the SQLServer Knowledge Script Groups (KSGs) on the RECOMMENDED tab of the Knowledge Script pane in the Operator Console.

All the scripts in the KSGs have their parameters set to recommended values. To run all of the recommended scripts in a KSG at one time, click the RECOMMENDED tab, and then run the KSG on a SQL Server resource.

The SQLServer KSGs enable a “best practices” usage for monitoring your SQL Server environment. You can use these KSGs with AppManager monitoring policies. A monitoring policy lets you efficiently and consistently monitor all the resources in your environment using a set of preconfigured Knowledge Scripts. For more information, see “About Policy-Based Monitoring” in the AppManager Help.

A KSG is composed of a subset of a module’s Knowledge Scripts. The script that belongs to a KSG is a different copy of the original script you access from the SQLServer tab. If you modify a script that belongs to a KSG, the parameter settings of the original script in the SQLServer tab are not affected.

In some cases, default script parameter settings are different when the script is deployed as part of a KSG, as opposed to when it is deployed alone. The default settings of a script within a group depend on its monitoring purpose within the larger group, and on the intended monitoring scope of that group.

If you modify or remove a script associated with the SQLServer KSG and want to restore it to its original form, you can reinstall the AppManager For SQLServer module on the repository computer or check in the appropriate script from the AppManager\qdb\kp\SQLServer directory.

The following Knowledge Scripts are members of the SQLServer recommended KSG to monitor SQL Server: