MSSQL database size
-
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 ? -
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 -
-
Another common problem with MS SQL is when recovery model (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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login