extended events rpc_completed duration does not matching with rpc_starting

• jandrewan

  SSC Veteran

  Points: 217

  More actions

  December 5, 2020 at 8:45 pm

  #3817353

  Does rpc_completed duration (micro_sec) = rpc_starting.timestamp - rpc_completed.timestamp? In my case, I saw a big difference between them. Duration is only few millsec, where rpc_starting.timestamp - rpc_completed.timestamp is 6 - 10 sec. I am on sql server 2016.

  

  • This topic was modified 4 years, 9 months ago by jandrewan.
  • This topic was modified 4 years, 9 months ago by jandrewan.

• Site Owners

  SSC Guru

  Points: 80381

  More actions

  December 6, 2020 at 9:10 pm

  #3817581

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Grant Fritchey

  SSC Guru

  Points: 399289

  More actions

  December 7, 2020 at 2:35 pm

  #3817828

  The duration only includes the time that the query ran on the server. It doesn't include any transfer times or waits at the start of execution.

  "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