Finding Size of Instance Database

Mike McCall · ‎05-15-2012

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").

nyancer3 · ‎03-15-2019

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.

View solution in original post

tony_fugere · ‎05-29-2012

The beauty of ServiceNow being a SaaS solution is that we, as consumers of the product, don't need to know this. It is ServiceNow's job to take care of everything for us. However, I'd like to learn why you need to know the size of your database, if you don't mind sharing.

I am pretty sure the only page that we have access to is /stats.do which provides some information about the instance, but not the database size.

Mike McCall · ‎06-18-2012

For an update on the situation, I did ask the question directly of Service-Now, and they said there is currently no functionality available (on our end or theirs) to discover this sort of detail. They have opened an enhancement request on my behalf.

Tony, I completely agree with you that protection from certain technical details is a major benefit of the SaaS model. My challenge is that we may be implementing an enterprise content solution that includes the ability to search Service-Now data, and the size of the index that this new solution creates will depend on the size of the data it is indexing. In order to calculate storage requirements, etc. for the new solution, it would be helpful to know how much data it will be working with.

tony_fugere · ‎06-18-2012

That's a great use case. Thanks for sharing why you need this information, it helps us all learn!

Jeff Boltz1 · ‎10-10-2016

Does ServiceNow monitor and manage database sizing? Would I ever encounter a condition such as, "Sorry, you have exceeded your data allocation amount - please contact your ServiceNow representative to purchase more storage to continue using the platform." ?