I want to find a query

I've got a web app that has one command to find users that crawls. I'm sure it needs some index help.

I am looking for a way to identify the SQL query issued by the portal without sifting through lines of code.

The server is not busy weekends. Is there a SQL tool that will capture the query when I issue the command through the portal?

you could try

  1. SQL Profiler
  2. trigger on a specific table
  3. create a crawl table and add an insert statement in a stored procedure that is called from the portal

are some options we have used in the past