Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL 2016 Live Query Statistics Error: "An error occurred while executing batch. Error message is: One or more errors occurred."

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.

like image 657
tbdevmanager Avatar asked Oct 30 '22 01:10

tbdevmanager


1 Answers

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.

like image 82
kad81 Avatar answered Dec 16 '22 23:12

kad81