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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 13.07.2007, 18:00   #1  
Blog bot is offline
Blog bot
Участник
 
25,565 / 848 (80) +++++++
Регистрация: 28.10.2006
Dynamics AX: SQL Server, Heart of Dynamics AX
Источник: http://dynamics-ax.blogspot.com/2007...namics-ax.html
==============
When you think of Dynamics AX, you have to think about SQL Server, currently 2005. This is the heart of Any Dynamics AX implementation, and therefore must be thought through for what hardware and optimization options that will need to be setup for your given installed base.

A SQL Server Admins best friend is the System Monitor [aka Performance Montior] and the different information you can gather from the Currenty Activity section, as well as the SQL Server Profiler. These three tools will aid anyone whom knows how to use them in adjusting SQL Server performance to reach peak levels of optimization for the given instance. In the coming weeks I will start into a good many post on the different aspects of SQL Server optimization that is geared towards Dynamics AX. See with Dynamics AX, the management of SQL server is different than normal custom applications. The reason for this is the meta layer that Dynamics AX uses to manage the database, and the objects within it.

So to start let's talk about something that can be one of the first things that will bring improvement to most Any SQL Server install. One of the first things one can do is use the System Montior [aka Performance Monitor] and track the Page Life Expectancy for a given SQL Server instance. Now the reference to the instance of SQL Server here is the OLTP instance that host the transactional Dynamics AX database. So with this messaurement, one is looking at the average life of a SQL Page in RAM, over a timeframe messaured in Miliseconds. The higher the number, the better. A rule of thumb is that if the Page Life Expectancy stays on average below 3000 mark then you need to look at improvements for this area. How would your improve the life of a SQL page in RAM? One would think right off the bat, add more RAM. This thought is half way right, in that you need more RAM. Just adding more RAM though in a 32 bit system will not do the trick. No you have to enable AWE, or Address Windows Extensions. AWE enables a 32-bit program, via the OS, to allocate more than the default max of 2 GB for a given process in memory. So adding more RAM, and then enabling AWE, will increase your page life expectancy, and in turn your entire system will run faster because SQL server is not having to recompute / recompile the query plans, instead for the entire page life it can re-use those query plans.

To enable AWE in 2000 took a little bit of tricky work, but in 2005 it's pretty straight forward. Basically you have to apply the proper switch to the boot.ini of Windows [/3GB] and then tell SQL server to make use of AWE and set the max to all but 1.5 GB of what is there. [1 GB is you must, but that is a min. for the OS to have]

I have a couple links for you here that will be of useful help that talks about AWE:

1.) SQL Server Performance.com AWE Post for SQL Server 2000

2.) Microsoft Page about enabling AWE for SQL Server 2005

Check back soon as we look into other area's of interest for SQL Server performance, and also more focused towards Dynamics AX!

Find a job at: www.DynamicsAXJobs.comFind a job at: DynamicsAXJobs.com, also post a job for only $99.00!


==============
Источник: http://dynamics-ax.blogspot.com/2007...namics-ax.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
Dynamics AX Sustained Engineering: SQL Server 2005 sp3 & SQL Server 2008 with Dynamics AX Blog bot DAX Blogs 0 12.02.2009 06:08
jinx: Microsoft Dynamics AX 2009, Windows Server 2008 und SQL Server 2008 Blog bot DAX auf Deutsch 0 12.10.2008 20:10
axStart: Microsoft Dynamics AX 2009 Hot Topics Web Seminar Series Blog bot DAX Blogs 0 06.08.2008 12:05
Dynamics AX: Dynamics AX 2009 & SQL Server 2008 Blog bot DAX Blogs 0 10.06.2008 21:08
aEremenko: Диагностика проблем при установке Microsoft Dynamics Ax 4.0 на Microsoft SQL Server 2005 Blog bot DAX Blogs 0 28.10.2006 16:01
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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