????8????????????????????????????????????

USE AdventureWorks
GO
SELECT  *
FROM    Sales.SalesOrderDetail
WHERE   SalesOrderDetailID = 43659
GO

????9????????2????飺

SELECT  CP.usecounts AS CountOfQueryExecution ??
        CP.cacheobjtype AS CacheObjectType ??
        CP.objtype AS ObjectType ??
        ST.text AS QueryText
FROM    sys.dm_exec_cached_plans AS CP
        CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS ST
WHERE   CP.usecounts > 0
        AND ST.text LIKE '%SELECT  *  FROM    Sales.SalesOrderDetail  WHERE   SalesOrderDetailID = 43659  %'
        AND CP.cacheobjtype = 'Compiled Plan'
GO

????10????γ??????????????

??????????

???????2????????query_hash???????????????????????????м????????????????????е????SQLServer??????????????????query_hash??????????????м??????????????С???????y??????ε?????????????м?????????С??????????????????á???????ò?????κθ?????????????????????????

???????????￡???????в?????????????м?????????????????У??????????в???1??????????????????к???????棬???????е???????????????????С?????????????????????Σ??α???????????

??????Щ???????????GB????????????????????????????????漴?????????????????????????????

SELECT  SUM(size_in_bytes) AS TotalByteConsumedByAdHoc
FROM    sys.dm_exec_cached_plans
WHERE   objtype = 'Adhoc'
        AND usecounts = 1