Is there a way to see something like top SQL statements over the past 2 weeks that were run under one specific database ID? Basically taking the Top SQL report and filtering by DB_User?

Question

I am looking to find the top SQL statements over the past 2 weeks that were run under a particular database ID.  It seems like this should be easy to do, but I can't figure it out.  Anyone have ideas?

brianflynn · Answer

Hi cmartin2.  There is a custom report posted at the following thwack link that may be what you need.  Let me know if you have any questions.

Custom Report - Top SQL for Database User