KS-Soft

Hello Alex, sorry for the long break. However, we were able to run some more tests. According to some stress tests we write to the database in 2ms. We tested the following drivers (with the same result): -) ODBC Driver 17 for SQL Server -) ODBC Driver 18 for SQL Server -) SQL Server Native Client 11...

Unfortunately, that's how we did it on some tests.

The connection pooling is already enabled (in Hostmonitor and in the ODBC settings)

Do you have experience with this amount of data and the MSSQL server?

I am not sure if I should do that. Are access data from servers also stored there?

Screenshot of Performance History:

i'm sorry, but how do i create the hml file?

Regards
Patrick

Hello, it is a very fresh MSSQL Server installation in a VMWare virtualization environment on the same subnet. The SQL server has 4 CPUs, 12GB RAM. The hostmonitor server has 10 CPUs, 12GB RAM. We have analyzed all logs and resources. The SQL server is constantly at 0-5% CPU utilization. So it does ...

Hello, We have around 3000 active tests and 2000 deactivated tests. We store the changes + midnight logging in a MS SQL database. Logging the changes works without any problems. Unfortunately I have a problem with the midnight logging. Apparently the logging pool should be running full during midnig...