TheMicrosoft SQL Server Query Analysisdashboard provides details about Queries in your Microsoft SQL Server environment. Select a Server Instance from the widget on the left to populate the related top slowest Queries on the right. Select one of the Queries from the heatmap to view the selected query text and performance metrics.
Microsoft SQL Query resources are obtained on each collection. The queries are then limited by the adapter setting and only the top number of queries are added to vROps. If a query is obtained in one collection and then not the next it will likely show as not collecting and turn grey in the dashboards.