Lucky for me that we are still on 2012 Enterprise and 2014 standard editions.
I cringe at this " or lets the Database Engine automatically fix performance problems."
I am afraid that it will 1. Generate the index at the WRONG TIME 2. Create many more indexes that consume a great deal of disk space because the tables have close to a billion rows. 3. We have a vendor supplied system and I have to follow their rules to keep our support costs down, hahahahahaha. 4. I would like to get notice on what the machine needs to do and schedule it in proposed downtime. 5. Working better with machines is the only way to advance looking forward, I just want to know when and what might be happening.
On Wed, Oct 10, 2018 at 10:03 AM Malcolm Greene profox@bdurham.com wrote:
For a taste of the future check out SQL Server 2017's index tuning recommendations and the Azure hosted version of SQL Server 2017 that can proactively implement these tuning recommendations on your behalf.
Automatic tuning
https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/a...
Malcolm
[excessive quoting removed by server]