SELECT TOP 50
        qs.execution_count
		,OBJECT_NAME(objectid)
        ,query_text = SUBSTRING(
					qt.text,
					qs.statement_start_offset/2,
					(CASE WHEN qs.statement_end_offset = -1
						THEN len(convert(nvarchar(max), qt.text)) * 2
						ELSE qs.statement_end_offset
						END - qs.statement_start_offset)/2)
		,qt.dbid
		,dbname = db_name(qt.dbid)
		,qt.objectid
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt
ORDER BY qs.execution_count DESC

• most executed queries
• find most executed queries sql server
• most executed query sql server 2008
• SQL Server frequently executed queries
• how to know the most executed queries