Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.0.0, 1.2, 1.5.3, 5.5.2, 5.6.2, 6.1.1
Description
Usually columnstore logs the start and end timepoint of a SQL statement.
Oct 26 12:44:44 D 21 CAL0001: Start SQL statement: |
Oct 26 12:48:12 D 21 CAL0001: End SQL statement |
The time between Start and End is not the processing time.
There are also waiting time for ressources.
You're tempted to find the error in the SQL statement himself,
but it could also memory issues, waiting for free requests
(MaxOutstandingRequests is reached), free memory,
wait for a table lock etc.
So it would helpful to add information for.
Which ressource is shortage ?
When the sql processing starts
Oct 26 12:44:44 D 21 CAL0001: Start SQL statement: |
Oct 26 12:44:44 D 21 CAL0001: Wait for free xxxxxx |
Oct 26 12:48:10 D 21 CAL0001: SQL Processing started |
Oct 26 12:48:12 D 21 CAL0001: End SQL statement |