Notifications
Announcements
No record found.
Hi,
Is there any tips to tuning performance on Tier 2 SQL? I can RDP to the AOS server and open Management Studio from there, but it is very different from the SQL Server. Can I install DynamicsPerf on Azure SQL?
Thanks,
Hi Yuji,
Have you checked the tools provided by LCS under monitoring environment?
Also, what kind of information you want to get?
You can't install anything on top of the MS managed databases. You will find diagnostics information in LCS as Sergey mentioned.
Tier 2 is not a very performant system - just to set the expectations.
Do you have some specific issue that you are troubleshooting?
I would like to do some basic index tuning, for example, index defrag, or query plan tuning.
As mentioned, you can read this Microsoft Doc:
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/querycookbook
But, it looks like you know it and mentioned it in your previous thread：
https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/369937/how-to-access-sql-server-on-tier-2-or-tier-4-environment
By "tuning" do you mean "get information" or "make changes"?
Please check LCS Environment monitoring for diagnostics information about the system and SQL queries. Anyway in prod you don't have any access to the database so it's good to adjust your processes to work with the cloud world.
You can also rebuild indexes via LCS, and even create new indexes if there is some critical prod performance issue that can be solved with a new index.
There is also watchdog in PROD which is creating missing indexes automatically.
Of course, you need to design solutions accordingly and plan which indexes should be created.
Tier2 environment is not the best place for performance tuning. But if you still want to use it don't forget to take a fresh backup from PROD before you start doing it.
About defragmentation: there is a built-in defragmentation job in D365 and also watchdog in PROD which is running defragmentation and statistics update from time to time.
I would suggest you start from queries from LCS in PROD to understand what queries are causing performance issues and from the report, you can get query plan id and download it (via LCS again) for further analysis.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 669 Super User 2025 Season 2
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 384 Most Valuable Professional
