NetXMS Support Forum

English Support => General Support => Topic started by: andrius on April 01, 2014, 10:16:23 AM

Title: MSSQL database size
Post by: andrius on April 01, 2014, 10:16:23 AM
Hello,
i have noticed, that very fast is growing database size.
Date->Size
03.28->1507 Mb
03.31->1658 Mb
04.01-> 1818 Mb
Its that normal ?
I am monitoring 11 servers where parameters is like Used physical memory, average CPU utilization for last 5 min, logeed in users.
Is posibility to clear old data from database ? what to do that database size not grow so fast ?

Title: Re: MSSQL database size
Post by: andrey--k on April 01, 2014, 10:01:20 PM
You can set larger pooling interwall.
Old data deleting also set in configuration of DCI - Retention Time
See:
http://wiki.netxms.org/wiki/UM:Basic_Concepts#DCI_.28Data_Collection_Items.29
Title: Re: MSSQL database size
Post by: andrius on April 07, 2014, 03:57:59 PM
thanks  ;)
Title: Re: MSSQL database size
Post by: Victor Kirhenshtein on April 09, 2014, 09:24:36 AM
Another common problem with MS SQL is when recovery model (http://msdn.microsoft.com/en-us/library/ms189275.aspx (http://msdn.microsoft.com/en-us/library/ms189275.aspx)) set to Full and you don't do backups often - then database recovery log grows very fast because NetXMS do lot of inserts. You can check if this is the case by checking size of data files and log files for your database.

Best regards,
Victor