Simon Whiteley
My feedback
-
199 votes
Simon Whiteley supported this idea ·
-
2,526 votes
Simon Whiteley supported this idea ·
-
133 votesunder review · 6 comments · Azure Synapse Analytics » SQL/T-SQL · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Simon Whiteley supported this idea ·
We're currently hitting an issue with this one - we're using the workaround query you've got above you rowcount logging, but we're running lots of procedures in parallel which each kick off a stats rebuild. The stats rebuild FLOODS the sql_requests table and forces to be aged out before we've had a chance to get their rowcount.
A rowcount solution that is susceptible to a race condition isn't a good solution especially, as mentioned, the query window displays the rows updated so the metadata must be available somewhere!
Hoping this gets sorted soon...
Simon