VQNM CDR Retention DB Impact

It always depends on your database server, your other Orion products and their retention, and how many calls you get. I find that I can't push it past 90 days or the reporting is very painful. But, I say try it, and if you need to you can trim it back. Also consider storing reports for archiving, I don't know what you need the data for, but we save off a number of weekly summaries for historical reference. 

I ran the SWQL below and have just under 10 million calls for 90 days if that helps. 

SELECT Count(ID) as [Calls]
FROM Orion.IpSla.VoipCallDetails

Call Volume by day:

SELECT Count(ID) as [Calls], DateTrunc('day', DateTime ) as [Day]
FROM Orion.IpSla.VoipCallDetails
Group by DateTrunc('day', DateTime )

Or Call Volume by week: 

SELECT Count(ID) as [Calls], DateTrunc('Week', DateTime ) as [Week]
FROM Orion.IpSla.VoipCallDetails
Group by DateTrunc('Week', DateTime )

Thank you for the answer jm_sysadmin

For us it is just under 2.5 million over 180 days.  When I initially made the change from 30 to 180 I had the users of those tables monitor for search issues.  We did talk about capping it at a year and just pulling a yearly report for archiving, I'm thinking with your feedback I'll push on this option a bit more.