---
schema_version: "1"
id: 25868a12dd1ec33d368a34f49139f9edb86def894d3a2ec4daba71278fcff825
title: Slow Queries
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/server/rmt-incidents-slow-query.md
canonical_url: https://help.tableau.com/current/server/en-gb/rmt-incidents-slow-query.htm
source_site: help.tableau.com
content_type: documentation
content_hash: f0cdd9aace8c33d4847a19a2c2922d7d929ebd09507a51514a8ac771e2def52e
description: Understand and configure slow query incidents in the Resource Monitoring Tool.
---
[Skip to main content](#main-content)

# Slow Query Incidents

_Slow Query_ incidents are triggered when any data query takes too long to complete. By default, a Slow Query incident will trigger a warning if any data query takes at least 30 seconds to execute.

You can configure thresholds using the RMT Server web interface or by updating the configuration file `config.json`.

To set the thresholds for slow query incidents, under the **Admin** menu, select **Configuration**, and go the **Incidents** tab.

<table style="width: 100%;" class="simple-table"><colgroup><col><col><col></colgroup><thead><tr><th>Key</th><th>Required?</th><th>Description</th></tr></thead><tbody><tr><td><b>Severity</b></td><td>Required</td><td><p>See <a href="https://help.tableau.com/current/server/en-gb/rmt-incidents-index-incidents.htm#incident-severity-levels">Incident Severity Level</a>.</p></td></tr><tr><td><b>Duration</b></td><td>Required</td><td>The minimum duration for a query to be considered slow. Values are in seconds.</td></tr></tbody></table>

An example `config.json` snippet defining a Slow Query incident:

```
{  
 "monitoring":  {  
    "incidents":  {  
      "triggers":  [  
        {  
          "counter":  "DataQueryDuration",  
          "severity":  "critical",  
          "threshold":  45000  
        }  
      ]  
    }  
  }  
}
```

This Slow Query incident will trigger if a data query takes at least 45 seconds to execute.

Incidents can be configured per environment. As an example, for an environment whose identifier was “staging-environment” to trigger a warning when a data query takes longer than 30 seconds to execute, the configuration would look like:

```
{  
  "environments":  {  
    "staging-environment":  {  
     "monitoring":  {  
       "incidents":  {  
          "triggers":  [  
            {  
              "counter":  "DataQueryDuration",  
              "severity":  "warning",  
              "threshold":  30000  
            }  
          ]  
        }  
      }  
    }  
  }  
}
```

| Key | Data Type | Required? | Description |
| --- | --- | --- | --- |
| `counter` | String | Required | Slow Query incidents use the `DataQueryDuration` identifier. |
| `severity` | String | Optional | See [Incident Severity Level](https://help.tableau.com/current/server/en-gb/rmt-incidents-index-incidents.htm#incident-severity-levels). Default value: `Warning` |
| `threshold` | Number | Required | The minimum duration for a query to be considered slow. Values are in milliseconds. |

## Who can do this

Resource Monitoring ToolAdministrator or a Resource Monitoring Tool user with **Server/Environment Management** role.