Need to monitor file growth

dkurfurst · Post by **dkurfurst** » Fri Feb 18, 2011 3:57 pm

I am need of a way to monitor the files growth of my SQL databases. I am looking to find out over time how much a database file has grown from a point in time so that we can plan for future growth accordingly and to also see which databases are growing the fastest. what is the best method for getting this info. I have setup folder/file tests and have set up alerts if a file grows by x amount of Mb/Gb but I really dont want to keep having to up the number when the test goes bad. I just want to be able to see a history over time of file growth.
Many Thanks
Don

KS-Soft · Post by **KS-Soft** » Fri Feb 18, 2011 4:01 pm

So you want to check size without starting alerts and seeng "bad" status?
Do not see any problem, you may set maximum size - 65536GB = 64 TB
(unless you database bigger than 64 TB?)

Regards
Alex

KS-Soft · Post by **KS-Soft** » Fri Feb 18, 2011 4:02 pm

PS
I assume you are using "File/Folder size" test method?

Regards
Alex

dkurfurst · Post by **dkurfurst** » Tue Feb 22, 2011 8:27 am

I just want to be able to get statistics / information on how much a file grows over a period of time. I have setup test to monitor the file size using file/folder size test but I am not seeing any difference and I know that the file has changed. what is the best way to get stats on how much a file grows daily?
Thanks
Don

KS-Soft · Post by **KS-Soft** » Tue Feb 22, 2011 8:38 am

No difference in reply field of the test? Why do you think size of the file was changed? May we see some screen shots? You may send screen shots to support@ks-soft.net

what is the best way to get stats on how much a file grows daily?

You may perform test once a day and check log file or quick log...

Regards
Alex

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Feb 22, 2011 9:01 am

How about this:

test method: "Folder/File Size"
Test interval: Once a day
use "Tune up Reply value" option of "Test properties" dialod with expression like:
[('%SuggestedReply%'-'%SuggestedLastReply%') div 1024 div 1024]

You will get: how much a file grows from last test check in MB

dkurfurst · Post by **dkurfurst** » Tue Feb 22, 2011 9:57 am

Thanks for the reply, Regarding my last post there were no modifications to the file I was looking at, Thanks for the tune up value, is there a way that I can keep a running total so I can look and see the history of file growth per day? I think the tune up value you gave me will just show for that day only and will only show the difference from a previous day. I would like to see the growth everyday and be able to go back and see how much it gre in a week, month, etc.
Should the tune up value change?
thanks
Don

KS-Soft · Post by **KS-Soft** » Tue Feb 22, 2011 10:56 am

Thanks for the tune up value, is there a way that I can keep a running total so I can look and see the history of file growth per day?

You may use "Tune up Reply" option in different ways.
E.g. use expression like [%SuggestedReply%] [('%SuggestedReply%'-'%SuggestedLastReply%') div 1024 div 1024]
Please check the manual or visit our web site at http://www.ks-soft.net/hostmon.eng/mfra ... uneupreply

Note: if you will display 2 numbers in Reply field, Log Analyzer, SLA reports will not be able to process test results correctly. I think its not a big problem in your case, you don't need SLA reports and charts for this check, right?
If you need reports and charts, then you may setup 2 tests: 1 to show current file size, another one to show difference in size between checks.

I would like to see the growth everyday and be able to go back and see how much it gre in a week, month, etc.

As you know HostMonitor record log files, so you just need to set Reply or Full logging mode for this test (unless you already using such "global" logging mode for all tests).

Regards
Alex