-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
5.4.4
-
Windows Server 2016
SQL Server 2017 CU23
CPU : 4
RAM 20Go
30 DataBases
23 Availability groups (Which we will reduce to 5 with the purchase of the enterprise version of MSSQL)
Description :
We have installed the MSSQL By ODBC Template DB on 2 AAG servers with
- 30 DataBases
- 23 Availability groups (Which we will reduce to 5 with the purchase of the enterprise version)
with the default value
Result :
After 1 hour of using zabbix we had the following results (see image1):
- 2990 login / 2990 logout
- launched 5760 requests to recover the health of the server and databases
The number of queries executed depends on the number of groups and databases and increases very quickly