Home > IT Answers > SQL Server > SQL Server profiler duration empty
Zsoelod
15 pts.
 SQL Server profiler duration empty
SQL Server, SQL Server 2005, SQL Server Profiler
Hi I choosed all events with starting and completed but still duration is empty, tried also by swithching to microseconds from tools/options, but still empty. any reasons for this? thanks Elod

Software/Hardware used:
sql server 2005
ASKED: August 4, 2011  4:12 PM
UPDATED: March 31, 2012  7:15 PM
RELATED QUESTIONS
Answer Wiki:
Only the rows for the completed event will have a duration. The starting events will never have a duration.
Last Wiki Answer Submitted:  August 4, 2011  6:04 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

ok ,thanks for your reply!
yes I assumed this also, I think I just did not notice the completed events among the starting ones since they were so few.. Now I choosed only completed ones and is fine .

Zsoelod
 15 pts.