Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
7
Erster Beitrag:
vor 9 Monaten, 2 Wochen
Letzter Beitrag:
vor 9 Monaten, 1 Woche
Beteiligte Autoren:
Stefan Bentvelsen, kingdr, Michael Drechsel

[WD20] Mantaserver unreachable

Startbeitrag von Stefan Bentvelsen am 07.11.2016 13:28

Hi all,

I have a customer with HFSQL-Client/Server (version 20) installed on a server with 16 GB RAM. Normally there are no real problems, but now and then the processor use goed to 25-28%, memory use to about 120 Mb. The database server is then unreachable for the clients, but also for Control Center. I have restarted the MantaServer via Task Manager to get it normal again. Without restart, it seems not to came back to normal proportions (less than 1% processor use, about 95 Mb memory use).

In the log files there are no strange entries. Maximum duration of used queries is about 8 seconds.

In my software there is an fairly heavy use of the database, by much repeated queries (with different parameters).

Any one else have had such situations? Is there an explanation for this behavier?
Are there known issues for version 20 of the database server?

Antworten:

Hi

Why don't you upgrade to hfSql 21, might be bugs on v20. I think it's safe.

Secondly, check antivirus/firewall in the server that might upset your existing
operations.

Thirdly, bring up taskmgr and check what consume mostly for CPU usage.

What hardware do you have and OS?

Sometimes, no update to the server is the best as I have tons of problems
after the update and there's no gain in speed at all.

HTH

King

von kingdr - am 07.11.2016 16:07
Hi King,

thanks for your response.

I am thinking about updating to version 21, but would like to know if there are known issues with version 20.

I will check the anti virus.

Another program consumes about 500 MB. But at the moment of the problems there was about 10 GB of 16 GB free available.

The OS is Windows Server, but I have to check what version.

von Stefan Bentvelsen - am 07.11.2016 16:19
Stefan

Pls also check if there'a any circuit/gateway changed with the ISP vs the Router
(mostly CISCO...)

16GB is too mean for server and I hope it's 64-bit as 32-bit is way too much
for trouble-shooting. I bet the Windows Server might serve as file server
database and something else. As your activities look like touching the
peak of RAM/SWAP issue causing it to slow down, I GUESS only.

We use DUAL CPU 64-bit HP Server with 32 GB RAM and works a charm.
Beside, hfSql is quite neat even you have 500MB application, it's nothing and
we 10GB data/index co-exist with sqlserver and hfSql21, works a charm.

HTH

King

von kingdr - am 07.11.2016 16:32
Hi Stefan,

I have had a similar problem. Look here.

von Michael Drechsel - am 07.11.2016 22:46
Hi Michael,

it looks like a good start to first update to HFSQL v21.
Thanks!

von Stefan Bentvelsen - am 08.11.2016 07:36
Hi Kingdr,

I've installed HFSQL server ver.21 today. Now I'll wait for what is coming from my customer.

The server is a HP Server, with Xeon CPU 64-bits, E5620, 2,40 GHz with Windows Server 2012 R2 Standard.

von Stefan Bentvelsen - am 09.11.2016 18:36
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.