Discussion on:

An introduction to SQL Server Profiler

Where is figure E?

Just click on the button and Figure E appears.

but here is a good article that gives you the meat which is what to trace and filter.
http://www.sql-server-performance.com/sql_server_profiler_tips.asp

http://www.sql-server-performance.com/sql_server_profiler_tips.asp

http://www.sql-server-performance.com/sql_server_profiler_tips.asp

Just remove the space from "tip s" in the link.

http://www.sql-server-performance.com/sql_server_profiler_tips.asp

The article clearly shows how to start a trace - what it doesn't say is:
1. what elements are interesting enough to make a performance difference.
2. how to read the trace results - and then apply specific improvements for performance.

I realize this is an introductory article by the title - however I think just a few more real-world examples with some instruction on what to do with the results would have been helpful.

Thanks,
Dan L

???????? trace SQL ??????????????????? Audit Login ??????? SQL : BatchComplete ??????? SQL: Complete ??????? Audit Logout ?????? step ?????????? ???????? Login ???? Logout ????

I don't see it listed with a brandnew install of SQL 2k5. Can anyone help me out on where to find it on the install CD's or online??

Sql Profiler is present in Sql server.Here i am using sql server2005,it already present in Sql server disk which has to installed at the time of installation.
In Sql server 2005,it present in "Tool" menu>>Select "Sql Server Profiler".After that u must have to login and then start the trace and performs some action.Here u can see whats the process/operation are going on database.
We can perform many operation by the profiler.

Thanks
Amol B.

Setting up and starting the trace was pretty painless. How do I read the trace? Are there any tutorials or links out there to help me make the trace useful?

Thank you