Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...How big is my databaseHow big is my database
Previous
 
Next
New Post
6/5/2017 6:12 PM
 

Hi,

When I go to host SQL and perform the command sp_spaceused, then I get the following results:
database_name database_size unallocated space
DB4825_waterman 406.19 MB 312.68 MB

When I go to Dashboard Server, then I get the following result:
Backup Name Started Finished Size (Kb) Backup Type

  6/5/2017 6/5/2017 98,381.00 Database

When I go to my Hosting panel then the database is:

Questions:

What means unallocated space?
I have not much modules installed on the website and I 'am afraid to install a module because my database space is only 500Mb.
Is this unallocated space available to use for another module?
How to get this unallocated space available and make the database smaller?

Regards, Ton


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
New Post
6/6/2017 12:05 PM
 
Hi Ton!

This question goes a bit deeper into the architecture of SQL server. I'll try to tell you in simple words, hopefully still correct, but it should give you the idea.

Unallocated space is storage that has been allocated to the database, but not yet to a specific object. Imagine you have a barrel that can contain 100 litres of whatever, but you have only 10 litres filled in. So you can still add 90 litres.

When there is no more unallocated space, SQL Server will grow the file - in your case, up to 500 MB. If you come to this limit, DNN will not work anymore, as it cannot write anything to the database, but I think it's a long way until you reach that.

And yes, you can shrink the files, but this could cause issues as well. I don't see the need for that, unless you have to pay less when your file is 300 MB smaller.

Happy DNNing!
Michael



Michael Tobisch
DNN★MVP
dnn-Connect.org - The most vibrant community around the DNN-platform
 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...How big is my databaseHow big is my database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out