Initial MS SQL Database size

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
6/20/2011 1:18:52 AM
Gravatar
Total Posts 20

Initial MS SQL Database size

Hello everybody,

I hope receving a feedback soon since I am very worried about.

I have installed the leatest mojportal version. After installation I inserted , as samples, max 20 empty pages and 2 pages for the shared file service.

I checked the MS MSQL database size : it is 61 Mb. My questions are :

1. Is it normal such size at the beginning of the project?

2. It is a had question without information but... how much should be a recommended size for the MS SQL database?

I have 200Mb of storage available (61 are already filled), and I do not know how long probably it will last.

Thank you in advance

Alessandro

6/20/2011 7:11:10 AM
Gravatar
Total Posts 18439

Re: Initial MS SQL Database size

Hi,

You need to understand that a database is not like a file system where the amount of disk space used corresponds exactly to the size of the data. In a database more space is allocated, there is a main database file and there is a transaction log file and tables are allocated space according to various things like the fill factor size of the indexes. You can do some googling about it if you want to learn more.

My advice is keep an eye on it but don't worry too much unless it does start to get near the allowed limit, it probably is not going to grow that fast. There is really not much data in the database after a new installation but there are a lot of tables and those tables need room to grow so room is allocated for them.

I will say on my machine a new installation does not use 60MB of disk space. Probably if you make a backup of the data the backup won't be nearly that large. On this site when I backup my database its about 75MB but this site has been growing since 2004 (also this site uses MySql so it may not compare exactly to MS SQL). I'm sure the production db size is larger than the backup size again because of the padding and room to grow for tables.

Note also that if you create a large table with a lot of data and then delete the data, it does not recover the space used by the data, though there are commands you can use to recover some of it

In general databases should have more space allocated than actually used for data in order to perform well.

Hope that helps,

Joe

6/20/2011 8:17:46 AM
Gravatar
Total Posts 20

Re: Initial MS SQL Database size

Hi Joe,

"delete the data it does not recover the space used by the data, though there are commands you can use to recover some of it."

... you got me!

I asked to my provider to restore the DB.I therefore backed up the initial situation for future reference and restoring operation.

I had some not clean (faulty) installation at first. So...

Thank you Joe for your prompt and full answer to my question. I am not fully immerged in the MS SQL topic. That's a good way to start.

Thank you again,

Alex

 

 

 

You must sign in to post in the forums. This thread is closed to new posts.