Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Remove the word "Initial" in SSMS, Object Explorer, Database Properties, Files.

Right-click a database, Properties, Files. There's a column named "Initial Size (MB". The word "Initial" should be removed. It is incorrect to have that word there. What we see here is the current size. This is particularly confusing for tempdb since people tend to think that what you see here is indeed the initial size (size at startup, from sys.master_files), which is *not* correct. Again, you see the current size!

32 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Tibor Karaszi shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Tibor Karaszi commented  ·   ·  Flag as inappropriate

    Alexey: The true initial size is nowhere to be found. That value is not stored anywhere. Except for tempdb, which leads me to Ben's comment: SSMS used to show the initial size for tempdb, but as of SSMS 2012 the value it picked up from sys.database_files which makes it plain incorrect for tempdb.

  • Ben Miller commented  ·   ·  Flag as inappropriate

    Just something to think about is that tempdb if you modify the size, then it will be the initial size of the database files when you start up SQL. If it auto grows from there it will return to the initial size. How would you handle that in the gui or in properties?

  • Alexey Stepanov commented  ·   ·  Flag as inappropriate

    Would be better to show _true_ initail size in "Initial Size" column and add a new column "Size" with current size.

Feedback and Knowledge Base