Database size management

Hi All,

I’ve got a RT 3.6 install. Approx 20 users, and a database size of about
500MB.
It looks like i’m adding 25MB of data per week… so it’s growing quite a
bit faster than i’d like.

Any recommendations for data that i should look at stripping out of the
database? or do people archive their databases? if you do is it pretty
easy to bring them back online again if need be?

Cheers,

Calvin Chiang
Network Admin
Utilyx
1st Floor, 55 North Wharf Road
Paddington
London, W2 1LA
Tel: 020 7087 8673
www.utilyx.com

“Utilyx” is the trading name of “Utilyx Limited” and “Utilyx Risk Management Limited” (URML). URML is authorised and regulated by the Financial Services Authority (FSA). This message contains information that may be privileged or confidential and is the property of Utilyx. It is intended only for the person to whom it is addressed. No confidentiality or privilege is waived or lost by any mistransmission. Any views or opinions expressed in this message are solely those of the author and do not necessarily represent those of Utilyx. Unless otherwise stated, any pricing information given in this message is indicative only and does not constitute an offer to deal at any price quoted. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email

Calvin,

We keep everything. Even at 25MB/week, that is only 1.3GB/year
which means a standard 146GB drive will last a bit over a century.
That is a bit tongue-in-cheek, but really this data volume is
easily managed by small laptops and PDAs. You can use the shredder
function to delete tickets after a certain period to free up space.
We have zeroed out some large attachments that people attached to
a ticket (100+MB) otherwise we just let it be. Bringing them back
online is not particularly easy since the entire app was built with
historical accuracy and permanence in mind.

Cheers,
KenOn Mon, Jan 19, 2009 at 05:44:34PM +0000, Calvin Chiang wrote:

Hi All,

I’ve got a RT 3.6 install. Approx 20 users, and a database size of about
500MB.
It looks like i’m adding 25MB of data per week… so it’s growing quite a
bit faster than i’d like.

Any recommendations for data that i should look at stripping out of the
database? or do people archive their databases? if you do is it pretty
easy to bring them back online again if need be?

Cheers,


Calvin Chiang
Network Admin
Utilyx
1st Floor, 55 North Wharf Road
Paddington
London, W2 1LA
Tel: 020 7087 8673
www.utilyx.com


“Utilyx” is the trading name of “Utilyx Limited” and “Utilyx Risk Management Limited” (URML). URML is authorised and regulated by the Financial Services Authority (FSA). This message contains information that may be privileged or confidential and is the property of Utilyx. It is intended only for the person to whom it is addressed. No confidentiality or privilege is waived or lost by any mistransmission. Any views or opinions expressed in this message are solely those of the author and do not necessarily represent those of Utilyx. Unless otherwise stated, any pricing information given in this message is indicative only and does not constitute an offer to deal at any price quoted. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.


This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com