• English日本語한국어
  • Log inStart now

Microsoft SQL Server monitoring integration

Our Microsoft SQL Server integration collects and sends inventory and metrics from your MS SQL Server environment to our platform, where you can see the health of your MS SQL Server environment. We collect both database and instance-level metrics so that you can pinpoint the source of any problems.

To install the Microsoft SQL Server integration, you must run through the following steps:

  1. Install and activate the integration.
  2. Enable your Microsoft SQL Server.
  3. Configure the integration.
  4. Find and use data.
  5. Optional: Use Microsoft SQL Server's configuration settings.

Compatibility and requirements

Microsoft SQL Server versions

Our integration is compatible with Microsoft SQL Server versions from 2014 to 2022.

TLS Support

We require TLS authentication to be a minimum version of TLS 1.2.

Supported operating systems

  • Windows Windows
  • Linux Linux

For a comprehensive list of specific Windows versions, check the table of compatible operating systems.

System requirements

  • A New Relic account. Don't have one? Sign up for free! No credit card required.

  • The infrastructure agent installed.

  • Install the infrastructure agent on a Linux or Windows OS host, or on a host capable of remotely accessing where SQL Server is installed.

  • Requires SQL Server user or domain user with user privileges for both CONNECT and VIEW SERVER STATE, and READ access permissions.

Install and activate the integration

To install the Microsoft SQL Server integration, follow the instructions for your environment:

Windows installation

  1. Download the latest .MSI installer image for your environment:
  1. In an administrator account, run the install script using an absolute path. Use the corresponding example for your environment:

  2. Go to C:\Program Files\New Relic\newrelic-infra\integrations.d\ and rename the mssql-config.yml.sample file to mssql-config.yml.

  3. Edit the mssql-config.yml configuration file with your favorite editor. Check out some configuration file examples..

Linux installation

  1. Install the infrastructure agent, and replace the INTEGRATION_FILE_NAME variable with nri-mssql.

  2. Change the directory to the integrations configuration folder by running:

    bash
    $
    cd /etc/newrelic-infra/integrations.d
  3. Copy the sample configuration file by running:

    bash
    $
    sudo cp mssql-config.yml.sample mssql-config.yml
  4. Edit the mssql-config.yml configuration file with your favorite editor. Check out some configuration file examples..

Enable your Microsoft SQL Server

For the Microsoft SQL Server to be monitored, you need a user with CONNECT, VIEW SERVER STATE, and read access permissions.

Tip

Check the Microsoft documentation for details on creating logins and users in Microsoft SQL Server.

Create a new login and grant the necessary permissions:

Did this doc help with your installation?

Configure the integration

Edit the config in the integration's YAML config file, mssql-config.yml. An integration's YAML-format configuration is where you can place required login credentials and configure how data is collected. Which options you change depend on your setup and preference. You can check our example configuration files.

The configuration file has common settings applicable to all integrations like interval, timeout, inventory_source. To read all about these common settings refer to our Configuration Format document.

Important

If you're still using our Legacy configuration and definition files, refer to this document for help.

mssql-config.yml sample files

Configuration options for the integration

For more on how to find and use your data, see Microsoft SQL Server's configuration settings.

Find and use data

To find your integration data, go to one.newrelic.com > All capabilities > Infrastructure > Third-party services and select one of the Microsoft SQL Server integration links.

Microsoft SQL Server data is attached to the following event types:

For more on how to find and use your data, see Understand integration data.

Metrics collected by the integration

The Microsoft SQL Server integration collects the following metric data attributes. Some metric name are prefixed with a category indicator and a period, such as asserts. or flush..

Copyright © 2024 New Relic Inc.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.