Azure SQL Database
An Azure relational database service.
6,305 questions
Automatic tuning is not creating indexes on our SQL database
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 28.999999999999996%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kevin Hannan
6
Reputation points
We have automatic tuning turned on with Create Index ON, but it no longer creates indexes like it used to.
Azure SQL Database
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva 4,480 Reputation points Microsoft External Staff Moderator2025-06-04T22:46:18.1+00:00 Hi Kevin Hannan,
Greetings!
Could you please share the full error message you saw, or a screenshot if that’s easier? This will help us understand what’s going on and assist you better.
-
Kevin Hannan 6 Reputation points
2025-06-05T13:12:46.46+00:00 I am not getting any error messages, there is just nothing under Performance History > Tuning Recommendations. It just says "There are currently no operations to display. Once you apply a recommendation, its status will be displayed here."
We previously would have several indexes being tested and verified all the time and the automatic tuning has made many indexes in our database. It is no longer recommending indexes and only does "Force Last Good Plan".
-
Mahesh Kurva 4,480 Reputation points Microsoft External Staff Moderator
2025-06-05T20:45:37.3266667+00:00 Hi Kevin Hannan,
Thanks for the response.
Here are a few steps you can take to troubleshoot this issue:
- Double-check that automatic tuning is still enabled and configured correctly. Sometimes settings can be inadvertently changed.
- Ensure your database system is up-to-date. Updates can sometimes affect how features like automatic tuning operate.
- Look at the system logs for any warnings or informational messages that might give clues about why index recommendations have stopped.
- Consider if there have been changes in your database activity or workload. If the workload has become more stable, there might be fewer opportunities for index recommendations.
- If all else fails, consider disabling and then re-enabling the automatic tuning feature. This can sometimes reset the internal state and allow it to start making recommendations again.
- Review the latest documentation for your database system to see if there have been any changes to how automatic tuning works.
If the above options don't work, please share the request details in a private message.
I hope this information helps. Please do let us know if you have any further queries.
-
Kevin Hannan 6 Reputation points
2025-06-06T00:23:52.4333333+00:00 None of the above helped. What details would you like? Also, how do you send a private message?Never mind, I see the private message now
Sign in to comment
Sign in to answer