Nimsoft sybase monitoring is flooding the DB with multiple connections

book

Article ID: 144519

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

Please be informed that we have configured Sybase monitoring for one of our customer DB. However, the customers are complaining that the users are not able to access the DB as the our Sybase monitoring profile is flooding the DB with high number of connection around 600++ connection. We have checked from our end and the Sybase monitoring has been configured correctly.

Cause

- access/permissions

Environment

Release : 8.51

Component : UIM - SYBASE

Sybase probe version : 4.31

Sybase Adaptive Server Enterprise/15.7/EBF 27353 SMP SP139 /P/x86_64/Enterprise Linux/ase157sp138x/4041/64-bit/FBO/Tue Aug  8 05:53:20 2017|

Resolution

Please see:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sybase-sybase-monitoring/sybase-ac-configuration/sybase-ac-gui-reference.html

 User ID: specifies the authorized user identification code to the server.
 
The user MUST HAVE access to run selects against syslisteners.

   "SELECT permission denied on column address_info of object syslisteners, database master, owner dbo"

Are you able to run the following as the current database user or an admin user?

   select address_info from syslisteners?

Object rights required:

    sysdatabases
    spt_values
    sysusgaes
    sysprocesses
    syscurconfigs
    sysconfigures

As well as SELECT permission  on column address_info of object syslisteners, database master.