Include SQL comments in Top Queries search
I use Entity Framework Core to interact with a SQL Server database, which comes with the ability to "tag" queries with extra searchable information for troubleshooting purposes.
This extra information is in the form of SQL comments, like so:
-- SPARK: PartyRepository.PartySearch
It would be very valuable to be able to search for this data, but unfortunately it appears that comments are excluded from Top Queries search, even though the data is there in SQL Monitor query data.
Eric King
shared this idea
-
Eric King
commented
I have since learned that the Top Queries search *will* include comments that are inline within the "SQL Query Fragment", just not comments added before the SQL begins, as Entity Framework query tags work.
So, I would like to clarify my request to:
I would love to be able to search the Top Queries based on content in comments in the Full Query, and not just the SQL Query Fragment.
That way redgate Monitor will be compatible with EF Core query tags.