-
Type:
Problem report
-
Resolution: Won't fix
-
Priority:
Trivial
-
None
-
Affects Version/s: 5.4.4
-
Component/s: Templates (T)
-
Environment: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
