3 ms·
I'm running SQL Databases on Azure SQL, and it gives you recommendations to add indexes, and various other optimizations, that take 1 click to have happen. I g
by rjbwork 10y ago
I'm running SQL Databases on Azure SQL, and it gives you recommendations to add indexes, and various other optimizations, that take 1 click to have happen. I get an email, and I can have the index created via a link in my email.
It's pretty fantastic.
- blitzd 10y agoIt based on functionality that all exists in the traditional on-prem SQL Server as well - certainly not the e-mail and point a click creation, but you can definitely query SQL Server DMV's for missing index information[1]. As with any suggested indexes though, they have to be weighed against their effect on other workloads. Additional indexes can have a big impact on inserts / updates / deletes. [1] https://blogs.msdn.microsoft.com/bartd/2007/07/19/are-you-using-sqls-missing-index-dmvs/ https://blogs.msdn.microsoft.com/bartd/2007/07/19/are-you-us...
- rjbwork 10y agoDefinitely true - it can't be mindless, but it's nice that it's put in front of my face w/ no effort.