Not able to execute a query against multiple connections using 'New Server Group' option

[samirbehara-zz]

• SQL Operations Studio Version: 0.23.6

Steps to Reproduce:

When I create a 'New Server Group' and add multiple connections under it, I am not seeing an option to run a query against all the connections at a single go.

Executing a SQL Query against multiple servers at the same time was one of the biggest advantage of using Registered Servers feature in SSMS. This needs to be built into the Ops Studio to leverage the real power of the 'New Server Group' feature.

[kburtram]

@samirbehara thanks for opening this issue. This is on our roadmap as part of our "Multi-Server Management" scenario. We don't currently have an ETA when it will land. I'll update the issue once we have more concrete date commitments in this area.

[XPompeii]

+1

[UCSBMike]

+1

[redjungle]

+1

[amtwo]

The June 2019 release brings CMS support to Azure Data Studio, which is awesome. 👏👏👏👏👏

I use multi server queries heavily in conjunction with CMS. I think this is a pretty common use case to combine these two features (hopefully telemetry data from SSMS exists to support this?).

With CMS, I want to be able to select an arbitrary folder within the CMS & open a query window to execute queries against all target servers within that folder.

I'm not sure if this should be considered part of this issue, or split into a separate issue that would be done after this one. Happy to log something separately, if the MSFT team thinks that keeping it separate is more appropriate.

[ruudvandebeeten]

In order to move away from SSMS completely this feature has to be present for us.

[OSch24]

I'm of the same mind. That's the only reason I still have SSMS

[clansing-chr]

So I have the CMS extension. I realize it's in preview mode. I was able to setup a CMS with several registered servers, but how do I query all the servers at the sane time?

[danrayson]

When this occurs for me (Windows), I open a new Query Windows and run the query I wanted to in there instead. When I do that after a previous window has stalled, then I always get TWO responses from the query I run in the new window.

The response from the previous query is returned first, then the new query's results are returned.

This seems to me like ADS is waiting for the response from the first query, but effectively ignores it. Then, the second query kicks it in the butt and it returns both resultsets.

[ashwinimohan]

I am also desperately waiting for this feature to execute a query against multiple servers. Without this CMS feature, won't be able to switch to ADS ever. Looks it is still being worked upon. May we know any ETA if it is?

[ashwinimohan]

@kburtram Any ETA on this? This feature is really stopping us to move to ADS.

[iroquim-360]

please too; thanks

[ashwinimohan]

Any ETA on this please?

[tune007]

Beginning of 2022 I see the earliest post is in 2017, this is the only reason why I still have to jump back to SSMS sometimes. Can you please confirm what the status on this feature is please. I really enjoy using ADS instead of SSMS when working on code

[ishazel]

Likewise, this is the only reason I have to switch back to SSMS on occasion, a pretty jarring transition after the elegance of ADS :)

[ashwinimohan]

Any update on this? I desperately need this feature. It's the only thing which is stopping me to move to ADS completely.