Search code examples
sql-serverdatabase-administrationsql-server-2016

SQL Server 2016 Live Query Statistics greyed out


Regardless of the type of query I'm running, the Include Live Query Statistics option is always greyed out.

Any idea how I can enable this?

enter image description here


Solution

  • Q:

    What is output of SELECT @@VERSION ?

    A:

    SELECT @@VERSION gives Microsoft SQL Server 2012 (SP2-GDR). However, Help > About gives Microsoft SQL Server Management Studio 13.0.16106.4

    In this case, SQL Server Management Studio 2016 is used to connect to SQL Server 2012 Database Engine instance. The minimum Database Engine version for Live Query is SQL 2014 SP1.

    Reference: http://blogs.lobsterpot.com.au/2015/08/31/live-query-statistics-in-sql-2014-not-just-sql-2016/