TransWikia.com

Unusual growth tempdb

Stack Overflow Asked by Pablo Sanchez on February 18, 2021

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?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP