packet loss history

Hey folks, I've noticed lately that my IPSLA packet loss seems to have increased, nearly across the board. I wanted to look and see if it increased on a certain day, if it has risen gradually, etc. BUT it looks like I'm only storing IPSLA packet loss info for 30 days. Anybody know where the setting is that controls retention of IPSLA packet loss data?

Thanks!

Dan Goodale, Network Engineer II, Triwest Healthcare

Find more posts tagged with

ipsla_configure

ip_sla

Accepted answers

All comments

tom.rybka

DGoodale,

Have you checked the settings in "IP SLA Manager Settings" page, link "IP SLA Settings", option "Data Retention"? There should be a number of days the historical data are kept in your database.

epenney

Do you happen to know which tables in the database are impacted by changing IPSLA data retention value. Reason I'm asking, i've just discovered our nighly maintenance spends 20-30min on just a single Voip table (VoipCCMPhoneStatus_Detail) is now 78Million rows (2.5gb) - just this one table. And we don't even need to see or refer to this data at this point in time.

tom.rybka

VoipCCMPhoneStats_Detail table records get collapsed (and moved to VoipCCMPhoneStats_Hourly) after the detail retention period configured in Orion general setting. If you extended the period from default to something much larger, it would explain the size of the table. However you mention that only this table is that large - can you please tell how large is .e.g. VoipOperationResults_Detail table?

epenney

VoipOperationResults_Detail not that large 82MB / 1.7M rows / 115MB index space

VoipCCMPhoneStats_Detail 1500MB / 50M rows / 1300mb Index space used