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?