6 Replies Latest reply on Dec 4, 2008 6:30 PM by Andy McBride

    FlowCorrelation

    justinh

      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?

        • Re: FlowCorrelation
          justinh

           Anything?  I had to change my timeout to 5 minutes to get a row count on the table (140 million, btw).

          • Re: FlowCorrelation
            justinh

            So now netflow is constantly crashing and restarting with the following:

            Event Type:    Error
            Event Source:    NetFlowService
            Event Category:    None
            Event ID:    0
            Date:        12/1/2008
            Time:        1:32:43 PM
            User:        N/A
            Description:
            Exception: error occurred during packet processing. Could not allocate space for object 'dbo.FlowCorrelation'.'IX_FlowCorrelation' in database 'NetPerfMon' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

             

            This brings up my question again.  Can I truncate this table safely?