Finding list of queries ran

[CylonLove4Life]

Is there anyway I can see a log of which queries ran, and how long they took, or at least the slow ones?

Preferabbly, I'd like to do this remotely via the command line.

 

[MDXer]

you can use profiler to capture queries ran and performance. SQL ships with a template trace that captures the exact info you are asking for.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[CylonLove4Life]

Thanks. What is the command to run this? Can it be run remotely?

 

[MDXer]

it isn't a command it is one of the SQL Tools installed. Yes it can be ran against a remote server as long as the account you login to the SQL server with has SA rights.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck