This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
Are there any way (without 3rd party tools) to centralize the monitoring for querystore from multiple databases and across multiple servers
![](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)
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.
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
but afterwards, is it possible to gather in the same GUI dashboard ?
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.