Skip to main content

SQL Sentry

Supported Versions

Type

Authentication Type

<=2023.2.9

Webhook

Org Bearer Token

SolarWinds SQL Sentry provides performance monitoring for the Microsoft data platform, with fast root cause analysis and visibility. Use the SQL Sentry integration to send advisory condition monitoring events to BigPanda for correlation and enrichment.

Open Integration Manager

The Open Integration Manager is available for use with this integration. For more information, see the Open Integration Manager documentation.

Payload size

Alert payloads must be 6MB or smaller. Larger payloads will fail to process with BigPanda. We recommend reviewing your configurations to ensure that only actionable, useful information is being sent to BigPanda.

Install the Integration

Install the integration by following these steps:

Add the BigPanda webhook endpoint to the Monitoring Service settings

  1. In the Navigator pane, navigate to the Configuration heading and select Global Settings. Open the Alerting tab.

  2. Click Webhooks to expand the section.

  3. In the Endpoint Name field, enter BigPanda. In the Endpoint URL field, enter https://integrations.bigpanda.io/sqlsentry/alerts?access_token=<Your Org Bearer Token>&app_key=<Your App Key>. Leave the Secret Token field empty.

  4. Click Verify and Add. If you receive a popup that says There was a problem reaching the endpoint, click Yes to add the endpoint anyway.

  5. In the toolbar, click File and then click Save.

Enable the BigPanda endpoint for an Advisory Condition

  1. Select an Advisory Condition that is configured with the Send to Alerting Channels action.

  2. Click the Action Settings tab.

  3. Ensure the BigPanda channel is enabled in the Channels list.

The BigPanda integration is now enabled for this Advisory Condition. Events for this condition will be automatically sent to BigPanda.

Uninstall the Integration

Deleting an integration requires that you remove the integration in both the integrated system and BigPanda. We recommend that you first uninstall the integration on the integrated system to prevent traffic from being sent and rejected by BigPanda, since the app key will not exist once you delete the integration in BigPanda.

Caution during replacement

When replacing an existing integration with a new tool or system, we recommend configuring the new integration first to ensure no data is lost.

Deactivate Inbound Integration

If you want to stop sending data to BigPanda but don’t want to delete your integration, you can temporarily deactivate it.

To deactivate an inbound integration:

  1. In BigPanda, navigate to the Integrations tab and select the desired integration from the list. This will open integration details on the right side of the window.

  2. At the top of the integration details, click the Active/Inactive toggle next to the application name to change the status of the integration.

In the integrations list, inactive integrations will be marked with a gray bar.

Alert resolution for inactive integrations

Any active alerts belonging to an inactive integration must be manually resolved or they will stay in the system until the auto-resolve window is reached.

Stop Sending Data to BigPanda

Within the integrated system, disable any settings that send data to BigPanda.

Each system requires specific changes to disable the integration with BigPanda. For example, you must delete the topic in CloudWatch, and you must disable the alert channel in New Relic. To determine the changes for your integrated system, reference the relevant documentation or contact BigPanda support.

Manually resolve any open alerts sent from the integration to remove the associated incidents from your incident feed. These incidents will not automatically resolve without an ok status from the original sending integration.

Delete the Integration in BigPanda

Take the following steps to delete the integration from BigPanda:

  1. In BigPanda, navigate to the Integrations tab and select the desired integration from the list.

  2. In the integration details on the right of the page, click the trash icon, then confirm you want to delete the integration. The integration will be removed immediately.

️Automatic alert resolution for deleted integrations

All active alerts from the integration will be resolved after deletion.

Data removal

This procedure does not remove any data from the integrated system.

In this section: