Hi Gail,

I am doing fine with the part 1 to capture the queries and store procedure, i already have the procedure Name ( i use a test database to try out the procedure)

example: msdb.dbo.sp_sqlagent_get_perf_counters

How to examine the queries statistics and execution plan from it? Because i have no idea what the code for procedure looks like. Is it procedure refer to TextData column like what we obtain during part 1?

Regards,

Chungb