Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
muthu76
Starting Member
6 Posts |
 Posted - 2009-10-07 : 03:55:33
|
| Hi,how to execute Performance Monitor for below query in SQL Server Profiler in SQL Server 2005?SELECT d_case.c12_user_case_num, d_task.dt_original_open, d_task.dt_request_close, d_task.si_assignment_rec_type, d_task.c1_case_status, d_task.si_case_disposition, d_task.si_task_type, d_emp.c30_emp_last_nm, d_involved.c30_last_nm, d_involved.c15_first_nm, l_case_disp_status.c50_case_disp_status_descr, l_task_assign_type.c20_task_assign_descrFROM d_task INNER JOIN d_case ON d_task.i_case_id = d_case.i_case_id INNER JOIN d_involved ON d_task.i_case_id = d_involved.i_case_id INNER JOIN l_case_disp_status ON d_task.si_case_disposition = l_case_disp_status.i_case_disp_status_id INNER JOIN l_task_assign_type ON d_task.si_assignment_rec_type = l_task_assign_type.i_task_assign_type_id INNER JOIN d_emp ON d_task.i_emp_sys_id = d_emp.i_emp_sys_idWHERE (d_task.si_task_type IN (860, 4230)) AND (d_task.c1_case_status = 'C') AND (d_task.dt_request_close >= '1/1/1885') AND (d_task.dt_request_close <= '1/2/2009') AND (d_case.c1_ref_bus_grp_id = 'I') AND (d_task.si_case_disposition IN (34, 35, 37, 47, 51, 66, 67, 108, 45, 116, 117)) AND (l_task_assign_type.i_task_assign_type_id = 2) AND (d_involved.si_involved_type_id = 60)ORDER BY d_emp.c30_emp_last_nmThanksMuthuYes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
How to monitor the performance below query