Common Criteria Compliance is only available in Enterprise, Developer and Evaluation editions. Yours is Standard edition.

common criteria compliance enabled Option

http://msdn.microsoft.com/en-us/library/bb326650.aspx

Ditto for EKM:

Understanding Extensible Key Management (EKM)

http://msdn.microsoft.com/en-us/library/bb895340.aspx

Correct, the [font="Courier New"]sys.dm_db_session_space_usage[/font] will include the session information you are looking for.

Example:

SELECT

session_id,

(SUM(user_objects_alloc_page_count)*1.0/128) AS ,

(SUM(internal_objects_alloc_page_count)*1.0/128) AS [internal object space in MB]

FROM sys.dm_db_session_space_usage

GROUP BY session_id

ORDER BY session_id;