Post reply

Tempdb datafile initial file sizes changed by SQL Server itself?

  • March 18, 2015 at 5:21 am

    #296162

    I have an instance with 4 datafiles for tempdb each set at initial size of 4G and growth rate of 100MB. After some time the initial file sizes seem to have changed automatically. They now read 3962,100,3688 and 2847 respectively. Is this something done by SQL Server itself? I cannot imagine that it was done manually.

    I don't think there was a restart after the initial sizes of 4G were set, could this be related to the problem?

  • March 18, 2015 at 7:49 am

    #1784773

    These are not initial but current sizes. SQL Server does not keep the file size at the time when you have initially created database. Check sys.database_files view. It has size, max_size, growth fields, but not initial size. If you are referring to SSMS database properties/files, that wording is actually misleading. It should read just "Size (MB)".

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

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