Util procedure to show database size

re: Util procedure to show database size

Uri Dimant — Tue, 29 Dec 2009 12:46:06 GMT

Hi Tibor

I would add that those numbers are in MB/KB/GB... and /or perhaps the percent usage % or data and log files, what do you think?

re: Util procedure to show database size

TiborKaraszi — Wed, 30 Dec 2009 07:50:09 GMT

Hi Uri,

I had that originally (MB), but decided to remove it to keep the result as slim as possible... :-)

re: Util procedure to show database size

csm — Wed, 13 Jan 2010 12:33:16 GMT

Hi Tibor,

there's an error on the definition for #dbcc_sqlperf_logspace table. The datatype for database_name column must be sysname (or something similar), not varchar(32).

Anyway, thanks for the script

re: Util procedure to show database size

TiborKaraszi — Wed, 13 Jan 2010 16:15:31 GMT

Hi csm,

That type (varchar(32) is actually deliberate. It was there for tools which doesn't adjust width according to data size. I.e., so we don't have to scroll that much side-ways when reading the result. I think it had to do with 2000 tool (the proc is supposed to be runnable on 2000), but exact details escapes me at the moment.

Sysname would be the type to use if you don't want to truncate long db name - that is correct. :-)

re: Util procedure to show database size

csm — Mon, 18 Jan 2010 08:53:31 GMT

But with 32 characters only, the procedure raise an exception (i.e., the AdminContent database in a Sharepoint implementation)

re: Util procedure to show database size

TiborKaraszi — Tue, 19 Jan 2010 16:29:58 GMT

You are absolutely right. I guess I only tested it with db names shorter than 32, in order for the tool to not have a too wide column. I now tested it with a long db name and I get the same truncation messaged. I fixed that datatype, changed it to sysname. The "right" way to cut down the length would have been to use CAST or CONVERT on the final select instead of having a smaller type in the input table...