sys.database_files and sys.master_files (rather than sys.sysfiles)

re: sys.database_files and sys.master_files (rather than sys.sysfiles)

Rob Farley — Sat, 13 Dec 2008 02:28:45 GMT

Accurate size - Do you mean size on disk, or amount of file used?

Rob

re: sys.database_files and sys.master_files (rather than sys.sysfiles)

owie — Fri, 12 Dec 2008 10:57:59 GMT

is there any way we could get the accurate sizes?

re: sys.database_files and sys.master_files (rather than sys.sysfiles)

Rob Farley — Wed, 12 Nov 2008 03:10:43 GMT

Yeah - it's not perfect.

re: sys.database_files and sys.master_files (rather than sys.sysfiles)

Amar — Wed, 12 Nov 2008 00:40:30 GMT

Rob Farley,

I really like what sys.master_files has to offer alas the information in it not correct. Most people online complained about how it has the wrong Size data. But another misleading information in it is the max_size column. It makes no differentiation between Auto-growth enabled and Auto-growth disabled. It shows "-1" for both situations!

Test your scripts on at least 2 servers if you are going to build some monitoring job using these seemingly unreliable system views. What a loss!

re: sys.database_files and sys.master_files (rather than sys.sysfiles)

David Gardiner — Wed, 07 Mar 2007 02:41:47 GMT

After trying a few weather services, I'm currently using WeatherBug - who seem to be a bit more accurate than the others. eg. their numbers seem a lot closer to what the Bureau publish. Some of the others always seem to be 3-4 degrees out, which is annoying.

Their Vista Sidebar gadget is pretty nice too.

-dave