Last month when installing a high available ConfigMgr infrastructure I received an error message. This message came when adding a second SMS Provider. Just have a look at this blogpost first: "How to install a multiple SMS Provider in ConfigMgr 2012". After installing the second SMS Provider everything seems fine, but after rebooting the server there was the error message. "The Status Viewer was unable to retreive the stored queries list from the data base".
Lucky me I found the following blogpost: "Unable to retrieve Configuration Manager 2012 Status Messages".
It mentions: You need to modify the startup type of the SMS Executive and Component Manager Services. Set the startup type to Delayed Start and then reboot the system after the change.
In this particular case the ConfigMgr Site server and SQL server were installed on different systems and the SMS Provider was installed on another remote system (second ConfigMgr Site server). By implementing the delayed start of these services on the Primary Site server everything seems fine again.
Hope it helps!