Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Number of executions is showing 0 when there are operator executions #33

Closed
Jorriss opened this issue Apr 25, 2017 · 1 comment
Closed

Number of executions is showing 0 when there are operator executions #33

Jorriss opened this issue Apr 25, 2017 · 1 comment
Assignees
@JustinPealing
Labels
bug
Milestone
2.0.2

Comments

@Jorriss
Copy link
Contributor

Jorriss commented Apr 25, 2017

In a pasted plan, the number of executions for an operator shows 0

image

In other tools, it shows the correct number

image

The plan can be viewed at: https://learnfrom.brentozar.com/pastetheplan/?id=S1uLgYf0l
@JustinPealing JustinPealing self-assigned this Apr 26, 2017
@JustinPealing JustinPealing added this to the 2.0.2 milestone Apr 26, 2017
@JustinPealing
Copy link
Owner

The number of executions is taken from the RuntimeInformation/RunTimeCountersPerThread element. There are in fact multiple of these elements (one per thread), however html-query-plan just uses the first one, hence the incorrect value.

The correct value can be found by summing the actual executions over all elements - the "Actual Rows" tooltip property suffers from the same issue (#34)

JustinPealing added a commit that referenced this issue Apr 26, 2017
@JustinPealing
Fix #34: Number of Rows may be incorrect
8a756b8 
As with #33, there may be multiple RunTimeCountersPerThread elements, in which case we need to sum the @ActualRows attribute to get the correct value.
@JustinPealing JustinPealing mentioned this issue Apr 27, 2017
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@JustinPealing JustinPealing

Labels
bug
Projects
None yet
Milestone
2.0.2
Development

No branches or pull requests
2 participants
@Jorriss @JustinPealing