Solved

Exchange 2010 database growing

Posted on 2014-03-20
8
350 Views
Last Modified: 2014-03-31
I am looking into this and saw a few scripts from Micrsoft but can someone tell me what things they would look for in a mailbox database that has grown rapidly with circular logging enabled or where to start thanks


I am checking for things like mailbox size, white space, recoverable items, deletions, purges but wanted a resource for a database, thanks
0
Comment
Question by:techdrive
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 Comments
 
LVL 14

Assisted Solution

by:Andy M
Andy M earned 100 total points
ID: 39942867
I would start by checking message tracking - see how much email is coming in and from where. Could be spam email?

Check mailbox sizes - possibly pull off a list once a day for a week and compare to see if any user's mailbox is climbing at a much larger rate than the others.
0
 
LVL 63

Expert Comment

by:Simon Butler (Sembee)
ID: 39942952
In my experience the primary cause is a user with an out of date Apple device that has tried to modify a calendar entry. See that do this more time than anything else combined.

Simon.
0
 
LVL 63

Expert Comment

by:Simon Butler (Sembee)
ID: 39942954
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:techdrive
ID: 39943514
Thanks simon I actually found another blog post http://blogs.technet.com/b/exchange/archive/2014/01/06/exchange-2010-and-2013-database-growth-reporting-script.aspx  and a powershell script. I am trying to decipher exactly what it is stating to me.


Here is the data that it sent back to me after running. Now below where it says Deleted item size. Is this the total deleted items size on the entire DB that I can remove somewhere and this will free up space. Is this the dumpster of the DB or the transport dumpster.

The name of the script is ExchangeDatabaseGrowthReporting.PS1 -mode 1



Currently selecting the top 25 items for reporting. Enter another value or press <Enter> to continue.


Database Details:



Name : Mailbox Database 23453
Guid : 234ee-555-ddm5-34r




Item Size Deleted Item Size Size On Disk Available New Mailbox Space Expected Overhead Actual Overhead
--------- ----------------- ------------ --------------------------- ----------------- ---------------
592.78 GB 112.19 GB         764.63 GB    71.09 MB                    20.00 %           7.79 %



Connected Mailbox Size Disconnected Mailbox Size
---------------------- -------------------------
703.30 GB              1.67 GB
0
 

Author Comment

by:techdrive
ID: 39944382
ok guys I have a stupid question and I hope no one goes wacko on me. I reviewed a couple of things especially simons observation about the apple devices. I ran a query for get-activesyncdevices and found over a 100 IOS6 devices. I also ran get-storageuseagestatistics and some of those same users had high timeinserver time along with something I saw logbytes. Can someone explain what that is as it shows when you run the command get-storageusagestatistics.

Well my silly question is if a device like an apple Iphone was generating a lot of logs eventually these logs would have to write to the exchange database and this would explain why the database is growing.
0
 
LVL 63

Accepted Solution

by:
Simon Butler (Sembee) earned 400 total points
ID: 39944781
The first thing I would do is run another activesync query to see how many of those devices have actually connected recently. Anything over 90 days you can probably presume has been replaced and the partnership can be deleted.

Then nag all the other users to upgrade their iOS version. That will improve matters significantly.
If the database has grown, and you are seeing a lot of deleted content then the best option once you have the ActiveSync devices upgraded is to create a new database, move all users to the new one and then drop the original. Otherwise you are going to have a database with over 100gb of white space in it.

Simon.
0
 

Author Comment

by:techdrive
ID: 39948539
thanks you guys have been very helpful
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
In-place Upgrading Dirsync to Azure AD Connect
In this video we show how to create a Shared Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Sha…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question