I am testing out SQL 2016 Live Query Stats in SSMS and every time I try it I get the error "An error occurred while executing batch. Error message is: One or more errors occurred." and no result set is returned. A co worker has tried it and it works fine for him anyone else had this problem?
UPDATED To answer the questions raised. This is the entire error that is returned to the message tab. To reproduce all you need to do is select Live Query Stats in SSMS 2016 and run any query and I receive this error.
I've been encountering this error suddenly this week. I note that using Live Query Statistics executes successfully once, then fails with the referenced error on every subsequent execution. This may explain why co-workers were able to successfully execute the command.
My solution (workaround) is to not use Live Query Statistics and simply enable the Actual Execution Plan instead. I'd be grateful if someone knows what the root cause of this error is so that either option could be used as required.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With