Agent and Sensors

 View Only
  • 1.  What is the approach to adding Instana to help with MSSQL and Oracle DB efficiency at Scale

    Posted Fri February 03, 2023 02:56 PM
    https://www.ibm.com/docs/en/instana-observability/current?topic=technologies-monitoring-microsoft-sql-server. so this explains if you install the agent on the host - then you can configure it to inspect the MSSQL DBs - but is there any guidance on the WHOLE APPROACH. are there guidance or architecture advice?
    Business Case: How to you add instana to multiple hosts and configure it for the DBs on those hosts without it being a manual process? And then a little wrinkle - how do you keep the credentials updated - when the security team wants to rotate those creds every 90 days.
    So - if you've been able to implement and configure at scale - I'd love to know.

    ------------------------------
    Jim Bragg
    ------------------------------


  • 2.  RE: What is the approach to adding Instana to help with MSSQL and Oracle DB efficiency at Scale

    Posted Mon February 06, 2023 10:05 AM
    Hi Jim,

    We use SaltStack, with a formula. that installs the agent and lays down the configuration file(s) as needed.  If you have another Configuration Management System/Tool it should be able to do the same.  We re-apply the state when the configuration (including passwords) needs to change.

    -Brooke

    ------------------------------
    Brooke Hedrick
    ------------------------------



  • 3.  RE: What is the approach to adding Instana to help with MSSQL and Oracle DB efficiency at Scale

    Posted Sat March 11, 2023 09:45 PM

    Agree with you



    ------------------------------
    Paul Glenn
    ------------------------------



  • 4.  RE: What is the approach to adding Instana to help with MSSQL and Oracle DB efficiency at Scale

    Posted Tue February 07, 2023 09:49 AM
    Edited by Brooke Hedrick Tue February 07, 2023 09:50 AM
    Also, you specifically called out "at scale."  Without knowing what that means to you, I can tell you we are managing about 550 Instana agents this way for any of the customized configuration.

    ------------------------------
    Brooke Hedrick
    ------------------------------



  • 5.  RE: What is the approach to adding Instana to help with MSSQL and Oracle DB efficiency at Scale

    Posted Tue February 07, 2023 09:55 AM
    WOW!  ok - that's good enough on the "scale" comment.  And the other part, you've answered that question -  they're going to need a software management tool like SaltStack with a level of sophistication to handle credential rotation.

    ------------------------------
    Jim Bragg
    ------------------------------



  • 6.  RE: What is the approach to adding Instana to help with MSSQL and Oracle DB efficiency at Scale

    Posted Tue February 07, 2023 10:37 AM
    Ansible, Puppet, and Chef are also popular configuration management tools.

    https://www.softwaretestinghelp.com/top-5-software-configuration-management-tools/

    ------------------------------
    Brooke Hedrick
    ------------------------------