cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Polling Interval vs SQL Performance

Jump to solution

Hi Solarwinds Gurus,

            To have better NTA data, we know we need to minimum polling interval and it will impact SQL performance. How can I test out my polling interval rate(aim 1-2 min) without breaking SQL server? Thank you. 

0 Kudos
1 Solution

Netflow doesn't really have a concept of a polling interval. You set up your routers/firewalls to send data as frequently as you like, but the recommendation is a max of 60 seconds since the Netflow db is all dialed in with that assumed interval already.  No extra effort needed if your routers are already doing 1 minute intervals.

 

- Marc Netterfield, Github

View solution in original post

0 Kudos
2 Replies

Netflow doesn't really have a concept of a polling interval. You set up your routers/firewalls to send data as frequently as you like, but the recommendation is a max of 60 seconds since the Netflow db is all dialed in with that assumed interval already.  No extra effort needed if your routers are already doing 1 minute intervals.

 

- Marc Netterfield, Github

View solution in original post

0 Kudos

Thank you for the answer and it makes sense. Sounds like we can control how fast our network devices sending the data. Is there anyway we can control how much data we can send? I realize that after NTA receives the data, it will start to write on SQL data base. How do I know if NTA cannot write data fast enough in order to cause overlap data? I mean when NTA start to write the first data it receives, then before it finish, it already receives second data, then it will cause overlap. 

0 Kudos