Opmanager Performance
Hello,
Are there equivalent tweaks available in Opmanager 8721? Periodically, the server will crash and I have seen on other posts where memory for Java and Mysql may be an issue in these crashes.
http://forums.manageengine.com/topic/nfa-professional-edition-performance-tuning-tips
We have seen consistent heavy CPU usage due to many instances of cscript.exe and ping.exe running, so it isn't necessarily java.exe which is the culprit. Monitoring 500 servers, our Opmanager server is a virtual machine that runs 2003 x64, 4gb ram and 2 vcpu's.
Enabling the slow query log on MYSQL shows several queries that exceed 10 seconds. Here is one:
Query_time: 44 Lock_time: 0 Rows_sent: 0 Rows_examined: 1104875
INSERT INTO STATSDATA_DAILY(POLLID,INSTANCE,MINVALUE,MAXVALUE,VAL,TINTERVAL,TTIME) SELECT POLLID, INSTANCE, MIN(MINVALUE), MAX(MAXVALUE), AVG(VAL),'86400000',AVG(TTIME) from( SELECT POLLID, INSTANCE,MIN( MINVALUE) AS MINVALUE, MAX(MAXVALUE) AS MAXVALUE, AVG(VAL) AS VAL,AVG(TTIME) AS TTIME from STATSDATA_HOURLY_2010_12_05_17 where TTIME > 1291703419566 AND TTIME < 1291789819566 GROUP BY POLLID, INSTANCE UNION ALL SELECT POLLID, INSTANCE,MIN( MINVALUE) AS MINVALUE, MAX(MAXVALUE) AS MAXVALUE, AVG(VAL) AS VAL,AVG(TTIME) AS TTIME from STATSDATA_HOURLY_2010_12_07_13 where TTIME > 1291703419566 AND TTIME < 1291789819566 GROUP BY POLLID, INSTANCE) AS TEMP group by POLLID,INSTANCE;
Is that normal?
Can your staff create a document which sets out best practices and optimal configurations depending on which platform and resources the customer is using?
Are there any plans to update the version of JRE and Mysql in upcoming versions which may offer improved stability?
Lastly, does the Opmanager DB use the InnoDB or Myisam engine?
Thanks!
Are there equivalent tweaks available in Opmanager 8721? Periodically, the server will crash and I have seen on other posts where memory for Java and Mysql may be an issue in these crashes.
http://forums.manageengine.com/topic/nfa-professional-edition-performance-tuning-tips
We have seen consistent heavy CPU usage due to many instances of cscript.exe and ping.exe running, so it isn't necessarily java.exe which is the culprit. Monitoring 500 servers, our Opmanager server is a virtual machine that runs 2003 x64, 4gb ram and 2 vcpu's.
Enabling the slow query log on MYSQL shows several queries that exceed 10 seconds. Here is one:
Query_time: 44 Lock_time: 0 Rows_sent: 0 Rows_examined: 1104875
INSERT INTO STATSDATA_DAILY(POLLID,INSTANCE,MINVALUE,MAXVALUE,VAL,TINTERVAL,TTIME) SELECT POLLID, INSTANCE, MIN(MINVALUE), MAX(MAXVALUE), AVG(VAL),'86400000',AVG(TTIME) from( SELECT POLLID, INSTANCE,MIN( MINVALUE) AS MINVALUE, MAX(MAXVALUE) AS MAXVALUE, AVG(VAL) AS VAL,AVG(TTIME) AS TTIME from STATSDATA_HOURLY_2010_12_05_17 where TTIME > 1291703419566 AND TTIME < 1291789819566 GROUP BY POLLID, INSTANCE UNION ALL SELECT POLLID, INSTANCE,MIN( MINVALUE) AS MINVALUE, MAX(MAXVALUE) AS MAXVALUE, AVG(VAL) AS VAL,AVG(TTIME) AS TTIME from STATSDATA_HOURLY_2010_12_07_13 where TTIME > 1291703419566 AND TTIME < 1291789819566 GROUP BY POLLID, INSTANCE) AS TEMP group by POLLID,INSTANCE;
Is that normal?
Can your staff create a document which sets out best practices and optimal configurations depending on which platform and resources the customer is using?
Are there any plans to update the version of JRE and Mysql in upcoming versions which may offer improved stability?
Lastly, does the Opmanager DB use the InnoDB or Myisam engine?
Thanks!