Parameter:
DEBUG_TASK_DETAILShort description: Generates detailed task statistics on the server console and shows the current action of each server task.
Profile
Parameter | DEBUG_TASK_DETAIL |
Category | Logging / Debug |
Component | Server |
Available since | 9.0.1 |
Supported versions | 9.0.1, 10.0, 11.0, 12.0, 14.0, 14.5, 14.5.1 |
GUI equivalent | notes.ini only (no GUI) |
Possible values | 0 = off, 1 = on |
Description
DEBUG_TASK_DETAIL extends the output of show tasks and writes additional detail information to the console during operation: among other things, the current processing step of a task (e.g. "Compacting database X", "Indexing view Y", "Replicating with server Z"), the associated database, runtimes, and handoff points. Very helpful for specifically analyzing "hanging" server tasks (Updall, Compact, Replica, AdminP, Router).Example configuration
DEBUG_TASK_DETAIL=1
Notes & pitfalls
- Takes effect immediately; no restart required.
- Noticeably increases the console volume – enable only temporarily on production servers.
- Pairs well with
Server_Show_Performance=1andDEBUG_TASK_TRACE.
- Provides no additional data for external DSAPI/add-in tasks without status reporting.