Select DB_Name(dest.[dbid]) As 'databaseName'
, Object_Name(dest.objectid, dest.[dbid]) As 'procName'
, Max(deqs.last_execution_time) As 'last_execution'
From sys.dm_exec_query_stats As deqs
Cross Apply sys.dm_exec_sql_text(deqs.sql_handle) As dest
Where dest.[text] Like '%SP_FAST_Style_Colors%' -- replace
And dest.[dbid] Is Not Null -- exclude ad-hocs
Group By db_name(dest.[dbid])
, Object_Name(dest.objectid, dest.[dbid])
Order By databaseName
, procName
Option (MaxDop 1);
, Object_Name(dest.objectid, dest.[dbid]) As 'procName'
, Max(deqs.last_execution_time) As 'last_execution'
From sys.dm_exec_query_stats As deqs
Cross Apply sys.dm_exec_sql_text(deqs.sql_handle) As dest
Where dest.[text] Like '%SP_FAST_Style_Colors%' -- replace
And dest.[dbid] Is Not Null -- exclude ad-hocs
Group By db_name(dest.[dbid])
, Object_Name(dest.objectid, dest.[dbid])
Order By databaseName
, procName
Option (MaxDop 1);
No comments:
Post a Comment