There are two new system views and two system views that have new columns added in SQL 2014. Most notable is sys.databases since this is widely used.
–Configure query for profiling with sys.dm_exec_query_profiles
SET STATISTICS PROFILE ON
–Optionally return the final results of the query to SHOWPLAN XML
SET SHOWPLAN XML ON
–Next, run a query in this session
FROM RunningRoutes rt
CROSS JOIN RoadRaces race
WHERE [State] = ‘TX’
–Run this in a different session than the session in which your query is running.
–Serialize the requests and return the final results to SHOWPLAN XML
node_id,physical_operator_name, SUM(row_count) row_count, SUM(estimate_row_count) AS estimate_row_count,
CAST(SUM(row_count)*100 AS float)/SUM(estimate_row_count)
WHERE session_id=<<your session id>>
GROUP BY node_id,physical_operator_name
ORDER BY node_id
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.