When trying to Run the Top Queries report getting error as below.
Its SQL 2016. Other sql servers are returning top queries but some are returning below information.
Kindly, Please advise.
This typically means that there's no query data captured for the specified instance. In order to capture query data, please make sure you have Query Monitor enabled for the selected instance. You can check the Query Monitor settings in the Monitored SQL Server Properties window. On the Servers view, right-click on the instance name from the tree and select 'Properties'.
Query Monitor is enabled for the Instance in Question. Thanks.
It is possible that SQLDM might be having problems processing the data or that the extended event files are corrupted on the monitored instance (which would also cause problems in processing the data). You have a couple of options here.
Powered by IDERA