HPSIM + VCRM + VCA very slow in navigating through web interface.

[BurgesSalmon]

Hi,

I have just installed HPSIM 7.3.0, VCA 7.3.0.0, VCRM 7.3.0.0 and HP System Management Homepage 7.3.3 on Windows Server 2008 R2 (64bit) and whilst navigating through the web interface its painfully slow.

Spec - Server is running on Vsphere 5.5

RAM - 2gb + additional 8gb page file

2x singe core CPUs

I am monitoring around 150 systems

I have read through lots of posts in the HP forum and nothing seems to improve the performance.

I checked my mxdomainmgr.log file and it states the following:

04 Nov 09:23:54,549 INFO [HPSIM_DEBUG] [Panic Logger-0] (ConstructionWrapper:TrapHandler) Looks like we got a disconnect 08S01
04 Nov 09:23:54,892 INFO [HPSIM_DEBUG] [Panic Logger-0] (ConstructionWrapper:TrapHandler) java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1093)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:493)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
at com.hp.mx.database.MaplePreparedStatement.executeQuery(MaplePreparedStatement.java:235)
at com.hp.mx.core.protocol.snmp.trap.components.TrapProcessor.getTrapId(TrapProcessor.java:236)
at com.hp.mx.core.protocol.snmp.trap.components.TrapProcessor.determineOutputState(TrapProcessor.java:939)
at com.hp.mx.core.automation.Construction$Location.WhereTo(Construction.java:830)
at com.hp.mx.core.automation.ConstructionWrapper.run(ConstructionWrapper.java:382)
at com.hp.mx.core.utilities.CachedThread.run(CachedThread.java:209)
Caused by: java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
at java.io.DataOutputStream.write(DataOutputStream.java:107)
at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:686)
at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:570)
at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:518)
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1080)

04 Nov 09:23:58,995 INFO [HPSIM_DEBUG] [Panic Logger-0] (ConstructionWrapper:waiting) shutting down due to SQL error, no db connections returned now
04 Nov 09:23:59,057 INFO [Server] Runtime shutdown hook called, forceHalt: true
04 Nov 09:23:59,057 INFO [HPSIM_DEBUG] [Status-0] (Thread-62) Unregistering WinTrapForwarder...
04 Nov 09:23:59,073 INFO [STDOUT] JVM SHUTDOWNHOOK: Shutting down HP Systems Insight Manager...
04 Nov 09:24:00,539 INFO [Server] JBoss SHUTDOWN: Undeploying all packages
04 Nov 09:24:04,564 INFO [HPSIM_DEBUG] [Status-0] (Thread-62) WinTrapForwarder UnRegistered status = 0

Could the above have anything to do with the slowness ??

Many thanks - Mat

[Andrew_Haak]

Is the SQL remote or local Seems either you can't reach you SQL server or if the SQL is local you'er running low on memory.