required Tempdb

  • Does it possible to calculate required tempdb size prior to execution of a query?

    Using excutuion plan / some other tools.

  • krishna83 - Tuesday, June 27, 2017 5:44 AM

    Does it possible to calculate required tempdb size prior to execution of a query?

    Using excutuion plan / some other tools.

    It may be possible to make some guesstimates but giving all the possible effecting factors, it is not likely to be too accurate. A better approach is to optimise both the code and the tempdb configurations.
    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply