Manage Microsoft SQL Server extensions

Dynatrace provides you with a framework that you can use to extend your application observability into data acquired directly from your Microsoft SQL Database layer, so that you can monitor how database server tasks impact your app.

Start by checking Dynatrace Hub to see if the Dynatrace-provided Microsoft SQL Server extension satisfies your requirements. If you need something different, you can build your own Microsoft SQL Server extension.

Before you begin

Designate an ActiveGate group or groups that will remotely connect to your Microsoft SQL Database server to pull data. All ActiveGates in each designated group need to be able to connect to your Microsoft SQL Database server.

Manage Microsoft SQL extensions

Extensions

Extension Manager

Latest Dynatrace

Now you can use the dedicated Extensions app to manage your extensions. It provides a similar activation and configuration workflow as Dynatrace Hub in the previous Dynatrace. Additionally, it gives you direct access to extension health monitoring.

  • To use the app:
    • In Dynatrace Hub Hub, select and install the app.
    • The Hub listing provides information on the permissions required to use the app (the Technical information tab).

Dynatrace Hub provides a unified workflow to enable and manage extensions that ingest Microsoft SQL Server data into your Dynatrace environment.

Required permission: Change monitoring settings

  1. In Dynatrace Hub, select and install the Microsoft SQL Server extension. This enables the extension in your environment.
  2. Add a monitoring configuration so that the extension can begin collecting data.
Step 1

Define endpoints

Step 2

Select ActiveGates

Step 3

Activate the extension

Step 1 Define endpoints

  1. Select Add Sql Server endpoint to define the servers from which you want to pull data. You can define up to 100 endpoints. Provide the following connection details:

    • Host

    • optional Port

    • optional Instance name

    • optional Database name

    • Authentication scheme. You can choose from the following authentication schemes:

      • Basic authentication
      • Kerberos authentication
      • NTLM authentication

    • You can enable SSL to establish a secure connection for your configuration.

    • You can use credential vault to provide a more secure approach of storing and managing user credentials.

  2. Select Next step.

Step 2 Select ActiveGates

  1. Select the ActiveGate group to determine which ActiveGates will run the extension.
  2. Select Next step.

Step 3 Activate the extension

  1. Give your monitoring configuration a distinctive label in Description.
  2. Select Activate.

Monitoring configuration as JSON

The extension activation wizard contains a dynamically updated JSON payload with your monitoring configuration. To learn how to use it to activate an extension using the Dynatrace API, see Extensions 2.0 lifecycle.