Forum

Search Home

1
2
3
4
5

Home

Public

Development

SQL database

3/26/2013 4:49 AM

Benzo

Joined: 8/10/2011

Posts: 18

SQL database

I have 6 dnn websites, where I have copied same isntallation and modified it. Thereby I am using too much SQL database space. How can I minimize data space used? Hope you can help.

database 1 = 92,13 mb

database 2 = 91,19 mb
database 3 = 89,25 mb

database 4 = 87,56 mb
database 5 = 101,38 mb
database 6 = 78,81 mb

3/26/2013 5:09 AM

Aderson Oliveira

Joined: 12/28/2009

Posts: 1011

Re: SQL database

Hi Benzo,

First I have to say that the sizes you have listed are not big. Maybe you can reduce a bit but they have very reasonable sizes.

In any case you can try running some db cleanup scripts.

1 - First run this one so you can find the data and log files sizes:

SELECT (SIZE / CONVERT(REAL, 1048576/(SELECT LOW FROM master.dbo.spt_values WHERE number = 1 AND type = 'E' ))) as SizeInMB,
Name,
DB_NAME() AS DataBaseName,
Filename
FROM sysfiles

2 - Then to try to reduce their sizes, you can run the next script twice, once for the data file and once for the log file:

dbcc shrinkfile( [NAME] ,1)

where you will replace [NAME] with the name information listed on the first query above.

Give it a try and see how it goes. I would strongly recommend backing up the databases before doing this. It is safer.

Cheers,

Aderson

3/26/2013 5:14 AM

Benzo

Joined: 8/10/2011

Posts: 18

Re: SQL database

Aderson wrote:

Hi Benzo,

First I have to say that the sizes you have listed are not big. Maybe you can reduce a bit but they have very reasonable sizes.

In any case you can try running some db cleanup scripts.

1 - First run this one so you can find the data and log files sizes:

SELECT (SIZE / CONVERT(REAL, 1048576/(SELECT LOW FROM master.dbo.spt_values WHERE number = 1 AND type = 'E' ))) as SizeInMB,
Name,
DB_NAME() AS DataBaseName,
Filename
FROM sysfiles

2 - Then to try to reduce their sizes, you can run the next script twice, once for the data file and once for the log file:

dbcc shrinkfile( [NAME] ,1)

where you will replace [NAME] with the name information listed on the first query above.

Give it a try and see how it goes. I would strongly recommend backing up the databases before doing this. It is safer.

Cheers,

Aderson

Thank you Aderson :)

Okay, my hoster says that I am using unnormally high amount of SQL dataspace, which he said is not normal for a website. Thereby I am paying a lot for the SQL space.

Would I need less space, if I have created all sites in one? Meaning if I have made more portals in single DNN installation?

Or would I need less space, if I have used some language pack? to translate the content instead of making 6 websites?

Best regards

Benzo

Page 1 of 1