Post reply

Stored procedures access count

  • October 12, 2016 at 3:50 am

    #322098

    Is anyone knows how to calculate access count of stored procedure from server restart?

    Please share information if knows

  • October 12, 2016 at 3:53 am

    #1906064

    Without some custom monitoring or auditing, you can't.

    The procedure_stats DMV shows execution count since the procedure was last compiled, but that's all you can get, and last compile won't usually match with when the server restarted.

    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

  • October 12, 2016 at 4:17 am

    #1906067

    Thanks for sharing the information

  • October 12, 2016 at 6:22 am

    #1906089

    Set up auditing. You're in SQL Server 2014. You can use extended events. It won't help you now, but it will help you tomorrow and next week and...

    "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

Viewing 4 posts - 1 through 3 (of 3 total)

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