cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Mananging SQL volume with an RDBMS deployment

lrobinet
MEGA
MEGA

After a MEGA + Advisor RDBMS deployment, the disk dedicated to the SQL motor fills quickly. It has only been a couple of months and the volume is full (25 GB) despite de fact that little modelling has been done. (The database contains few objects.) Data is saved on a SAN disk.


Data purge scripts of temporary and archived objects have been executed on the MEGA SQL repositories, but the database log volume continues to increase.

Do you have suggestions to limit this phenomenon?

Is it due to the absense of log purges in the SQL databases? Is it correct to assume that transaction logs are purged once the transaction is abandoned or dispatched?

If I consolidate in the log management interface in the MEGA Administation tool, does this consolidate in the SQL database or are there additional steps to clean up the SQL database in that regard?

1 Reply

François
Administrator
Administrator

Hello Leslie,

Are  Stored procedures  have been run from the beginning of the existence of the database?

 

For information : http://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=50120000000mrAiAAI

 

If not that mean your storage space has increase and represent 25GB PHYSICALLY" now.

But this doesn't mean LOGICALLY you have 25GB of Data.

 

There is a functionnality on SQL Server called "shrink database" or autoshrink"

For example see KB : http://support.microsoft.com/kb/315512/en-us

 

You can also search on the web "shrink database SQL server"

 

See you.