Preview
We're still working on this feature, but we'd love for you to try it out!
This feature is currently provided as part of a preview pursuant to our pre-release policies.
You can install the NRDOT Collector for Microsoft SQL Server monitoring using the guided install from the New Relic platform, which provides a platform-guided setup through New Relic's UI. This is the recommended approach for quick starts.
Prerequisites
Ensure your environment meets our compatibility and prerequisites.
Guided install
To install the NRDOT Collector using the guided install:
- Log in to your New Relic account.
- Go to left navigation pane > + Integration & Agents > MSSQL (OpenTelemetry).
- On the Select an account screen, select the account you want to install the MSSQL integration on, and click Continue.
- On the Enter your credential screen, select one of the following options, then click Continue:
- Use an existing key: If you already have a license key, provide the license key. For more information, refer to User keys.
- Create a new key: If you don't have a license key, click Create a new key to create one.
- On the Select platform screen, select the platform to install the MSSQL integration, and click Continue.
- Follow the on-screen instructions to set up the integration for the selected platform.
- After installation, on the Test your integration screen, click Test connection to verify that the NRDOT Collector is able to connect to your SQL Server instance and send data to New Relic.
(Optional) Set up APM-database correlation
To correlate your application performance with database operations, you can set up database service identification. This feature allows you to see exactly which applications are generating specific database workloads. For more information, refer to set up database service identification to get APM-database correlation in New Relic.
Important
To view database performance data in APM, both entities must be in the same New Relic account. If the entities are in different New Relic accounts, you must have access to both accounts to view the data.
(Optional) Configure secret management
The secret management feature allows you to securely manage sensitive information, such as database credentials. This helps to enhance the security of your monitoring setup by avoiding hardcoding sensitive data in configuration files. For more information, refer to secret management.
Find and use your data
Once your data is being collected, you can access comprehensive SQL Server database monitoring through New Relic's UI.
To find your SQL Server database entity in New Relic:
- Go to https://one.newrelic.com > All Capabilities > Databases.
- From the Entity type dropdown, select MSSQL instance, then click Apply.
- Select your SQL Server database from the list of entities.