Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Report Searching for Query Text

Looking for documentation on how to create and run a custom query/report looking for any queries ran that contain a specific string. Our repository is in SQL Server.

Labels (1)
Tags (1)
0 Kudos
1 Reply
Level 14

You can try using the reporting in DPA to create something like in this description: DPA Report on Stored Proc Impacts

Just substitute in the string name for the SP name and it should find it in the SQL text. Just make sure it is unique enough so it won't pull in a lot of noise...

0 Kudos