Skip to main content
Dynamics 365 general forum
Unanswered

D365 SQL Maintenance Plans

editSubscribe (0) ShareShare
ReportReport
Posted on by 30

HI All,

I am pretty new to D365 and I wanted to know if there are any kind of maintenance plans/scripts that can be used for D365? Or is it a case using the similar plans that were done on AX2012/2009 via SQL?

I have come across Ola Hallengren SQL scripts for maintenance located below:

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

And the environments themselves are handled via LCS so updating them to the latest platform isn't the problem. 

Any suggestions or advice on this would be great!

Attachments
  • RE: D365 SQL Maintenance Plans

    Hi ASB 

    SQL insight in LCS is helpful for you to check and maintain the performance of SQL in your D365FO.

    The following links are providing the topic of the feature and tips for performance troubleshooting.

     

    Monitoring and diagnostics tools in Lifecycle Services (LCS) - Finance & Operations | Dynamics 365 | Microsoft Docs

    Performance troubleshooting using tools in Lifecycle Services (LCS) - Finance & Operations | Dynamics 365 | Microsoft Docs

     

    And you might not be able to SQL script for AX2012/2009 for D365FO because D365FO is different from AX and it is online....

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans