axinthefield: How to accurately predict database growth in Dynamics AX
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:
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.
Расскажите о новых и интересных блогах по 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|
|Опции темы||Поиск в этой теме|