Debugging difference between "task time" and execution time for SQL query
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2024 11:35 AM
I have a pretty large SQL query that has the following stats from the query profiler:
Tasks total time: 1.93s
Executing: 27s
Based on the information in the query profiler this can be due to tasks waiting for available nodes.
How should I approach this to figure out where this is happening?
