Post reply

confusion with DMV sys.dm_exec_procedure_stats execution_count database id

  • May 24, 2014 at 11:05 pm

    #307644

    Hi, we have a separate database for each of our clients. All the databases are identical meaning they have same table names and same stored procedures. When I look at sys.dm_exec_procedure_stats, does the execution_count mean the cumulative count per database or across all databases? This DMV also has database id, last_execution_time etc. Are all these values are per database id?

    Thanks,

    Sridhar.

  • July 16, 2014 at 6:46 pm

    #1730078

    The below might help:

    http://social.technet.microsoft.com/Forums/sqlserver/en-US/80a377cf-ae63-4b0c-a00e-170f04c17c8c/find-database-and-table-from-object-id?forum=transactsql

    Books online mentions the proc as "Returns aggregate performance statistics for cached stored procedures" Caching in RAM is a free for all thus anything in there would have the metadata to know precisely where it came from in SQL Server (includes the database) . Without digging to deep I would venture it is per database.

    ----------------------------------------------------

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

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