I have a sql query which has multiple joins and uses a view which has multiple joins.I captured the query in sql profiler and i see few information in there. I am trying to understand whether the query is a long running or long waiting query. Details:
- query runs in parallel.
- Has 40 logical CPU.
- CPU column : 156595
- Duration column : 45373
I am trying to understand if the query spend more CPU time or not.?Since the query runs parallel ,i am not sure what this high CPU time shows.