Post reply

find total amount of procedure cache (In GB) used by a stored procedure

  • April 2, 2013 at 9:36 am

    #291836

    Is there a way i can find total amount of procedure cache (In GB) used by a particular stored procedure? This would be on SQL 2005 and 2008.

  • April 2, 2013 at 10:02 am

    #1602874

    With the exception of different set options, a procedure will only have a single plan in cache at a time, so measured more likely in kB than GB.

    Query sys.dm_exec_cached_plans, cross apply to sys.dm_exec_query_plan and filter on the object id.

    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