You want to identify the top 10 queries in SQL Server that have been recompiled the most times on your server. What can you do?
Use the sys.dm_exec_requests dynamic management view.
Use the sys.dm_exec_sessions dynamic management view
Use the sys.dm_exec_query_stats dynamic management view
Use the sys.dm_exec_query_optimizer_info dynamic management view