DB performance

Hi,

Currently our RT DB is about 308M. Not much but with nagios alerts,
production issues, customer problems, Im seeing the DB growing quickly.

I need to make sure that DB will not affect the RT performance.

Kindly help on how I can check DB integrity, and make sure that DB will not
slow RT.

I’ve been googling but the information are not sufficient.

Thanks!

More details are helpful!

How does your setup looks like? Hardware? Software? etc…

Torsten2010/6/3 rmp dmd rmp.dmd1229@gmail.com

Hi,

Currently our RT DB is about 308M. Not much but with nagios alerts,
production issues, customer problems, Im seeing the DB growing quickly.

I need to make sure that DB will not affect the RT performance.

Kindly help on how I can check DB integrity, and make sure that DB will not
slow RT.

I’ve been googling but the information are not sufficient.

Thanks!

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

MFG

Torsten Brumm

http://www.brumm.me

03.06.2010 17:23, rmp dmd wrote:

Hi,

Currently our RT DB is about 308M. Not much but with nagios alerts,
production issues, customer problems, Im seeing the DB growing quickly.

I need to make sure that DB will not affect the RT performance.

Kindly help on how I can check DB integrity, and make sure that DB will not
slow RT.

The first question is: what db do you use? mysql/postgres/oracle? Different DBs
requires different approaches.

The second question is: what db do you use?

The third and the rest of questions are rely on DB.

Agnislav Onufrijchuk
PortaOne, Inc., RT Developer
Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7670

PortaOne Booth 3H1-10, Hall 3
Canadian Pavilion @ CommunicAsia
Singapore Expo, June 15-18, 2010