Per Org, Salesforce allocates upto 250MB storage space. If you happen to run into a situation where you want to find how much storage space is being used then you could use the following 2 queries
and take action appropriately.
Following
select id,bodylength,cachecontrol,contenttype,createdby.alias,createddate,description, lastmodifieddate from staticresource
will give you a list of all the static resources and the space it consumes
and the
select sum(bodylength) from staticresource gives you the total storage space consumed
You might run into this issue if you have many installed packages in your system or you are using 3rd party tools like Skuid which masks Salesforce UI but allowing you to use custom UI but in the form of static resources
Enjoy !!!
