quote:Originally posted by Network_GuruYou may need to tune your polling engine. Download and install the Polling Engine tuning tool.
quote:Originally posted by rwbucknquote:Originally posted by Network_GuruYou may need to tune your polling engine. Download and install the Polling Engine tuning tool.How much do you trust the tuner? I've been told by SW support not to use that tool. In fact when I do the math manually, I come out with a number of 69 polls per second, when the tuner shows 32 status polls per second and 57 collections per second. SW tells me to make the 2 numbers the same. What to believe?
quote:Originally posted by ggardner1I have set my polling and statistics collection perriods for very short perriods in an attempt to gather more detailed information.I am polling nodes and interfaces every 60 seconds and have the statistics collection Interval set to 1 minute for Nodes & Interfaces. I have applied all of these settings to All, and even restarted my Orion server.However, I still can only get a 10 minute resolution on my graphs. When I bring up a 5 minute graph, I show many gaps in the data. I even figured out that you can manually change a graphs link to show a 1 minute reolution on a graph to see exactly where the gaps are. Just change the part of the link where it says &SampleSize=5M to &SampleSize=1M. When I do that it shows that I have a data point every 6 to 7 minutes.Interestingly enough, I went into the Performance monitor console and tried hitting the "poll" button on an interface lots of times and I then get minute by minute data on that interface because I forced polls.Shouldn't I be able to get a higher resolution then 6-7 minutes with these settings???
quote:Originally posted by Network_GuruI believe the polling engine stops writing to the database during nightly maintenance.Even compacting/re-building the table indexes stops the polling engine, since it can't write to the database during this time.-=Cheers=- NG
I know this response is several years (4 to be exact) old but has anyone else moved the DB to the SAN and did that significantly improve response during high load periods like backups? We have shown that other applications that have been connected to the SAN via 2Gig HBA cards, behave very positively and respond much better when under heavy load then when attached via local SCSI attachments.
Solarwinds has re-written the DB maintenance routines since these posts, and there are no longer any missed polls during nightly maintenance. I run my DB on a dedicated SQL server with 8Gb RAM (using the AWE switch on x64 OS and hardware) and locally attached Raid 0 disk.I am upgrading my memory to 14Gb so that the entire DB will run in memory for increased performance.
Its been my experience that the nightly job, if running right, does not have an impact on polling. Which is good, because for us it takes 1-2 hours, not the 15 minutes for most of you.
Also, I saw a post farther up about moving your DB to a SAN. While I am not convinced, SW has some good reasons for NOT using a SAN for DB and will chastise you greatly if you do so.
Roger