DbMon Samples Collector

[Info LightsRange]

Hi,

does anyone know if it is possible to use the jp@gc - DbMon Samples Collector plugin to monitor CPU, memory, disk etc. on a Microsoft Server DB instance?

If so how does one configure this?

I've downloaded the plugin but can't see how this can be done.

If not can someone recommend a Jmeter plugin that one can use to monitor and collect stats during and after test execution?

Thanks,

James

[DT]

I think DbMon Samples Collector allows executing arbitrary SQL queries which return numeric values and plot them in a chart.

If you need to collect information about CPU, memory, disk, etc. the options are in:

1. There are sys.dm_os_performance_counters exposing OS performance metrics to the SQL server, you can query them via DbMon plugin
   
2. If you're able to install 3rd-party software on the server you're monitoring - you can use JMeter PerfMon Plugin 
3. If there is SSH connectivity from JMeter load generator to the DB server - go for SSHMon Listener
   

[Info LightsRange]

Thanks DT.

I implemented your 2nd suggestion which was more along the lines of what I was looking for, however, I'm now getting this error as soon as I kick off a test. Nothing gets executed. Can you or anyone suggest what this error is and how to fix it?

2021-06-16 20:21:11,666 INFO o.a.j.e.StandardJMeterEngine: Running the test!

2021-06-16 20:21:11,666 INFO o.a.j.s.SampleEvent: List of sample_variables: []

2021-06-16 20:21:11,666 ERROR o.a.j.JMeter: Uncaught exception in thread Thread[StandardJMeterEngine,6,main]

java.lang.NoSuchMethodError: org.apache.jmeter.samplers.SampleSaveConfiguration.setFormatter(Ljava/text/DateFormat;)V

                at kg.apc.jmeter.JMeterPluginsUtils.doBestCSVSetup(JMeterPluginsUtils.java:258) ~[JMeterPlugins-Extras.jar:?]

                at kg.apc.jmeter.perfmon.PerfMonCollector.setupSaving(PerfMonCollector.java:143) ~[JMeterPlugins-Standard.jar:?]

                at kg.apc.jmeter.perfmon.PerfMonCollector.testStarted(PerfMonCollector.java:120) ~[JMeterPlugins-Standard.jar:?]

                at org.apache.jmeter.reporters.ResultCollector.testStarted(ResultCollector.java:350) ~[ApacheJMeter_core.jar:5.4.1]

                at kg.apc.jmeter.vizualizers.CorrectedResultCollector.testStarted(CorrectedResultCollector.java:28) ~[JMeterPlugins-Extras.jar:?]

                at org.apache.jmeter.engine.StandardJMeterEngine.notifyTestListenersOfStart(StandardJMeterEngine.java:205) ~[ApacheJMeter_core.jar:5.4.1]

                at org.apache.jmeter.engine.StandardJMeterEngine.run(StandardJMeterEngine.java:382) ~[ApacheJMeter_core.jar:5.4.1]

                at java.lang.Thread.run(Unknown Source) [?:1.8.0_281]

 

--
You received this message because you are subscribed to a topic in the Google Groups "jmeter-plugins" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jmeter-plugins/dCWnW2_UGrI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jmeter-plugin...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jmeter-plugins/35e587ec-3678-4403-bfd3-9eb83362389en%40googlegroups.com.

[Info LightsRange]

I'm still unable to collate the server side metrics from the MS SQL database. Although connection is established via port 4444.

Can someone please help interpret this error? 

The serverAgent terminates immediately after the Jmeter test is kicked off and the below error appears in the logs:

java.net.SocketException: Connection reset by peer: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_281]

at java.net.SocketOutputStream.socketWrite(Unknown Source) ~[?:1.8.0_281]

at java.net.SocketOutputStream.write(Unknown Source) ~[?:1.8.0_281]

at kg.apc.perfmon.client.StreamTransport.writeln(StreamTransport.java:50) ~[perfmon-2.2.2.jar:?]

at kg.apc.perfmon.client.AbstractTransport.disconnect(AbstractTransport.java:63) [perfmon-2.2.2.jar:?]

at kg.apc.jmeter.perfmon.NewAgentConnector.disconnect(NewAgentConnector.java:36) [jmeter-plugins-perfmon-2.1.jar:?]

at kg.apc.jmeter.perfmon.PerfMonCollector.shutdownConnectors(PerfMonCollector.java:281) [jmeter-plugins-perfmon-2.1.jar:?]

at kg.apc.jmeter.perfmon.PerfMonCollector.testEnded(PerfMonCollector.java:149) [jmeter-plugins-perfmon-2.1.jar:?]

at org.apache.jmeter.reporters.ResultCollector.testEnded(ResultCollector.java:345) [ApacheJMeter_core.jar:5.4.1]

at org.apache.jmeter.engine.StandardJMeterEngine.notifyTestListenersOfEnd(StandardJMeterEngine.java:218) [ApacheJMeter_core.jar:5.4.1]

at org.apache.jmeter.engine.StandardJMeterEngine.run(StandardJMeterEngine.java:493) [ApacheJMeter_core.jar:5.4.1]

at java.lang.Thread.run(Unknown Source) [?:1.8.0_281]

2021-06-29 12:35:05,251 INFO o.a.j.g.u.JMeterMenuBar: setRunning(false, *local*)