Exchange Store Size

wtimon · Post by **wtimon** » Thu Oct 30, 2008 10:40 am

Does anyone know of a good way to test for the size of the Information Store in Exchange? I want to set an alert for when the Information Store is approaching its size limit but I haven’t been able to figure out a good way to set up a test for this in Hostmon.

KS-Soft Europe · Post by **KS-Soft Europe** » Thu Oct 30, 2008 10:59 am

I think, you may monitor size of .STM and .EDB files.
In this case you may use "WMI" test method with the query like the following:
Select filesize from CIM_DATAFILE where name='D:\\temp\\aaa.STM' or name = 'D:\\temp\\aaa.EDB'
http://www.ks-soft.net/hostmon.eng/mfra ... ts.htm#wmi

Regards,
Max

meppyman · Post by **meppyman** » Sun Sep 27, 2009 5:45 am

has anyone worked this out yet? Here is the problem with Exchange Store size:

The files may contain free space after online defragmentation. The amount of free space is detailed in an event 9688 logged in the Application event log each night.

The trick is how do you extract the information and then create a test to alert on this when it gets too high. My guess is some coding will need to be done, but it may be possible with WMI? Either way I will try and get a developer to whack something together for me if I can get help on here on integrating that with HM.

meppyman · Post by **meppyman** » Sun Sep 27, 2009 7:21 am

After some thinking and checking it seems that this particular issue is best handled by setting the registry keys to the threshold you want and looking out for that event, there is also an event that tells you when the database size has reached or exceeded the limit which you should also definitely have a high level alert for.

See http://technet.microsoft.com/en-us/libr ... 65%29.aspx for details.

Cheers.

Kris · Post by **Kris** » Wed May 12, 2010 3:30 am

Has anyone been able to somehow probe the free space in an Exchange 2003 store?

And if so, how?

Cheers

KS-Soft · Post by **KS-Soft** » Wed May 12, 2010 4:34 pm

Good question for Microsoft

Exchange provides various WMI classes
http://msdn.microsoft.com/en-us/library ... G.65).aspx
But I cannot find any property that provides database free space...

I cannot find anything useful except this one
http://jonathanmedd.blogspot.com/2009/0 ... ce-in.html
=============
Exchange records an entry in the Application Event Log (Event ID 1221) after online maintenance has taken place which tells you how much free space is in the database - this means trawling through the event logs on each server and recording which databases you think are worth defragging.
=============
There is PowerShell script listed. It can be modified in order to work with HostMonitor but I don't think its nice solution - check event log for records that can be obsolete if maintenance was not performed recently

Regards
Alex

Kris · Post by **Kris** » Mon May 17, 2010 7:37 am

I've created a small executable that will return the free space in the exchange store DB as a console application.

Is there a way to capture the output from the executable to use it in HM? Other than echo it to a file and read that, ofcourse...

KS-Soft · Post by **KS-Soft** » Mon May 17, 2010 10:19 am

If you can modify your program a little, you can use Shell Script test method.
http://www.ks-soft.net/hostmon.eng/mfra ... m#chkShell

The program must write to stdout (standard output stream) single result string. This string should contain 3 parts separated by colon
http://www.ks-soft.net/hostmon.eng/mfra ... m#shellres

Regards
Alex