Head in a blender

Size matters

Andy Pedisich  September 10 2008 12:48:16 PM
I just had a client contact me because of a problem with a mail file.  He had made a replica on an ND8 server from a 7.0.3 server because he couldn't open it on the 7.0.3 box.  Then he couldn't open it on the 8.0.1 box either.

I took a look and found that it had hit the 64 GB mark.  Whoops!

This domain has been around for a very long time.   I bet there are lots of databases growing quietly in the background out there.

- Andy

1Chris Whisonant  9/10/2008 1:48:28 PM  Size matters

At least that only took the single mail file out of commission... Had a client call the other week with mail routing problems. AV log file was 64GB - stopped all mail routing! :)

2francie  9/10/2008 1:58:17 PM  Size matters

The "size doesn't matter" theory is often disputed, oddly enough, usually by those with small sized mail files or by Developers.

In my experience, it really isn't about the total bite count, but more in how the application is used and of course, the integrity of the server as a whole.

To combat downtime, a dbcache flush or server restart may be needed to restore the routing function, while compacting tends to be frowned upon by mail file owners for some reason.

3rob axelrod  9/10/2008 2:05:50 PM  Size matters

@Francie - LOL

@Andy - Try a compact -D get rid of the view indexes. Though you will need a bunch of space free to make it happen. (It seems creepy talking to you on your blog rather than any one of the 100's of other ways we can communicate. Next time I'll use the telepathy like usual.)

4David Schaffer  9/10/2008 5:16:01 PM  Size matters

Yikes. I've been panicking about folks for whom I can't keep mail file size below 8GB (and that's with server based scheduled archiving).