Sometimes we needs to find out the last executed commands on the database server.
Below is the SQL script share by one of my friend Ken Watson to find out the last executed queries.
SELECT usecounts, cacheobjtype, objtype, text
FROM sys.dm_exec_cached_plans
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
WHERE usecounts > 1
ORDER BY usecounts DESC;
About Ken
He is working as SQL DBA.
Blog:- interflextech.com/blog
Twitter:- @interflextech
Below is the SQL script share by one of my friend Ken Watson to find out the last executed queries.
SELECT usecounts, cacheobjtype, objtype, text
FROM sys.dm_exec_cached_plans
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
WHERE usecounts > 1
ORDER BY usecounts DESC;
About Ken
He is working as SQL DBA.
Blog:- interflextech.com/blog
Twitter:- @interflextech
