How do i use SQL profiler to create a trace for 1) stored proceduress. 2) tables that need to be indexed properly.

-- Anonymous, June 21, 2001

Answers

Bharadhwaj,

Reading between the lines, it sounds like you have an application that has some poor performance. SQL Profiler can assist you by helping to identify the stored procedures and statements within stored procedures that are taking an inordinate amount of time to execute.

You should start out by creating a trace that records the duration of stored procedures and statements within them. You can do this by selecting Stored Procedures/SP:StmtCompleted and TSQL/SQL:StmtCompleted from the Events tab of the Trace Properties dialog that appears when you select File/New/Trace. You may also want to add a filter to only capture the events that are longer than a threshold duration by filling in the Duration/Greater than or equal box on the Filters tab.

You will then want to investigate the slow running statements to determine if an additional index could increase performance. The tool to assist with that is the Index Tuning Wizard.

Good Luck,

Eric

-- Anonymous, June 27, 2001