https://mssqlfun.com/2013/04/08/dmv-5-queries-runing-are-adhoc-or-proc-single-or-multi-use-sys-dm_exec_cached_plans/
DMV-5 : Queries runing are adhoc or proc , single or multi use ?........sys.dm_exec_cached_plans