Can PE post results as they occur?

While running a long, complicated query (Actual plan), I notice that PE does not update the actual stats as the query runs. Can this be enabled? The idea is to be able to monitory progress through the query and to see where it is at.

Plan.pesession (432.2 kB)
avatar image By gbritton 93 asked Sep 19, 2016 at 02:46 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Sep 19, 2016 at 02:50 PM

Did you try using live query profile? This will show data flowing between operators, and each operator will indicate % of estimates processed at least. If your estimates are way off, then it's harder for us to know what % is complete until the query is finished (if you estimate 1,000 rows and we reach 1,001, we don't know yet if we'll see 1,002, 10,002, or 6 billion - but we continue updating the % of processed vs. estimate).

avatar image gbritton Sep 19, 2016 at 03:00 PM

I thought that was limited to SQL Server 2014 and up? I'm running 2012. Maybe this should be a feature request. The idea is to show in the results window the progress so far. Like actual rows and which part of the query is currently being executed.

avatar image Aaron Bertrand ♦ Sep 19, 2016 at 03:03 PM

You're right, it is, I didn't know you were using 2012. We get the data processed from a DMV that was added in SQL Server 2014 SP1. I don't know if there's a simple way for us to know how many rows have been processed without that DMV.

avatar image gbritton Sep 19, 2016 at 03:16 PM +

So when I'm running a long query, I see the actual rows increasing. Is that a guestimate?

avatar image gbritton Sep 19, 2016 at 03:05 PM

too bad. Is there a way for you to see what statement is being processed at the moment to indicate overall progress through the query?

avatar image Aaron Bertrand ♦ Sep 19, 2016 at 03:20 PM

No, I think there is some intentional synchronization at the end of the batch simply so we can do things like accurately show relative costs between statements in the batch.

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x455
x117
x39

asked: Sep 19, 2016 at 02:46 PM

Seen: 88 times

Last Updated: Sep 19, 2016 at 03:30 PM