Microsoft SQL Server π
The Splunk Distribution of the OpenTelemetry Collector uses the Smart Agent receiver with the Microsoft SQL Server monitor type to send metrics from Microsoft SQL Server instances.
Note
To monitor Microsoft SQL server instances with the OpenTelemetry Collector using native OpenTelemetry refer to the Microsoft SQL server receiver component.
Benefits π
After you configure the integration, you can access these features:
View metrics. You can create your own custom dashboards, and most monitors provide built-in dashboards as well. For information about dashboards, see View dashboards in Splunk Observability Cloud.
View a data-driven visualization of the physical servers, virtual machines, AWS instances, and other resources in your environment that are visible to Infrastructure Monitoring. For information about navigators, see Use navigators in Splunk Infrastructure Monitoring.
Access the Metric Finder and search for metrics sent by the monitor. For information, see Search the Metric Finder and Metadata catalog.
Installation π
Follow these steps to deploy this integration:
Deploy the Splunk Distribution of the OpenTelemetry Collector to your host or container platform:
Configure the integration, as described in the Configuration section.
Restart the Splunk Distribution of the OpenTelemetry Collector.
Authentication π
This integration supports Windows and SQL authentication. Windows authentication is the default option. If you canβt authenticate with Windows, use SQL authentication instead.
Windows authentication uses the local system account to access the Microsoft SQL Server.
SQL authentication uses an account that you configure for the integration. See Microsoft SQL authentication.
Microsoft SQL authentication π
To use the integration, you need to create login credentials in the Microsoft SQL Server host. To create this login, follow these steps:
Log in as an administrator.
Start an SQL client.
Enter the following commands:
USE master;
GO
CREATE LOGIN [<user_id>] WITH PASSWORD = '<YOUR PASSWORD HERE>';
GO
GRANT VIEW SERVER STATE TO [<user_id>];
GO
GRANT VIEW ANY DEFINITION TO [<user_id>];
GO
Configuration π
To use this integration of a Smart Agent monitor with the Collector:
Include the Smart Agent receiver in your configuration file.
Add the monitor type to the Collector configuration, both in the receiver and pipelines sections.
See how to Use Smart Agent monitors with the Collector.
See how to set up the Smart Agent receiver.
For a list of common configuration options, refer to Common configuration settings for monitors.
Learn more about the Collector at Get started: Understand and use the Collector.
Example π
To activate this integration, add the following to your Collector configuration:
receivers:
smartagent/sqlserver:
type: telegraf/sqlserver
... # Additional config
Next, add the monitor to the service.pipelines.metrics.receivers
section of your configuration file:
service:
pipelines:
metrics:
receivers: [smartagent/sqlserver]
Example: Microsoft SQL Server receiver π
The following is an example of a Microsoft SQL Server receiver configuration:
receivers:
smartagent/sqlserver:
type: telegraf/sqlserver
host: <host_name>
port: 1433
userID: <user_id>
password: <password>
appName: sqlserver
Configuration settings π
The following table shows the configuration options for the Microsoft SQL Server monitor:
Option |
Required |
Type |
Description |
---|---|---|---|
|
yes |
|
|
|
yes |
|
|
|
no |
|
UserID used to access the SQL Server instance. |
|
no |
|
Password used to access the SQL Server instance. |
|
no |
|
|
|
no |
|
|
|
no |
|
|
|
no |
|
|
|
no |
|
|
Metrics π
This integration provides a set of metrics. Note that some metrics might depend your type of your database instance:
Notes π
To learn more about the available in Splunk Observability Cloud see Metric types
In host-based subscription plans, default metrics are those metrics included in host-based subscriptions in Splunk Observability Cloud, such as host, container, or bundled metrics. Custom metrics are not provided by default and might be subject to charges. See Metric categories for more information.
In MTS-based subscription plans, all metrics are custom.
To add additional metrics, see how to configure
extraMetrics
in Add additional metrics
Troubleshooting π
If you are a Splunk Observability Cloud customer and are not able to see your data in Splunk Observability Cloud, you can get help in the following ways.
Available to Splunk Observability Cloud customers
Submit a case in the Splunk Support Portal .
Contact Splunk Support .
Available to prospective customers and free trial users
Ask a question and get answers through community support at Splunk Answers .
Join the Splunk #observability user group Slack channel to communicate with customers, partners, and Splunk employees worldwide. To join, see Chat groups in the Get Started with Splunk Community manual.
TCP/IP is deactivated π
In some Windows-based SQL Server instances, TCP/IP has been deactivated by default. You might encounter this in a Microsoft Azure service instance. If you see error messages similar to Cannot read handshake packet: read tcp: wsarecv: An existing connection was forcibly closed by the remote host.
, you need to explicitly activate TCP/IP for the instance.
Verify agent configurations are correct.
In your SQL Server instance, activate TCP/IP. To do this, select Start, then Administrative Tools, then Computer Management.
In the Computer Management sidebar, select , then , then .
Select
.In the protocol list, right-click the TCP/IP protocol and select Enable.