LLI Wiki — My Digital Knowledge Base

SQL Server activity monitoring (Guardium): pre-deployment questions

Checklist of questions to ask the vendor before deploying a database audit and monitoring tool on SQL Server.

This checklist gathers the questions to ask a vendor before deploying a database activity monitoring tool (for example IBM Guardium and its STAP agent) on a mixed SQL Server estate. It gives no answers: it is a preparation base for the discussion with the vendor.

Estate compatibility

Data collection

Database options

Recovery

Resources and performance

High availability (Always On)

Example topology to document before deployment: four nodes across two sites (one active read/write node and one passive backup node on site 1; one passive read-only reporting node and one passive spare on site 2), each node connected to three networks (management, heartbeat, application).

Data masking

Auditing

Mastodon LLIMastodon SocialFosstodon