DB24 Datastore

Overview

The Datastore is the central component of the DB24 system, responsible for collecting and aggregating critical information from multiple runtimes. It serves as the focal point where all the collected data is processed, stored, and made available for reporting and action.

The Datastore runs on SQL Server, and it's possible to install and run DB24 Datastore as a sidecar on an existing SQL Server to cut license costs.

Core Functionality

1. Data Collection and Aggregation

The Datastore collects information from multiple SQL Server Runtime instances. The runtimes do not push data; rather, the Datastore actively connects and reads from them. Collection jobs run every 30 minutes.

2. Historical Data Storage

To minimize impact on runtime storage, the Datastore persists historical data collected from runtimes. This allows for long-term retention without burdening runtime environments.

3. Notifications, Alerting and Reporting

The Datastore provides intelligent notification and reporting mechanisms, monitoring data for anomalies and sending alerts for critical issues.

Connectivity and Communication

Prerequisites for proper functionality:

Network Access: Ensure Datastore can connect to SQL Server runtimes
SQL Server Agent permissions: The agent needs db_datareader role and write permission on cfg schema

Datastore's SQL Server Agent Jobs

DB24MACDataCollector_Inbound: Data collection every 2 hours
DB24MACGoodNight: Maintains Datastore health, trims old data
DB24MACNotifications: Sends notifications every 10 minutes
DB24MACRuntime_Outbound: Pushes configuration changes to Runtimes

DB24 Overview - Platform introduction
Installation Guide - Setup instructions