We are using NPM10 and the NPM Syslog Server. Logs pipe to our very stout SQL2008 server and the database lives on a raid 10, SAS15K drives: performance should never be an issue. We're noticing that the disk I/O and NetPerfMon database activity is through the roof. We're writing up to 1800 lines per second to the DB. Can NPM use "bulk insert" for these logs rather than writing one line at a time? If NPM could cache these in RAM and write ~500 lines at a time, it would take almost the same amout of I/O as one line. Plus, if we bounced the database server, NPM could cache logs for a few minutes. Is there any support for this?
By the way: Kiwi Syslog Server can do this but does not seem to be compatible with NPM. I'm new here, but am I the only one who doesn't undertand why? Thanks.
