---
schema_version: "1"
id: 7c851433b1c2da5609c385b4079895864e9933d0f5bee1bf031bf4273e31e9bd
title: Slow Queries
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/server-linux/rmt-incidents-slow-query.md
canonical_url: https://help.tableau.com/current/server-linux/en-us/rmt-incidents-slow-query.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 08460a2af9adbded44fc6a72bf847e2bd4a08cf2a302664da75f1a625981b70e
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-linux/en-us/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-linux/en-us/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.