> For the complete documentation index, see [llms.txt](https://docs.devolutions.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.devolutions.net/server/knowledge-base/how-to-articles/prevent-sql-timeouts.md).

# Prevent SQL timeouts

Managing a lot of entries in one single operation or having a high number of connected users could lead to SQL Timeout error messages with Devolutions Server. The following modification on the database advanced parameters could help to prevent getting SQL Timeouts.

1. The first one to consider is the ***Connection maximum pool size*** Increasing that parameter to 1000 instead of the default 100 will help to level up the number of possible database connections.
2. The second parameter is the ***Connection timeout*** that can be increased to 30 seconds. This will make the system wait for 30 seconds before raising an exception.
3. The last one is the ***Connection retry count*** as it will repeat each ***Connection timeout*** delay before generating an error. By setting it to 5, the Devolutions Server instance will wait 150 seconds before raising an SQL Timeout.

   <figure><img src="https://cdnweb.devolutions.net/docs/DVLSCONSOLE4000_2024_1.png" alt=""><figcaption></figcaption></figure>

For more information about these parameters, please see [Database – Advanced Settings](https://docs.devolutions.net/server/devolutions-server-console/devolutions-server-settings/database/advanced-settings/).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.devolutions.net/server/knowledge-base/how-to-articles/prevent-sql-timeouts.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.