Function Execution Count

• BSavoie

  SSCertifiable

  Points: 6309

  More actions

  September 20, 2011 at 1:37 pm

  #243424

  I need to find out how many times a table-value function has executed on my sql azure database. Any suggestions?

  thanks!

  .

• Grant Fritchey

  SSC Guru

  Points: 399059

  More actions

  January 5, 2012 at 6:41 am

  #1428973

  Take a look at the sys.dm_exec_query_stats DMO. You should be able to get a count from that assuming the statement is still in cache.

  "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