sp_help_qpgroup

Reports information on an abstract plan group.

Syntax

sp_help_qpgroup [ group [, mode ]]

Parameters

Examples

Usage

When used with an abstract plan group name, and no mode parameter, the default mode for sp_help_qpgroup is full.

Hash-key collisions indicate that more than one plan for a particular user has the same hash-key value. When there are hash key collisions, the query text of each query with the matching hash key must be compared to the user’s query text in order to identify the matching query, so performance is slightly degraded.

Permissions

The permission checks for sp_help_qpgroup differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage abstract plans privilege.

Disabled

With granular permissions disabled, you must be the database owner or a user with sa_role. Any user can execute sp_help_qpgroup for their own abstract plan group.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

InformationValues
Event

38

Audit option

exec_procedure

Command or access audited

Execution of a procedure

Information in extrainfo
  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

Related reference
sp_help_qplan