Transaction in database applications
- Last Updated: April 5, 2026
- 1 minute read
- Flowmon Products
- Flowmon Application Performance Monitoring
- Documentation
A monitored transaction represents one database query and the corresponding response. Every transaction includes the identification (name) of the transaction and the database query.
Identification (name) of a transaction is generated automatically for database queries according to the following table:
| Beginning of the SQL query | Transaction identification |
|---|---|
| SELECT DELETE FETCH | + “FROM” followed by a list of tables to which the query relates. |
| BULK | + 3 following words. |
| EXEC INSERT without INTO | + 1 following word. |
| BEGIN TRAN ROLLBACK TRAN | Nothing else is added after the transaction name. |
| Other | The first 3 words. |
The SQL query field in the table of transaction instances includes the entire SQL query if the query is shorter than the maximum length. The maximum length of an SQL query is set by default to 2,000 characters. The maximum length can be edited under Settings > Advanced > Advanced settings > Parser settings panel > MaxSQLLen field.
If an SQL query is not saved in its entirety, that is, its length is greater than the maximum one, an ellipsis is added at the end of the saved query. In “SELECT”, “DELETE”, and “FETCH” queries the ellipsis can also be followed by “//FROM” followed by a list of tables that appear in the unsaved part of the query.