Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 12.11.2020, 02:16   #1  
Blog bot is offline
Blog bot
24,225 / 809 (75) +++++++
Регистрация: 28.10.2006
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
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 18:25.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.