Finding Size of Instance Database

[Mike McCall]

Is there a way to see the size of the database being used for your instance? Before I open a support ticket with this question, I thought I'd check if anyone knew an on-demand method available to administrators.

Obviously, I would appreciate granularity (size per table, etc.), but even just a single number would be great (e.g., "your instance's database is currently 1.2 GB").

[drjohnchun]

There's another way to accomplish this, which works in latest releases. If you still need it (I realize this thread goes back almost two years), please send me a private message. While I'm happy to share, I'm a bit hesitant to post it here since it carries similar risks.

[Mike McCall]

Since the request for this data has passed, I'll hold for now, but you may hear from me (or another reader of this thread) in the future.

Thanks for the replies! (and for protecting us from ourselves, hah)

[Mike McCall]

If you're just finding this thread now, there have been many suggestions on ways you might discover/approximate the size of your instance's database. I'm not sure any single one is the most "correct," so please browse the responses below--those marked "Helpful" are the best to start with--and good luck!

[nyancer3 · Accepted solution]

I realize this is an older thread, but I had a similar question posed to me in regard to sizing an on-prem database for replicating the instance data for reporting usage.

I am not sure exactly what version introduced it, but there is now a count gauge on the Instance Usage > Application Usage Overview page that shows the current total size of the database for your instance. If you edit the widget and go into the code for the counter, you can see the API used to gather the metric: SNC.UsageAnalyticsScriptUtils.getCount('Primary DB size (MB)', 'Primary DB size of this instance (in MB)');

Hope that helps.

[Mike McCall]

This is great!