Collect Logs and Metrics for the Microsoft SQL Server App

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

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.

• Collect Logs and Metrics for Non-Kubernetes environments.
• Collect Logs and Metrics for Kubernetes environments.