|
| [WD20] Mantaserver unreachable |
| Iniciado por guest, 07,nov. 2016 14:28 - 6 respuestas |
| |
| | | |
|
| |
| Publicado el 07,noviembre 2016 - 14: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? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,noviembre 2016 - 17:07 |
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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,noviembre 2016 - 17:19 |
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. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,noviembre 2016 - 17:32 |
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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,noviembre 2016 - 23:46 |
Hi Stefan,
I have had a similar problem. Look here. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,noviembre 2016 - 08:36 |
Hi Michael,
it looks like a good start to first update to HFSQL v21.
Thanks! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,noviembre 2016 - 19: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. |
| |
| |
| | | |
|
| | | | |
| | |
|