Visualização
Ainda estamos trabalhando nesse recurso, mas adoraríamos que você experimentasse!
Atualmente, esse recurso é fornecido como parte de uma prévia, de acordo com nossas políticas de pré-lançamento.
Get deep insights into your SQL Server performance with our OpenTelemetry-based monitoring solution. Track database metrics, analyze slow queries, monitor resource usage, and correlate database performance with your applications.
Essa abordagem baseada em NRDOT complementa nossa Integração On-Host (OHI) existente, utilizando padrões OpenTelemetry para monitoramento de banco de dados, facilitando a integração com sua stack de observabilidade existente.
Principais recursos:
- OpenTelemetry standards: Integrates seamlessly with existing observability tools
- Comprehensive metrics: 50+ database performance indicators
- Query-level insights: Identify and optimize slow-performing queries
- Flexible deployment: Works with self-hosted and cloud environments
- APM correlation: Connect database performance to application traces
Escolha seu método de instalação
You can install NRDOT Collector for SQL Server monitoring in following ways:
Self-hosted environments: Manual installation on your own infrastructure
AWS RDS environments: Cloud-managed SQL Server monitoring:
Instalação guiada
To install this through the New Relic UI instead, go to one.newrelic.com > Integrations & Agents > MSSQL (OpenTelemetry) . Follow the on-screen instructions to set up the integration.
Instalação em um relance
Pré-requisitos
Conta do New Relic com uma chave de licençaválida
Network connectivity between the host where you install the NRDOT Collector and your Microsoft SQL Server.
Conectividade de rede para a documentação dos endpoints OTLP da New Relic
SQL Server requirements, you'll need:
- SQL Server 2017 or later
- Administrative access to SQL Server (
sysadminrole or equivalent) - Network connectivity between collector and SQL Server on port
1433or custom port
Esta integração está disponível como parte do programa de pré-visualização pública da New Relic. Verifique com seu gerente da organização para fazer a adesão na página Previews & Trials.
For supported detailed prerequisites, refer to the dedicated prerequisites section of installation document.
Instalar o NRDOT Collector
Escolha seu caminho de instalação com base em sua infraestrutura:
Guided install: To install via New Relic UI, go to one.newrelic.com > Integrations & Agents > MSSQL (OpenTelemetry) . Follow the on-screen instructions to set up the integration. This page covers the CLI install path only.
Ambientes auto-hospedados: instalação manual em sua própria infraestrutura
Ambientes AWS RDS: monitoramento do SQL Server gerenciado na nuvem
Configure monitoring users
Create a dedicated Microsoft SQL Server user with the necessary permissions to allow the NRDOT Collector to collect metrics and query performance data. The user should have read-only access to the required.
Configurar o NRDOT Collector
Configure the NRDOT Collector to connect to your Microsoft SQL Server instance. This involves specifying the connection details, authentication method, and any additional configuration options required for your environment.
Reiniciar o NRDOT Collector
After configuring the NRDOT Collector, restart the service to apply the changes and begin collecting data from your Microsoft SQL Server instance.
Encontre e use seus dados
Once your data is being collected, you can access comprehensive SQL Server database monitoring through the New Relic UI.
Para encontrar sua entidade de banco de dados SQL Server no New Relic:
- Vá para one.newrelic.com > All capabilities > Databases.
- Na dropdown Entity type, selecione MSSQL instance e clique em Apply.
- Select your SQL Server database from the list of entities to view its dashboard, metrics, and query performance data.
Documentação relacionada
Linux instrumentation for self-hosted environments
Learn how to set up MSSQL monitoring in self-hosted Linux environments with New Relic.
Windows instrumentation for self-hosted environments
Learn how to set up MSSQL monitoring in self-hosted Windows environments with New Relic.
Referência de métricas
Saiba mais sobre as métricas disponíveis coletadas pelo NRDOT Collector.