Debug performance diagnostics of a catalog item

Analyze the impact of the variable setup in a catalog item on its runtime performance, and identify any issues. You can review the processing time of the catalog item and its variables based on the triggered SQL queries.

始める前に

Role required: admin or catalog_admin

このタスクについて

The variable SQL debugger is not applicable for the following variables:

• Container Start
• Container End
• Container Split
• Break

手順

1. Enable the variable SQL debugger by navigating to Service Catalog > Catalog Variables > Enable Variable SQL Debugger.
   注:

   • The variable SQL debugger is applicable for catalog items and record producers.
   • After you enable the variable SQL debugger, if you disable the display of the troubleshooting information on a catalog page by navigating to System Diagnostics > Session Debug > Disable All, the variable SQL debugger is still active.
   • To disable the variable SQL debugger, navigate to Service Catalog > Catalog Variables > Disable Variable SQL Debugger.
2. Navigate to Service Catalog > Catalog Definitions > Maintain Items, select a catalog item that you want to debug, and click Try It.
3. Click the more options icon () and select Show Variable SQL Debugger.
   The following information is displayed in the Variable SQL Debugger window:

   • Number of variables included in the catalog item.
   • Number of SQL queries triggered for the catalog item.
   • Time taken to process and load the catalog item page.
   • Time taken to run all SQL queries of the catalog item.

   表 : 1. Variable SQL debugger fields

   Field	Description
   Variable	Catalog item variable for which the performance diagnostics are displayed.
   Processing Time	Time taken to process and load the variable.
   SQL Count	Number of SQL queries triggered for the variable.
   SQL Time	Time taken to run SQL queries for the variable.
   SQLs	Details of the SQL queries triggered for the variable.

4. To sort by any field, click the field name.
   注:

   • By default, variables are sorted in descending order by their processing time.
   • Variables within a single-row or multi-row variable set are displayed in hierarchical order.
5. To view the configuration of a variable, click the variable name.
6. To view a detailed summary of all SQL queries triggered for a variable, click View Details in the SQLs field of the variable.
7. To change the sort order, Use the Sort By list.
   注:

   By default, triggered SQLs are sorted in descending order by their execution order.