SQL Server profiler duration empty

15 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

Only the rows for the completed event will have a duration. The starting events will never have a duration.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Zsoelod
    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 .
    15 pointsBadges:
    report
  • Zsoelod
    [...] 9. Check out Mrdenny’s approved answer for help when your SQL Server profiler duration is empty. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following