Limit Database Queries by Maximum Run Time

You can specify the maximum time a query can run on a physical database for a particular application role.

You can override the time queries that you set for an application role. See Override an Application Role's Query Limits.

The options for time limit are:

• Enable - This limits the time to the value specified.

• Disable - Disables any limits set in the Max Time field.

• Warn - Logs queries that exceed the set time limit in the Query log. This option doesn't enforce the time limits.

• Inherit - Inherits limits from the parent application role. If there is no time limit to inherit, no limit is enforced.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer .
4. In the Physical Layer pane, locate and double-click the database that you want to assign query limits to.
5. Click the Query Limits tab.
6. Locate the role name that you want to limit, double-click its Max time (minutes) field, and enter the maximum number of minutes rows that want queries to run on each database object.
7. Double-click the Time Limit field and select a time limit.
8. Click Save.