dynamicsnavax: Creating SQL index via LCS
LCS has some really great tools for checking performance. Its really a matter of trying to get used to them and knowing whats available.
Under the Environment monitoring > SQL insights > Performance metrics.
You can find some slow queries and how they are affecting the environment over time.
I found that SalesLine table was missing an index for Revenue recognition.
Warning: Do this at your own risk.You could break the system if you haven't tested this properly.
I raised a support ticket but was asked to create a non-unique index on the table via LCS.
Go to Environment monitoring > SQL Insights > ActionsSelect "Create non-unique index on a table".
Turn of the "Allow page locks".
Talking about that risk.
I got an error after I did the above with batch jobs. I had to restart the batch service in LCS to fix the problem.
This is the error I got with batch job to post the sales invoices.
Refer to Microsoft Docs page on this. Typically you want to do this as part of your development but that would cause outage and delay the whole process. In this instance, I tried the above and got past the problem.
Note that there is a drop query. So, take note of the index name you created. Then you can delete it afterwards.
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
|dynamicsnavax: Analyse SQL performance issues using SQL Query Store for D365FO||Blog bot||DAX Blogs||0||07.11.2017 19:11|
|lcs: [Post Incident Review Report] SQL Server Integration Services license expiration||Blog bot||DAX Blogs||0||26.07.2016 02:17|
|Navigate Into Success: NAV performance part 4: SQL Azure||Blog bot||NAV: Blogs||0||15.05.2016 18:12|
|NAV Team: "CREATE USER" SQL Error when creating and Synchronising New User in Dynamics NAV 2009||Blog bot||Dynamics CRM: Blogs||0||24.04.2012 16:45|
|Nav developer: Beware the SQL Index property on NAV 5.0 SP1||Blog bot||Dynamics CRM: Blogs||0||10.04.2009 17:16|
|Опции темы||Поиск в этой теме|