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!
Tibor Karaszi
shared this idea
5 comments
-
Woho! Thanks. just like it (IMO) should be! (Verified in SSMS 18.0)
-
This was implemented in SSMS 18.0 Preview 4 (and later). Please, have a look and see what you think.
-Matteo
-
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
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
Would be better to show _true_ initail size in "Initial Size" column and add a new column "Size" with current size.