April 15, 2015 at 3:19 pm
When you view the Extended Events "Watch Live Data" is the duration in milliseconds or microseconds? I'm assuming it's milliseconds, but if you look at the timestamp difference from start to complete it doesn't add up to the duration amount? It looks like it's just the difference between the timestamps?
April 16, 2015 at 6:04 am
Pretty sure it's microseconds on rpc_completed and sql_batch_completed. However, it does depend on which event you're looking at. Unfortunately, Microsoft has been inconsistent and hasn't documented well. Vote that up so that it gets more attention.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2015 at 10:19 am
I'm using sql_statement_started and sql_statement_completed. Microseconds would make sense. When you say "vote it up" where do you do that? Appreciate the help.
April 16, 2015 at 10:27 am
JP10 (4/16/2015)
I'm using sql_statement_started and sql_statement_completed. Microseconds would make sense. When you say "vote it up" where do you do that? Appreciate the help.
The "vote up" is in the connect item that Grant linked to in his comment.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2015 at 10:33 am
awesome thanks all.
April 16, 2015 at 11:46 am
Sorry I wasn't clear. What Jason said. They need to either make it consistent or give us good documentation.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply