configure size temdb



  • I have a disk space of 743 GB which contains the tempdb database

    there was a request to set the max size tempdb to 669GB keeping 10% percent as free disk space

    I have 8 tempb file + log file

    how can I distribute these values ​​between the mdf and ldf files

    thanks



  • In theory the tempdb tlog shouldn't grow too much, but in the real world I would take your available space and divide it by 9.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2