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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 13.06.2011, 00:11   #1  
Blog bot is offline
Blog bot
Участник
 
23,904 / 805 (74) +++++++
Регистрация: 28.10.2006
axinthefield: How to accurately predict database growth in Dynamics AX
Источник: http://blogs.msdn.com/b/axinthefield...namics-ax.aspx
==============

One of the biggest challenges the Dynamics AX database, is predicting database growth. Many customers are simply using the size of the backups to judge database growth. Although this process works, there are some flaws in doing this such as Transaction Log size is included in that backup. For example, if you imported 1GB of new data into the database and then did a backup, the backup would have grown 2GB in size. This would be 1GB for the data and 1GB for the log data. So using the backup size method would tell us the database grew 2GB when it actually only grew 1GB.

One of the great abilities of Performance Analyzer for Dynamics is collecting data at different points in time and then doing a delta difference to determine a value such as growth in rows or growth in size over that timeframe. One of the tables in the DYNAMICSPERF database is called INDEX_STATS. In this table, we have the row_count and size of all of your Dynamics AX tables. To get an accurate an accurate growth rate over a period of time, we simply need to capture data at 2 different points such as Monday morning and Friday evening. This would give us the growth rate for an entire week.

Since Nov. 2010, Performance Analyzer 1.0 has had a function in the database called fn_dbstats. This procedure does the calculation of database growth per table and requires 2 parameters. The 2 parameters are simply the RUN_NAME of the 2 data captures. You can find this by running the following query in DYANMICSPERF:

SELECT RUN_NAME FROM STATS_COLLECTION_SUMMARY

Choose 2 RUN_NAMEs that are a fixed workload such as 1 day, 1 week, etc. Once you have selected the values you can run the following SQL statement:

SELECT * FROM fn_dbstats('', 'RUN_NAME2>')

The results will look as follows:

TABLE_NAME

Original_PageCount

New_PageCount

Original_SIZEMB

New_SIZEMB

Delta_SIZEMB

Table_Updates

Delta_In_Rows

Days

LEDGERTRANS

13375

13730

104

107

3

8761

8635

1

LEDGERBALANCESDIMTRANS

4364

4526

34

35

1

1477

7141

1

LEDGERBALANCESTRANS

3132

3248

24

25

1

1477

6138

1

LEDGERJOURNALTRANS

1258

1274

9

9

0

450

159

1

Now you can accuratly, predicte database growth based upon actual sizes collected from every table. Another important feature of this data is that this is your REAL transaction volumes in each and every table in your Dynamics AX database for that time period.




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

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
dynamics-ax: Interview with Microsoft's Lachlan Cash on his new role, AX 2012 and more Blog bot DAX Blogs 6 22.04.2011 14:55
axinthefield: Dynamics AX Event IDs Blog bot DAX Blogs 0 01.03.2011 22:11
axinthefield: Database Mirroring with Dynamics AX Blog bot DAX Blogs 1 20.01.2011 10:54
semanticax: Dynamics AX 2009 Installation - Application Blog bot DAX Blogs 0 22.12.2010 08:11
axStart: Microsoft Dynamics AX 2009 Hot Topics Web Seminar Series Blog bot DAX Blogs 0 06.08.2008 12:05
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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