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

MSSQL by ODBC not handling default MSSQL instance correctly

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 7.0.0
    • Templates (T)

      Steps to reproduce:

      1. Apply template to MSSQL server that has the default instance

      Result:

      Template's "Get performance counters" script does not return required values for dependant items. 

      These lines are to blame (example but there's a few similar): 

      OBJECT_NAME = 'MSSQL$' + @@servicename + ':Buffer Manager'

       

      Default unnamed instance returns:

       

      SQLServer:Buffer Manager      

       

      Versus named instance: 

       

      MSSQL$MSSQLDEV:Buffer Manager

       

      Expected:

      Template handles this scenario correctly when instance is unnamed (default). 

            mbuz Maksym Buz
            JulioQc Julien Lacasse-Roger
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: