I have used Index Advisor and created an index. It works perfect and lower my DTU. Thank you for that you SQL-guys at Microsoft.

But, can someone explain this data in detail that I get from the Portal, it is the "Index Detail"-blade in Index Advisor. And why is some data N/A?

Actual impact

• Reported space usage increase N/A
• Duration of index creation N/A
• Improved queries count 5
• Regressed queries count 6

Regards,

Kent

• Edited by KentACar Tuesday, September 01, 2015 9:19 PM

Hello Kent,

Glad to hear that Index Advisor is working well for you!

The fact that these fields are showing as N/A is a defect in Index Advisor - the team is working on fixing this, and it will go away soon.

Thanks for bringing this issue to our attention, and please keep the feedback coming!

Vladimir

• Marked as answer by Casey KarstMicrosoft employee, Moderator 15 hours 42 minutes ago

Hello Kent,

Glad to hear that Index Advisor is working well for you!

The fact that these fields are showing as N/A is a defect in Index Advisor - the team is working on fixing this, and it will go away soon.

Thanks for bringing this issue to our attention, and please keep the feedback coming!

Vladimir

• Marked as answer by Casey KarstMicrosoft employee, Moderator 15 hours 33 minutes ago

Hello Kent,

Glad to hear that Index Advisor is working well for you!

The fact that these fields are showing as N/A is a defect in Index Advisor - the team is working on fixing this, and it will go away soon.

Thanks for bringing this issue to our attention, and please keep the feedback coming!

Vladimir

• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, September 09, 2015 3:33 PM

Thank's. That is enough for me.

Regards,

Kent