Post reply

Monitoring function performance stats

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply