Definitions More Info.
Definition ID	922
Title	SQL
Category	NOTES
Definition	Queries type- ad hoc, prepared,procedure,trigger
Definition Description	https://social.msdn.microsoft.com/Forums/sqlserver/en-US/47d44d7f-7422-4137-98ab-1c8160563395/quotcachestoresqlcpquot-using-11gb-in-whole-sql-server-memoryhow-to-resolve-from-memery?forum=sqldatabaseengine select TOP 100 objtype, usecounts, p.size_in_bytes/1024 'IN KB', 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
RecordBy	cunay
Record Date	19-03-2019 18:13:37
Düzenle
Kopyala
Sil