SQL Server 2016 is going to include a new feature called Live Query. The first time I saw it, I thought it was awesome. But having thought about it a few days, I’m not so sure I will ever use it. Here’s why:

First of all, I almost never use Management Studio for reading execution plans. I use SQL Sentry Plan Explorer for my execution plan reading. They process the plan and give it to me with more useful information and in a much easier to read manner.

Secondly, this feels like a toy. It seems pretty, but I don’t foresee any real value to watching partial data come in, especially because the flows are not guaranteed to be correct. These numbers are still based on estimates (as far as I can tell), so we will see some weird scenarios with one expected row churning and churning.

As long as there’s no performance hit, I don’t mind having this available, but this doesn’t touch my top ten favorite new features in 2016.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s