Enabling context comments in queries on SQL Server

On SQL Server, tuning queries can be difficult because you cannot determine what part of the application generates specific queries. To help tune certain queries, you can enable two configuration parameters in config.xml.

• IdentifyQueryBuilderViaComments – Instrumentation comments from higher level database objects constructed by using the query builder APIs
• IdentifyORMLayerViaComments – Instrumentation comments from lower level objects, such as beans, typelists, and other database building blocks

If you set either parameter to true, PolicyCenter adds SQL comments with contextual information to certain SQL SELECT statements that it sends to the relational database. The default for IdentifyQueryBuilderViaComments is true. The default for IdentifyORMLayerViaComments is false.

The SQL comments are in the format:

/* applicationName:ProfilerEntryPoint */

The applicationName component of the comment is PolicyCenter.

The ProfilerEntryPoint component of the comment is the name of an entry point known to the Guidewire profiler for that application. For example, ProfilerEntryPoint might have the value WebReq:ClaimSearch.