Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning SQL Profiler v/s Query window RE: SQL Profiler v/s Query window
ps.
One Orange Chip
Points: 29422
More actions
November 17, 2010 at 2:46 am
#1251750
Does your SP accepts parameters? If yes, pls modify the parameters to different sets of values and observe the time taken by it. is it same?
Profiler does nothing but gives you details of the SP which was invoked by a process or a user.