We can configure SSMS to run the query against multiple server simultaneously.
In SSMS, View –> Registered Servers
Create new Local Server groups folder called: AlwaysOnDemo and –> New Server Registration
Fill in the server connection info and save
Then we can run the query for all the servers in the group.
There would be additional column ‘Server Name’ in front of result sets .
whether include the server name in the result set can be configured through options