FlowCorrelation

Question

I was looking at disk space today and noted that my FlowCorrelation table is 23GB - over half of my total database size.  Is this normal?  Can the table be truncated or shrunk in some way?  Is there a setting that controls how much data is kept in this table?

mcbridea · Answer

This might be related to the previously noted issue but I'm not sure. If you open a ticket support will be able to get to the bottom of it.

Andy

pakkm_007 · Answer

We are also getting a very similar error in the Event Log on the server. Need to know the best way to resolve this without losing data. I don't think the NetFlowService is crashing but it's adding one of these errors in the event log at a rate of between 20-30 per hour...

Event Type: Error
Event Source: NetFlowService
Event Category: None
Event ID: 0
Date:  12/4/2008
Time:  3:55:57 PM
User:  N/A
Description:
Exception: error occurred during packet processing. Cannot insert duplicate key row in object 'dbo.FlowCorrelation' with unique index 'IX_FlowCorrelation'.
The statement has been terminated.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

We are running Netflow v3 sp4, Orion NPM 9.0sp2, I know I still gotta update to 9.1 sp1 but would like to fix this first...

Anyone have ideas?

Thanks

justinh · Answer

Thanks for pointing the obvious out to me.  I remember looking at that thread a while back, too, but I was looking for something else, so it didn't occur to me that the information was already out there.  Doh!