InfraSonar Microsoft SQL Probe

Environment variable

Variable	Default	Description
AGENTCORE_HOST	127.0.0.1	Hostname or Ip address of the AgentCore.
AGENTCORE_PORT	8750	AgentCore port to connect to.
INFRASONAR_CONF	/data/config/infrasonar.yaml	File with probe and asset configuration like credentials.
MAX_PACKAGE_SIZE	500	Maximum package size in kilobytes (1..2000).
MAX_CHECK_TIMEOUT	300	Check time-out is 80% of the interval time with MAX_CHECK_TIMEOUT in seconds as absolute maximum.
DRY_RUN	none	Do not run demonized, just return checks and assets specified in the given yaml (see the Dry run section below).
LOG_LEVEL	warning	Log level (debug, info, warning, error or critical).
LOG_COLORIZED	0	Log using colors (0=disabled, 1=enabled).
LOG_FMT	%y%m%d %H:%M:%S	Log format prefix.

Docker build

docker build -t mssql-probe . --no-cache

Config

mssql:
  config:
    username: "my_account@domain"
    password: "my_password"

Dry run

Available checks:

• agentalerts
• agentjobs
• avgtaskcount
• bufferpoolusage
• cpustats
• dbinstances
• dbperfcounters
• dbtracestatus
• drivelatency
• filelatency
• hardware
• heaptables
• indexchange
• indexfragmentation
• indexusage
• instanceconfig
• instanceperfcounters
• lastbackups
• logicalqueryreads
• logshipping
• logshippinglog
• memoryconsumers
• memorydistribution
• memorydumps
• missingindexes
• numa
• oldstatistics
• osmemory
• pagelifeexpectancy
• pendingmemorygrants
• plancache
• processaddressspace
• recoverymodel
• sessions
• sqlservices
• system
• tablesizes
• topexecutedqueries
• topqueryio
• topworkertimequeries
• unusedindexes
• volumes
• waitstats

Create a yaml file, for example (test.yaml):

asset:
  name: "foo.local"
  check: "system"
  config:
    address: "192.168.1.2"
    port: 1433  # not required, default MSSQL port is 1433

Run the probe with the DRY_RUN environment variable set the the yaml file above.

DRY_RUN=test.yaml python main.py