Hi,

I know that in Oracle there is a trace script that you can start right
before the user runs a query (tracestart) including the id and the
computername-instance, and when the query has run, you use traceend to
produce a file - report that tells you where the maximum load was, and the
tables were accessed, and so on so later you can inprove the query syntax.
Is there something similar in SQL? Also can you provide examples?

Thanks,

Check the SQL Profiler topics in MSDN at
http://msdn.microsoft.com/library/de..._perf_86ib.asp.
Profiler is a tool that enables you to create the traces and save the
results in a file or a table. You can create and start traces
programmatically as well. The easiest way is to create them using Profiler
and then saving them into a script file.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

"dimitris" <dimitris (AT) microsoft (DOT) com> wrote

Also have a look at

http://www.sql-server-performance.co...filer_tips.asp
http://www.sqlteam.com/downloads/PAS...edProfiler.ppt

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"dimitris" <dimitris (AT) microsoft (DOT) com> wrote