Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-19970

High CPU usage with Template DB MSSQL By ODBC

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 5.4.4
    • Templates (T)
    • 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

       

            zabbix.support Zabbix Support Team
            hrescourio Hervé RESCOURIO
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: