Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Maintenance on Tier 2 ...
Finance forum

Maintenance on Tier 2 Environments - SQL indexing etc.

(2) ShareShare
ReportReport
Posted on by Chris R Tilley 339

Hi All,

While I was waiting for a task to finish I got to considering Tier 2 environment maintenance, as I'm seeing more and more shouts of "It is slower on the acceptance environment than the cloud hosted!"

Whilst the Tier 2 Environment a customer gets with their D365FO licenses is in Microsoft's Azure subscription they don't actually manage it as intensively as production.  They're not looking for locks at all, and I have been told by a support engineer that index maintenance is on the Partner/Customer as well.  After a quick look it seems that setting up index maintenance when the Azure DB is in a different tenant to you is quite a challenge! 

I was looking for a discussion on what people do on their Tier 2 environments, what are you doing? 

Seems like something like the below could be a requirement: 

https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/07/03/how-to-maintain-azure-sql-indexes-and-statistics/

but it seems you can only automate this using Azure, and the Tier 2 environments are 'MS Managed'.  Has anyone tried doing the following with a Tier 2 Database, can you even see it? 

https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/01/15/automating-azure-sql-db-index-and-statistic-maintenance-using-azure-automation/ 

Thoughts/Comments/examples welcome! 

Chris 

Categories:
Other
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at
    RE: Maintenance on Tier 2 Environments - SQL indexing etc.

    It is an LCS tooling which is usually version independent. However, the platform update version might be relevant here. The release announcement did not mention anything about the minimum version: blogs.msdn.microsoft.com/.../lcs-september-2018-release-notes

  • Chris R Tilley Profile Picture
    Chris R Tilley 339 on at
    RE: Maintenance on Tier 2 Environments - SQL indexing etc.

    Thanks for response André.  I had a look in the Index Maintenance form on this Tier 2 environment and no data was collected. Do you happen to know if there is any minimum version for the D365FO instance to support this new feature?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at
    RE: Maintenance on Tier 2 Environments - SQL indexing etc.

    Hi Chris,

    As of recently, you are able to monitor index fragmentation and act on it. If there is a need to do mass re-indexing, you can try to create a request for the Dynamics Service Engineers. Microsoft is actually working on better solution for the future.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,013 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans