DEFINITIONS

Definitions More Info.
Definition ID226
TitleSQL
CategorySCRIPT
Definitionthe most used query plans
Definition Descriptionselect TOP 100 objtype, p.size_in_bytes, LEFT([sql].[text], 100) as [text]
from sys.dm_exec_cached_plans p
outer apply sys.dm_exec_sql_text (p.plan_handle) sql
ORDER BY usecounts DESC
RecordBycunay
Record Date03-08-2012 10:13:05
Düzenle
Kopyala
Sil