DZone Database Zone
Runtime Metrics in Execution Plans
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re using SQL Server 2016 SP1 or better in combination with SQL Server Management Studio 2017. When you capture an actual plan using any method, you get the query execution time on the server as well as wait statistics and I/O for the query. This fundamentally changes how we can go about query tuning.
Runtime MetricsTo see these runtime metrics in action, let’s start with a query:
No comments:
Post a Comment