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 <[email protected]> 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/automatic-tuning?view=sql-server-2017 > > Malcolm > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMY+Az+RiWaBFLvpOU4HDO7M=zukfwxz7f+tfqxzeqmg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
