Thomas Segato
Reputation: 5257
Analyze query in database tuning advisor disabled
This is disabled in SQL Server Management Studio. It's an Azure database - is this not supported or am I missing something to use this option?
Upvotes: 0
Views: 442
Answers (1)
Sunil Nepali
Reputation: 62
In case of azure index are constantly observed. If performance degrades it will recommend to create index. But in case of duplication or unusability of indexes for upto 93 days, it is recommended to delete the index.
Upvotes: 1
Related Questions
- SQL Server 2012 Analysis Services mode
- Database Engine Tuning Advisor Crashes Constantly
- SQL server Data Tuning Advisor error
- Where is the SQL Query Analyzer in SQL Server Management Studio 2012
- Sys.dm_db_missing_index_details and Advisor
- SQL Server Tuning Advisor - Statement does not reference any tables
- database engine tuning wizard "apply recommendations" is disabled
- Database Tuning Advisor - Why does it give me no results?
- Query Designer toolbar grayed out?
- Sql server tuning advisor report