---
sourceDocument: Australia ServiceNow AI Platform Capabilities
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/de-DE/servicenow-platform

 Release :

    - australia

ft:locale :

    - de-DE

ft:publication_title :

    - Australia ServiceNow AI Platform Capabilities

ft:clusterId :

    - platcap

bundleId :

    - platcap

workflow :

    - Platform


---

# Debug performance diagnostics of a catalog item

# Debug performance diagnostics of a catalog item {#ariaid-title1}

* Freigeben Version: Australia
* 
* Aktualisiert 12. März 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 Minute Lesedauer

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.

## Vorbereitungen

Role required: admin or catalog_admin

## Warum und wann dieser Vorgang ausgeführt wird

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

* Container Start
* Container End
* Container Split
* Break
{#debug-perf-diagnostics__ul_kyt_cgs_ydb}

## Prozedur

1. Enable the variable SQL debugger by navigating to Service CatalogCatalog VariablesEnable Variable SQL Debugger.  
   Hinweis:  
   * 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 DiagnosticsSession DebugDisable All, the variable SQL debugger is still active.
   * To disable the variable SQL debugger, navigate to Service CatalogCatalog VariablesDisable Variable SQL Debugger.
   {#debug-perf-diagnostics__ul_jcj_m55_vdb}
2. Navigate to Service CatalogCatalog DefinitionsMaintain Items, select a catalog item that you want to debug, and click Try It.
3. Click the more options icon (![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.

   {#debug-perf-diagnostics__ul_jb3_4bv_vdb} {#debug-perf-diagnostics__table_ybp_jff_xdb__entry__2}

   | 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. |
   [Tabelle : 1. Variable SQL debugger fields]

   {#debug-perf-diagnostics__table_ybp_jff_xdb}
4. To sort by any field, click the field name.  
   Hinweis:  
   * 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.
   {#debug-perf-diagnostics__ul_hbr_rpx_k2b}
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.  
   Hinweis:  
   By default, triggered SQLs are sorted in descending order by their execution order.