Query execution time

• New persopn

  SSCarpal Tunnel

  Points: 4019

  More actions

  February 15, 2014 at 9:17 am

  #396274

  Hi everyone,

  We have faced the issue with application as this is working very slow as per the client request we need to capture the back end queries execution starttime and end time.

  how can we capture this using profiler. is there any another way to capture the query execution time.

  Thanks in advance

  vasu.

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  February 15, 2014 at 10:12 am

  #1689303

  You could use one of the templates. Here is a list and description of those templates.

  http://technet.microsoft.com/en-us/library/ms190176.aspx

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 15, 2014 at 11:41 am

  #1689313

  https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass