MSSQL by ODBC not handling default MSSQL instance correctly

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 7.0.0
    • Component/s: 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). 

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

              Created:
              Updated: