compare query metrics across instances
I would like to be able to compare query metrics across SQL Server server instances.
We have a number of environments - Dev / QA / UAT / Production
the data generally increases in volume and gets more "real" the further up the chain we go which can mean something that performs well against the "small data" on the dev server can become an issue when it hits UAT which has real volumes of data
It would be useful to be able to compare a query across instances so if we release a feature which comprises of a number of SQL queries and one of those SQL queries performs poorly on live, but has been acceptable on other environments, it would be useful to compare query historys (those seen in the server overview page) to the query histories on one or more of the other environments (each environment has its own SQL Server instance)