Start a new topic

CPU at 25%+ consistently

[This topic is migrated from our old forums. The original author name has been removed]

Hi, Recently I have noticed my DBVis v9.0.2 (Windows 7 64-bit - Intel i7 CPU) process consuming 25% of CPU all the time. I searched through the forums and found this : http://www.dbvis.com/forum/thread.jspa?messageID=7142. Looks like the same issue but from a long time ago on a much older version. When I go to Windows task manager I see this : *Image Name PID User Name CPU memory (Private) Description* *dbvis xxxx xxxxxxxxxx 25 257,512K DbVisualizer - The Universal Database Tool* It goes up & down 25% - 30% - 33%, etc but does not drop. I have no monitors running and have one open connection. Does anyone else have this issue ? Thanks, Steve.

[This reply is migrated from our old forums.]

Re: CPU at 25%+ consistently
Hi Steve and Alex, Thanks for reporting this. We will have a look at the multiscreen case in more detail later. For now, I can say that the DbVisAutoSaver thread identified as the main consumer is the thread that automatically saves modified SQL Commander content. We have tweaked it a bit in the maintenance releases so I suggest that you first upgrade to 9.0.5 and see if you see the same things. DbVisualizer 9.0 always runs the auto-saver every 30 seconds, but unless there are modified SQL Commander editors, it doesn't do much and shouldn't use a lot of CPU. It is, however, possible that the GUI code that locates the editors to see if they are modified for some reason consumes CPU when using multiple screens. As stated in the older thread, the only other things that can run when there is no interaction are active monitors. Also note that it is kind of tricky to say what should be considered harmful CPU usage: 100% can be ideal if no otter application needs the CPU? With a single CPU, there is always one thread that at some point uses 100% of then CPU, so how the CPU monitoring tool calculates the usage is also an interesting parameter. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: CPU at 25%+ consistently
Hey Alex, I have 2 screens hanging off my laptop and my laptop screen is closed in a docking station. However, it doesn't actually matter what screen i run DBVis in, the CPU activity is still 25%. I just noticed now that even when I have no connections open, the CPU activity is the same... I tried having a look at what the Java process is doing so I used a tool I found called *jvmtop* and got the following result: JvmTop 0.3 alpha (expect bugs) amd64, 4 cpus, Windows 7 6.1 http://code.google.com/p/jvmtop PID 7540: C:\Apps\DbVisualizer-9.0.2\dbvis.exe ARGS: VMARGS: -Dexe4j.semaphoreName=Local\c:_apps_dbvisualizer-9.0.2_dbvis.exe [...] VM: Sun Microsystems Inc. Java HotSpot(TM) 64-Bit Server VM 1.6.0_35 UP: 0:28m #THR: 22 #THRPEAK: 22 #THRCREATED: 41 USER: stevebarnes CPU: 25.36% GC: 0.00% HEAP: 76m / 455m NONHEAP: 50m / 240m Note: Only top 10 threads (according cpu load) are shown! TID NAME STATE CPU TOTALCPU BLOCKEDBY *40 DbVisAutoSaver RUNNABLE 97.33% 94.77%* 48 RMI TCP Connection(6)-10.16.95 RUNNABLE 5.56% 0.03% 49 JMX server connection timeout TIMED_WAITING 0.00% 0.00% 47 RMI TCP Connection(5)-10.16.95 RUNNABLE 0.00% 0.00% 44 JMX server connection timeout TIMED_WAITING 0.00% 0.01% 43 RMI Scheduler(0) TIMED_WAITING 0.00% 0.00% 42 RMI TCP Connection(4)-10.16.95 RUNNABLE 0.00% 0.29% 41 RMI TCP Accept-0 RUNNABLE 0.00% 0.01% 29 AWT-EventQueue-1 WAITING 0.00% 1.47% 28 DbVisEventQueue TIMED_WAITING 0.00% 0.01% This shows that DbVisAutoSaver is using 97% of 25% of my CPU... Can anyone tell me what this is ? And maybe why it is using so much CPU... ? Thanks again, Steve.
[This reply is migrated from our old forums. The original author name has been removed]

Re: CPU at 25%+ consistently
Steve Do you have more than one screen? I have 4 screens and what I noticed is, when I have any of the dbVis windows on my Primary monitor, the response is super slow and cpu usage jumps to 33-46%... as soon as I move the window off of the Primary monitor, the % drops to normal... Weird! (WindowsXP) Edited by: AlexML on Apr 4, 2013 7:29 AM