Prerequisites to add DB Monitors

1. Firewall rules to be opened for appropriate DB Ports
2. Need Username, DB Name, DB Port and Password
3. DB Privileges

Need to grant “SELECT & EXECUTE” privileges for the below System Tables/Views/Stored Procedures to the DB user account used in NetGain

• The login to be used in NetGain has to be a member of the sysadmin role in order to perform the actions. By default, during setup it is supposed to ask you, accounts to be added to sysadmin group . If not, you'll need to login with something else (sa for example) in order to grant yourself the permissions.
• SELECT and Execute permissions must be given to user level and not to group level.

Oracle

• ctx_user_index_errors

• dba_data_files

• dba_free_space

• dba_jobs

• dba_objects

• dba_rollback_segs

• dba_scheduler_running_jobs

• dba_tablespaces

• dba_temp_files

• dba_users

• gv$instance

• gv$sysstat

• v$archived_log

• v$backup

• v$database

• v$datafile_header
• v$diag
• v$diag_info

• v$dispatcher

• v$dispatcher_rate

• v$filestat

• v$flash_recovery_area_usage

• v$latch

• v$librarycache

• v$license

• v$lock

• v$locked_object

• v$log

• v$logfile

• v$parameter

• v$pq_sysstat

• v$process

• v$px_session

• v$recovery_file_dest

• v$resource_limit

• v$rollname

• v$rollstat

• v$rowcache

• v$session

• v$sesstat

• v$sgastat

• v$shared_pool_reserved

• v$shared_server_monitor

• v$sort_usage

• v$sqlarea

• v$sqltext_with_newlines

• v$statname

• v$sysmetric

• v$sysstat

• v$system_event

• v$temp_space_header
• v$session_longops
• sys.dba_rollback_segs
• v$rollname
• v$rollstat.extents
• v$rollstat.rssize
• v$rollstat.xacts
• v$rollstat.gets
• dba_scheduler_running_jobs
• v$session_wait
• v$sort_usage sort
• v$sql

MSSQL

•        sys.sysperfinfo
•        sp_monitor
•        sys.databases
•        sysdatabases ( for MSSQL 2000)
•        sys.database_files
•        sys.filegroups
•        sysfilegroups ( for MSSQL 2000)
•        sysfiles
•        msdb..sysjobhistory
•        sys.dm_os_performance_counters
•        sys.dm_exec_sessions
•        sysprocesses
•        sys.messages
•        sysmessages
•        msdb..sysjobs
•       syscacheobjects
•       sysobjects
•       sysindexes
•       sys.dm_tran_database_transactions
  

Sybase

•        master.dbo.sysmonitors
•        master.dbo.sysengines
•        master.dbo.sysdatabases
•        master.dbo.monOpenDatabases
•        sp_cacheconfig
•        master.dbo.sysprocesses
•        sp_monitor
•        sp_spaceused
•        sp_lock
•        sp_helpsegment
•        master.dbo.monDeviceIO
•        master.dbo.monCachePool
•        master.dbo.monDataCache
•        master.dbo.sysmessages
•        master.dbo.monNetworkIO
•        master.dbo.sysindexes
•        master.dbo.sysobjects
•        master.dbo.monProcedureCache
•        master.dbo.systransactions
•        master.dbo.sysmonitors

DB2

•        SNAPSHOT_BP
•        SNAPSHOT_DATABASE
•        sysibmadm.dbcfg
•        SNAPSHOT_TBS_CFG
•        SNAP_GET_DBM
•        admin_list_hist()
•        SNAP_GET_BP
•        SNAP_GET_DB
•        SYSIBMADM.SNAPDB
•        SYSIBMADM.APPLICATIONS
•        SNAP_GET_LOCK
•        sysibmadm.SNAPAPPL_INFO
•        SNAP_GET_TBSP_PART