Collect Logs and Metrics for the Microsoft SQL Server App
This page provides instructions for configuring log and metric collection for the Sumo Logic App for Microsoft SQL Server.
Collection Process Overview
Configuring log and metric collection for the SQL Server App includes the following tasks:
- Step 1: Configure Fields in Sumo Logic.
- Step 2: Configure Collection for SQL Server
Step 1: Configure Fields in Sumo Logic
Create the following Fields in Sumo Logic prior to configuring collection. This ensures that your logs and metrics are tagged with relevant metadata, which is required by the app dashboards. For information on setting up fields, see the Fields help page.
If you are using SQL Server in a non-Kubernetes environment create the fields:
- component
- environment
- db_system
- db_cluster
- pod
If you are using SQL Server in a Kubernetes environment create the fields:
- pod_labels_component
- pod_labels_environment
- pod_labels_db_system
- pod_labels_db_cluster
Step 2: Configure Collection for SQL Server
Sumo Logic supports collection of logs and metrics data from SQL Server in both Kubernetes and non-Kubernetes environments.
Please click on the appropriate links below based on the environment where your SQL Server clusters are hosted.