Search 85,933 posts and 653 resources contributed by 43,538 members or post a topic.

Already Joined? Sign in
NetFlow Log file Size.

Page 1 of 2 (20 items) 1 2 Next > | RSS

rated by 0 users
Answered (Not Verified) This post has 0 verified answers | 19 Replies | 0 Followers | 1,957 Views


45 Posts
Points 347
aliendan posted on Wed, Nov 5 2008 9:07 AM
rated by 0 users
I have had to expand our data base log file from 10 GB to 38 GB in the last three weeks. From what I can see NetFlow seems to be the cause. I had to stop our NetFlow process to get Orion running stably.  When I started the NetFlow process up with the additional log file space the app burned through 38 GB of log file space in 30 minutes. Currently NetFlow accounts for 80 GB of our total 101 GB data base. I am in the process of expanding the log file space again, but I am wondering if anyone has seen this issue before. My guess is that NetFlow is wrapping up data all at once and is not committing data until it is done.
  • | Post Points: 5

All Replies


2 Posts
Points 8
bhammond replied on Mon, Dec 15 2008 10:48 AM
rated by 0 users

I have the same issue.  I have capped the log file to 30GB so we can run the Netflow service until we hit the log file limit.  Typically this gives us 30-45 mins.  I have a case open and am awaiting help.  Let me know if you find out anything and I will do the same.

  • | Post Points: 5

1,000 Posts
Points 5,477
SolarWinds Certified Professional
Yann replied on Mon, Dec 15 2008 11:01 AM
rated by 0 users

This KB from microsoft should help you.

"How to stop the transaction log of a SQL Server database from growing unexpectedly" - http://support.microsoft.com/kb/873235.

  • | Post Points: 3

152 Posts
Points 1,277
pguenther replied on Wed, Dec 17 2008 2:32 PM
rated by 0 users

We have started having this problem this week. Netflow is eating up 30GB of log files in less than 30 mins. This causes Orion to no longer be able to connect to the DB at all. Ihave to have my SQL admins go in and clear up the log and then the DB has to run a repair on itself. I have cut my Netflow dvices back as far as I can right now to 61 interfaces, but I have decent hardware. Dedicated SQL server. 3.0 Ghz processor with 12GB RAM on front end. I have had my SQL developer read the above KB article and his feedback is:

# Back up the transaction log files regularly to delete the inactive transactions in your transaction log.

- We would have to do this every 5 minutes

# Design the transactions to be small.

- Dependent on the application (Orion)

# Make sure that no uncommitted transactions continue to run for an indefinite time.

- Dependent on the applicaiton (Orion)

# Schedule the Update Statistics option to occur daily.

- Doesn't matter as the log fills in 30 mins.

I have sent some of my data to support. I seem to be spending more time babysitting this app lately.

  • | Post Points: 1

48 Posts
Points 3,527
gwsample replied on Mon, Jan 5 2009 8:44 AM
rated by 0 users

I too am haaving the same problem... Netflow is useless at the moment because of it...

Solarwinds, is there a patch or fix for this issue yet?

Gary Sample

EMCON Technologies

Orion 9.1 SP5 - APM 2.5 - NetFlow 3.1
Windows Server 2003 - MS SQL 2000 Standard

  • | Post Points: 3

1,273 Posts
Points 14,288
Moderator
SolarWinds Employee
mcbridea replied on Mon, Jan 5 2009 9:22 AM
rated by 0 users

We are aware of this issue and are actively working it. No update to share as of now.

Andy McBride, Technology Support Specialist - SolarWinds

Follow Me on Twitter

  • | Post Points: 5

48 Posts
Points 3,527
gwsample replied on Fri, Jan 9 2009 11:43 AM
rated by 0 users

any update on a fix for this?

Gary Sample

EMCON Technologies

Orion 9.1 SP5 - APM 2.5 - NetFlow 3.1
Windows Server 2003 - MS SQL 2000 Standard

  • | Post Points: 1

48 Posts
Points 3,527
gwsample replied on Thu, Jan 15 2009 10:12 AM
rated by 0 users

did you get a resolution to your problem yet?  I am having the same issue and have had no luck getting it resolved.

 

Gary Sample

EMCON Technologies

Orion 9.1 SP5 - APM 2.5 - NetFlow 3.1
Windows Server 2003 - MS SQL 2000 Standard

  • | Post Points: 1

6 Posts
Points 14
randhammack replied on Tue, Jun 2 2009 10:01 AM
rated by 0 users

Has there been any resolution to this matter. We are having the same problem.

  • | Post Points: 3

257 Posts
Points 774
SolarWinds Employee
davidmaltby replied on Tue, Jun 2 2009 1:18 PM
rated by 0 users

Are you using the latest service packs?  If so, can you call Tech Support and get a diagnostics to them?  We've addressed this type of issue in our service packs, but if you are up-to-date, then we'd like to investigate what your particular problem is.

Thanks,
David

 

David Maltby

EOC & IPSLA Program Manager

SolarWinds

  • | Post Points: 5

363 Posts
Points 1,097
Thwack MVP
Donald_Francis replied on Wed, Jun 3 2009 8:19 AM
rated by 0 users

I have the same issue, mine it at 50gb.

Donald Francis
Sr. Network Engineer
 The Shaw Group

NPM SLX 3 Pollers 14000 elements
APM SLX 2000 elements
NCM 3000 1300 devices
Netflow SLX 300 interfaces

  • | Post Points: 1

6 Posts
Points 14
randhammack replied on Wed, Jun 3 2009 9:06 AM
rated by 0 users

We are up-to-date on all of our service packs, excluding the latest one just released. We will try to that patch and see what happens. I was told that we did not have this problem until we updated our service packs a little over a month ago.

  • | Post Points: 3

257 Posts
Points 774
SolarWinds Employee
davidmaltby replied on Wed, Jun 3 2009 9:20 AM
rated by 0 users

So you're saying that you did not have this problem until you applied NTA 3.1 SP1?

David Maltby

EOC & IPSLA Program Manager

SolarWinds

  • | Post Points: 3

6 Posts
Points 14
randhammack replied on Wed, Jun 3 2009 11:30 AM
rated by 0 users

We have done the upgrade for SolarWinds from V9 SP1 to V9 SP4. This is when the problem started. Today we upgraded to V9 SP5. After getting your response, we checked the version of the NTA, it is still at V3.1, no SP. So, we looked on the support site again and found SP2 for the NTA and we are going to apply that. Thanks.

  • | Post Points: 1

6 Posts
Points 14
randhammack replied on Wed, Jun 3 2009 1:13 PM
rated by 0 users

Even after upgrading and applying the service patch, the log file will still eat up about 1 gig a minute of space. The overall actual data files are just about 15 gig, but the log file will continue to grow as much as I will let it. I have limited to 20 gig, where as yesterday it exploded to 34 gig in about 30 minutes.

  • | Post Points: 5
Page 1 of 2 (20 items) 1 2 Next > | RSS

© 2003 - 2010 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools

Learn More About SolarWinds Products