Timeline for Available space differs between sys.database_files and database properties dialog in SQL Server Management Studio
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 19, 2019 at 13:25 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 13 characters in body
|
| Jul 19, 2019 at 13:20 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 68 characters in body
|
| Jul 19, 2019 at 13:13 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 39 characters in body
|
| Jul 19, 2019 at 13:08 | comment | added | Randi Vertongen |
@DrCopyPaste When using @updateusage on the sp_spaceused procedure, I do get new values for the ssms query while having the same for the query that uses the FILEPROPERTY function. Added it to the answer
|
|
| Jul 19, 2019 at 13:07 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 39 characters in body
|
| Jul 19, 2019 at 12:56 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 39 characters in body
|
| Jul 19, 2019 at 12:27 | vote | accept | DrCopyPaste | ||
| Jul 19, 2019 at 12:26 | comment | added | DrCopyPaste |
one final comment: In the space used query I ommitted the WHERE df.type in ( 0, 2, 4 ) to sum up all files, that way I get both numbers exactly as in the properties dialog: pastebin.com/AB57RVsy
|
|
| Jul 19, 2019 at 12:04 | comment | added | Randi Vertongen |
@DrCopyPaste Haha yes I like to use that part. The exact why I am going to not be able to answer unfortunately. Maybe somebody else will. I have also mostly seen FILEPROPERTYbeing used rather than allocation_units
|
|
| Jul 19, 2019 at 12:02 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 732 characters in body
|
| Jul 19, 2019 at 12:00 | comment | added | DrCopyPaste | Yes, of course. Use the Profiler to see what SSMS does, it's so ovious now :) | |
| Jul 19, 2019 at 11:55 | comment | added | DrCopyPaste | Curious though that most threads (that I found) did never even mention the way to do it with allocation units, which seems to be the only valid way to get numbers consistent with SSMS. | |
| Jul 19, 2019 at 11:37 | history | answered | Randi Vertongen | CC BY-SA 4.0 |