Share via


SQL Server Availability Group: [hadrag] SQL Server component 'query_processing' health state has been changed from 'warning' to 'clean'

Question

Thursday, August 30, 2018 2:05 PM

why do we receive below error in AlwaysOn cluster ?

[RES] SQL Server Availability Group: [hadrag] SQL Server component 'query_processing' health state has been changed from 'clean' to 'warning' at 2018-08-16 01:08:50.450

[RES] SQL Server Availability Group: [hadrag] SQL Server component 'query_processing' health state has been changed from 'warning' to 'clean' at 2018-08-16 01:09:10.513

Jayant Kumar Das MS SQL Server DBA

All replies (4)

Friday, August 31, 2018 12:26 PM

A better forum for asking questions about SQL clustering is https://social.technet.microsoft.com/Forums/en-US/home?forum=sqldisasterrecovery.  That forum is the home of the SQL HA experts.

tim


Saturday, September 1, 2018 3:58 AM

Hi,

Thanks for your question.

Here's a thread discussed the similar situation as yours, please try the following detailed information for the first troubleshooting.

https://social.technet.microsoft.com/Forums/windowsserver/en-US/53cd2c37-e5e3-4fce-89aa-fbb7fb05c2c8/sql-server-availability-group-hadrag-sql-server-component-queryprocessing-health-state-has?forum=winserverClustering

Hope this helps. If you have any question or concern, please feel free to let me know.

Best regards,

Michael

Please remember to mark the replies as an answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected]


Monday, September 3, 2018 11:21 AM

Hi,

How are things going on? Was your issue resolved? 

Please feel free to let me know if you need further assistance.

Best regards,

Michael

Please remember to mark the replies as an answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected]


Sunday, September 9, 2018 7:36 AM

Hi,

Just want to confirm the current situations. 

Please feel free to let us know if you need further assistance.

Best regards,

Michael

Please remember to mark the replies as an answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected]