Monitoring function performance stats

• robin.pryor

  SSCrazy

  Points: 2583

  More actions

  March 23, 2018 at 1:39 pm

  #403204

  SQL 2008 and up has sys.dm_exec_procedure_stats
  As of 2016, we now have sys.dm_exec_function_stats

  My question - is there a way to achieve what's in sys.dm_exec_function_stats in a pre-2016 SQL? Is there another way to skin this cat?

  I need to add a panel to splunk, but not all of my servers are 2016. Most are not and there's nothing I can do about that.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 23, 2018 at 2:25 pm

  #1984465

  It's just, afaik, a filtered view of sys.dm_exec_query_stats.

  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