Skip to main content

Auditing

Monitor data and minimize costly downtime.

Clearpath packages a highly rated, third-party SQL server auditing appliance with its data warehouse solution that expeditiously monitors server activity and quickly alerts administrators of problems.

Real-time monitoring​

  • Captures and generates detailed access logs of server activity and user access
  • Monitors the server's health and performance
  • Sends instant alerts to a central console or mobile device

Fast diagnosis and remediation​

  • Provides a diagnostics solution
  • Identifies performance bottlenecks

Easy trend spotting​

  • Stores historical performance data in a central repository for strategic analysis of long-term trends and capacity
  • Diagnoses historical server performance problems

Secure data collection​

  • Provides simple, secure data collection from a background service
  • Does not install agents or components of any kind on the monitored servers

Common users​

  • Database administrators (DBAs)
  • Data warehouse directors or managers
  • Data warehouse personnel (e.g., data architects)
  • Compliance departments (e.g., audit log inquiries)

Typical setup​

The auditing appliance can be configured for a variety of database setups. A typical client setup in the Clearpath Analytics Platform separates production and development data warehouse servers, each reporting to a central audit repository server that an administrator reviews from a management console.

Auditing architectureA production data warehouse server and a development data warehouse server, each with its own databases, both report to a central audit repository server, which is reviewed from a management console workstation.Production serverData warehouse databasesDevelopment serverData warehouse databasesAudit repository serverCentral audit log storageManagement consoleReviewed by an administrator