2 Replies Latest reply: Sep 6, 2013 8:51 AM by sgracelin RSS

    TempSize - How to calculate?

    sgracelin

      Hi,

       

      Is there any recommended value for TempSize depending on any parameter?? If the T10 database PermSize is 8GB. Is there any recommended value/calculation for TempSize??

       

      Regards,

      Gracelin

        • 1. Re: TempSize - How to calculate?
          ChrisJenkins

          It's not really possible to accurately predict TempSize since it depends largely on your workload. The best way to tune it is to start with a 'reasonable' value (i.e. one that allows your workload to run without any 'out of temp space' errors) - a good guestimate might be 10% - 25% of PermSize. Then run your workload and monitor space usage via the ttIsql 'dssize' command. This displays 6 values:

           

            PERM_ALLOCATED_SIZE:      1048576

            PERM_IN_USE_SIZE:         392740

            PERM_IN_USE_HIGH_WATER:   392740

            TEMP_ALLOCATED_SIZE:      262144

            TEMP_IN_USE_SIZE:         16546

            TEMP_IN_USE_HIGH_WATER:   16609

           

          The 'ALLOCATED_SIZE' value is the amount of memory allocated (as specified in PermSize / TempSize).

           

          The 'IN_USE_SIZE' is how much of that is in use at the moment you run the 'dssize' command.

           

          The 'IN_USE_HIGH_WATER' value is the highest usage since the database was loaded into memory (i. e. started up). For Temp space, if this value is close to TEMP_ALLOCATED_SIZE then you should consider increasing TempSize while if it is much less than TEMP_ALLOCATED_SIZE then you can safely reduce TempSize.

           

          Chris

           

          Message was edited by: ChrisJenkins

          • 2. Re: TempSize - How to calculate?
            sgracelin

            Thanks Chris...We are monitoring dssize command output and is aware of the values in it...Wanted to know whether T10 has got any recommendation for TempSize calculation depending on data size or any other value. The guestimate reply was a information for us...thanks for that

             

            Regards,

            Gracelin