1

My question is the following: Scope: I am currently using Microsoft Dynamics Ax 2012 R3 and my database has the following settings in the properties of the tempdb in Microsoft Sql Server 2012.

TempDbConfig

Actualmente tengo un disco de 29 GB para almacenar la base de dato tempdb.

DiskSizeOfMyTempdb

But the last few days I have seen that my tempdb database has a runaway growth and it takes 2 days to fill the 29 GB disk.

Questions:

  1. Are there any settings in Microsoft Dynamics Ax 2012 R3 that allow this behavior?
  2. If there is a behavior that impacts me in the tempdb, how could I solve it?
  3. Is there a problem in my tempdb configuration?
  4. What configuration do you recommend for the tempdb?
Improve this question
4
  • 2
    AX2012 will use the tempdb database to store AX buffers for tempDB type tables. The tables are left there for future reuse and are only dropped when the last AOS service of your environment is stopped. Periodically restarting the AOS'es will remove unused tempDB tables from the tempdb database. Heavy batch activity can stress the tempdb database. Count the tables from the tempdb database and look for those named t123_AEF335FD4... (t=table + 123=AX table id + _ + AEF335FD4...=unique hexadecimal string). Looking up the AX table id could point to a specific process. Commented Jan 26, 2021 at 14:33
  • Theres a list of all tables in the tempdb gist.github.com/pablo17sanchez/733b2e870b3d3130a16a8ab5b9291e70 Commented Jan 26, 2021 at 16:15
  • Can you help me detect the problem?? Commented Jan 26, 2021 at 16:18
  • The AX temp tables with IDs 100003 and 100145 appear to be the most frequent. Look them up on your environment and see if you can explain their frequent occurance. Also, is the Recovery Model of the tempdb database set to "simple" and what happens if you limit the tempdb database further (reduce maxsize for the tempdev and templog files to 2048 MB)? Commented Jan 26, 2021 at 16:31
Related questions
0
SQLServer tempDB growing infinitely
2
Sql Server 2000 - tempdb growing very large
2
TempDB Log File Growth Using Global Temp Tables
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.