This metric will display the percentage of queries on the server that are ad-hoc queries. A high percentage of ad-hoc queries can indicate that an application is running queries that are not properly parameterized.Percentage of ad-hoc queries,
Percentage of ad-hoc queries
This metric displays the percentage of queries being run on the server that are ad-hoc queries.
The T-SQL query that will collect data
Instances to collect from
Databases to collect from
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
An alert can be set for this metric once a baseline has been established.