Wednesday, March 7, 2012

Is there any tools to collect the sql statment run information and run log?

For our coming performance tuning and trace which happen on some query is so
slow, we need to collect all sql statements run and time spending to run
log. Is there any tools help we to collect it?
SQL Profiler (Start\Run\Microsoft SQL Server 2005\Performance Tools)
If it's not there, then install Client Tools\Management Tools from the SQL
Server media.
Ekrem nsoy
"ABC" <abc@.abc.com> wrote in message
news:OiQPVjKOIHA.3940@.TK2MSFTNGP05.phx.gbl...
> For our coming performance tuning and trace which happen on some query is
> so slow, we need to collect all sql statements run and time spending to
> run log. Is there any tools help we to collect it?
>
>

No comments:

Post a Comment