14,494 questions
Since you say without 3:rd party tools, you have to write your own queries, using cross database and also linked server name references. There's nothing built-in for this.
centralized monitoring for Query store multiple server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,341
Reputation points
Are there any way (without 3rd party tools) to centralize the monitoring for querystore from multiple databases and across multiple servers
SQL Server Other
2 answers
Sort by: Most helpful
-
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2020-09-03T08:47:04.497+00:00 Hi @sakuraime ,
As TiborKaraszi said, there is no built in for this. I found a blog talking about POWERSHELL FUNCTION TO GET QUERY STORE DATA ACROSS MULTIPLE DATABASES, it not meet your requirement, but hope it could help you something.
Best regards,
Cathy-
sakuraime 2,341 Reputation points
2020-09-04T16:15:45.997+00:00 but afterwards, is it possible to gather in the same GUI dashboard ?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
tibor_karaszi@hotmail.com 4,316 Reputation points2020-09-05T12:22:06.833+00:00 No, the built-ini GUI in SSMS is done for just the one database you are currently looking at. You can of course create your own tables and import the data into them from several databases. If you now want to visualize that data, you have to write your own reports - possibly plug them into SSMS.
There might be stuff out there already for this, and I'm sure you are just as proficient and I am at searching the net, but nothing built into the product.
Sign in to comment -