Behold the new live query stats in SQL Server 2016

Posted on Posted in Ikke kategoriseret

LiveQueryStatsWith the release of SQL Server 2016 also comes a great new feature to get a live view of the current execution plan for an active query.

This blogpost will cover the aspects of this new feature including:

  • Introduction
  • How to activate
  • How to use and read the output
  • Downsides – if any

Introduction

The introduction of live query plans are in the current release of SQL Server 2016 CTP 2.2 a new feature from Microsoft, which hopefully will be in the final release.

The feature provides real-time insights to the SQL Server engine’s query execution process. This in a visual matter when data flows from one plan operator to the next in the execution. The display will cover the usual elements of an execution plan – this including the number of rows handled, the time spend, progress of the single operators and other well-known statistics of a query execution.

Read more here: http://www.sqlshack.com/behold-the-new-live-query-stats-in-sql-server-2016/

Leave a Reply

Your email address will not be published. Required fields are marked *