IF EXISTS(SELECT * FROM sys.server_event_sessions WHERE name='ExecCount_SPName')
    DROP EVENT SESSION ExecCount_SPName ON SERVER;
CREATE EVENT SESSION ExecCount_SPName
ON SERVER
ADD EVENT sqlserver.sp_statement_starting
(    WHERE (source_database_id = 12
	AND object_id = 176807727))
ADD TARGET package0.synchronous_event_counter
GO

ALTER EVENT SESSION ExecCount_SPName
ON SERVER
STATE=START
GO

SELECT tab.name,
    n.value('../@name[1]', 'varchar(50)') as PackageName,
    n.value('@name[1]', 'varchar(50)') as EventName,
    n.value('@count[1]', 'int') as Occurrence
FROM
(
SELECT s.name, CAST(target_data AS XML) as target_data
FROM sys.dm_xe_sessions AS s 
JOIN sys.dm_xe_session_targets AS t 
    ON t.event_session_address = s.address
WHERE t.target_name = 'synchronous_event_counter'
    AND s.name 'ExecCount_SPName'
) as tab
CROSS APPLY target_data.nodes('CounterTarget/Packages/Package/Event') as q(n)

CREATE PROCEDURE SelectTableA
AS
BEGIN
    SELECT * FROM TableA;
END
GO