All Apps and Add-ons

Best practices MS SQL Add-On

deangoris
Explorer

Hi,

We are searching for a way to monitor our MS SQL servers.
We are already using Splunk to index logfiles on multiple web servers and I know the basics of monitoring logfiles and perfo counters through a universal forwarder. We have a deployment server to deploy the apps made for this.

I have little experience with the add-ons available on Splunk base. I installed the MS SQL server add on.
Now I'd like to hear what the best practices are to configure it for our purposes.

  • Should I make sure the complete app is deployed to our forwarders as well?
  • Should I create a new custom app, copy the usefull stuff from the SQL add-on to it, enable necessary monitors and deploy it to our forwarders? In this way I can be sure all captured data has the correct sourcetype and all prebuilt transforms etc. will work?

Any advice on how to start with this or a link to a guide will be helpful.
The information on Splunk Docs does not give me enough advice on this.

Thanks in advance,
Dean

0 Karma

sloshburch
Splunk Employee
Splunk Employee

You'll probably be most successful by following the instructions in the app's docs (linked to in the apps' details page) in regards to where to deploy the app to.

I would keep the config you need in the local folder of the MSSQL add on. Start with it there and you may build confidence to move it's config elsewhere later...but I wouldn't start that way as it can be more confusing. Also, the design of a local folder within that app is specifically meant to help with the config management thereby allowing a 'default' folder to be overwritten during updates (but not blowing away your local folder).

Make sense?

0 Karma
Get Updates on the Splunk Community!

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...

New! Splunk Observability Search Enhancements for Splunk APM Services/Traces and ...

Regardless of where you are in Splunk Observability, you can search for relevant APM targets including service ...