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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 25.11.2015, 00:13   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: How to proactively avoid parameter sniffing step-by-step
Источник: http://blogs.msdn.com/b/axsupport/ar...p-by-step.aspx
==============

In the following blog post the so called „parameter sniffing“ is explained:
http://blogs.msdn.com/b/axinthefield...lain-evil.aspx

The purpose of this blog post is to explain the fix implementation steps a little more in detail:

Notes:

The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I'd therefore recommend to install the latest kernel which you can always find here:
http://blogs.msdn.com/b/axsupport/ar...d-numbers.aspx


If you like you may find more useful information about kernel updates in general here:
http://blogs.msdn.com/b/axsupport/ar...-hotfixes.aspx


Like for every kernel installation please be aware of this:

- The following steps should be tested in a test environment first before doing that in the production environment in order to make sure that the updated kernel works as expected in your specific, customized environments.

- If you update the kernel then all AX clients and all AOS servers have to be updated in a unique manner per environment.



1) Make sure you downloaded the latest kernel


2) Install the kernel via running axupdate.exe that comes with the kernel hotfix itself. (Note: Or take the latest axupdate.exe from LCS (https://lcs.dynamics.com )if you run AX 2012 R3 CU 8 or higher)  

Please also make sure to take the following hints into consideration here in general and depending on your MS Dynamics AX version:
https://technet.microsoft.com/en-us/.../hh538446.aspx


3) After the kernel installation please make sure that all of you AOS service(s) are stopped.


4) Run the following T-SQL query against your MS Dynamics AX transaction database using SQL server management studio depending on your MS Dynamics AX version:

AX 2009 SP 1:
UPDATE SQLSYSTEMVARIABLES SET VALUE = '1' WHERE PARM = 'DATAAREALITERAL'

AX 2012 R1 (=RTM)
UPDATE SYSGLOBALCONFIGURATION SET [VALUE] = 1 WHERE NAME = 'DATAAREAIDLITERAL'


AX 2012 R2 and AX 2012 R3
UPDATE SYSGLOBALCONFIGURATION SET [VALUE] = 1 WHERE NAME IN ( 'DATAAREAIDLITERAL','PARTITIONLITERAL')


5) Restart your corresponding SQL server service


6) Restart your all AOS services



Now your AX clients are ready to login again and test planned.




Источник: http://blogs.msdn.com/b/axsupport/ar...p-by-step.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
AX 2009 Technical Journal: AX 2009 SP1, Parameter Sniffing finally addressed by Microsoft Blog bot DAX Blogs 1 04.11.2015 10:11
emeadaxsupport: Manufacturing Execution in AX 2012: Issue with the "Lock employee"-parameter Blog bot DAX Blogs 0 19.09.2013 18:11
atinkerersnotebook: Walkthrough & Tutorial Summary Blog bot DAX Blogs 1 09.09.2013 09:11
emeadaxsupport: "Parameter is missing a value" error running a customized report in Microsoft Dynamics AX 2012 Blog bot DAX Blogs 0 21.11.2012 00:12
emeadaxsupport: Microsoft Dynamics AX 2012 Reporting: How to translate parameters values Blog bot DAX Blogs 0 14.09.2012 13:11
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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