Create sqlserver probe configuration package to apply changes en masse

book

Article ID: 205596

calendar_today

Updated On:

Products

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

We have to edit one checkpoint logfile_usage threshold as 10 from 90. Please describe how to create this new configuration package for the sqlserver probe. 

Environment

Release : 9.0.2

Component : UNIFIED INFRASTRUCTURE MGMT

Resolution

1. To create a new sqlserver probe configuration package to edit one threshold for the checkpoint logfile usage to a value of 10 (from the default of 90), you can make the changes to the logfile_usage checkpoint threshold value in one instance of the probe, using the same OS for the source and destination of the changes, e.g., Windows.

2. Then simply drag and drop the existing sqlserver package from a system with the same OS, into the local archive and rename the package with a name that makes sense for what you're trying to do that you'll remember, e.g., sqlserver_edit_logfile_usage_ckpt, then click Ok.

3. Then open the new package in the local archive.

4. Choose rt-click on the sqlserver_monitor.cfx and "Save File as..." then save it to your Desktop for editing.

5. Open it with Notepad for editing and change the value(s) you want to change. For example, in this particular case, all you really need are the logfile_usage sections - there are multiple sections. You can ignore the rest, e.g., messages section/setup section, etc.

6. Then save the file as 'All Files' not a .txt, leaving it as a .cfx file with name as sqlserver_monitor.cfx. The cfx format allows the new cfg changes to be merged.

7. Rt-Click and delete the existing sqlserver_monitor.cfx that's in the package.

8. Drag and drop the new sqlserver_monitor.cfx probe package file into your new configuration package.

9. Then click Ok.

10. Deploy the finished package to one instance of the sqlserver probe then check to confirm the changes. If all of the changes are as expected, you can go ahead and drag and drop the package onto 'like' OS systems.

Please find attached a new sqlserver_monitor.cfx file where the logfile_usage is set to be active, and the threshold is set to 10 - changed from the default of 90. This will affect the groups, profile and template sections for the logfie_usage checkpoint.

The file contents are also referenced with some highlighting of changes below.

Additional Information

<groups> overwrite
   <UMP> overwrite
      <logfile_usage> overwrite
            active = yes
            send_alarm = no
            description = Monitors free space in log files
            qos = no
            qos_list = yes
            clear_msg = logfile_usage_1
            clear_sev = clear
            interval = 
            sql_timeout = 
            scheduling = rules
            use_exclude = no
            use_include = no
            samples = 1
            key = $db_name
            <thresholds> overwrite
               <default> overwrite
                  <0> overwrite
                     tagid = 0
                     value = 10
                     unit = 
                     sev = major
                     msg = logfile_usage_2
                     condition = <=
                     clear_msg = logfile_usage_1
                     key_col_name = 
                     key_col_value = default
                  </0>
               </default>
            </thresholds>
            <qos_lists> overwrite
               <0> overwrite
                  qos_name = logfile_usage
                  qos_desc = SQL Server Log-file Usage
                  qos_unit = %
                  qos_abbr = %
                  qos_max = 100
                  qos_value = free_pct
                  qos_key = $db_name
               </0>
            </qos_lists>
         </logfile_usage>
      <logfile_usage> overwrite
            active = yes
            send_alarm = no
            description = Monitors free space in log files
            qos = no
            qos_list = yes
            clear_msg = logfile_usage_1
            clear_sev = clear
            interval = 
            sql_timeout = 
            scheduling = rules
            use_exclude = no
            use_include = no
            samples = 1
            key = $db_name
            <thresholds> overwrite
               <default> overwrite
                  <0> overwrite
                     tagid = 0
                     value = 10
                     unit = 
                     sev = major
                     msg = logfile_usage_2
                     condition = <=
                     clear_msg = logfile_usage_1
                     scheduling = 
                     key_col_name = 
                     key_col_value = default
                  </0>
               </default>
            </thresholds>
            <qos_lists> overwrite
               <0> overwrite
                  qos_name = logfile_usage
                  qos_desc = SQL Server Log-file Usage
                  qos_unit = %
                  qos_abbr = %
                  qos_max = 100
                  qos_value = free_pct
                  qos_key = $db_name
               </0>
            </qos_lists>
         </logfile_usage>
      <logfile_usage> overwrite
            active = yes
            send_alarm = no
            description = Monitors free space in log files
            qos = no
            qos_list = yes
            clear_msg = logfile_usage_1
            clear_sev = clear
            interval = 
            sql_timeout = 
            scheduling = rules
            use_exclude = no
            use_include = no
            samples = 1
            key = $db_name
            <thresholds> overwrite
               <default> overwrite
                  <0> overwrite
                     tagid = 0
                     value = 10
                     unit = 
                     sev = major
                     msg = logfile_usage_2
                     condition = <=
                     clear_msg = logfile_usage_1
                     scheduling = 
                     key_col_name = 
                     key_col_value = default
                  </0>
               </default>
            </thresholds>
            <qos_lists> overwrite
               <0> overwrite
                  qos_name = logfile_usage
                  qos_desc = SQL Server Log-file Usage
                  qos_unit = %
                  qos_abbr = %
                  qos_max = 100
                  qos_value = free_pct
                  qos_key = $db_name
               </0>
            </qos_lists>
         </logfile_usage>
    <logfile_usage> overwrite
      active = yes
      send_alarm = no
      description = Monitors free space in log files
      qos = no
      qos_list = yes
      clear_msg = logfile_usage_1
      clear_sev = clear
      scheduling = rules
      column = free_pct
      key = $db_name
      exclude_defs = yes
      include_defs = yes
      use_exclude = no
      use_include = no
      condition = <=
      samples = 1
      msg_variables = $check.x;$profile.x;$instance.x;$db_name.c;$free_pct.n;$allocated.b;$max.b;$used.b;$logsize.b;$unlimited.x
      type = 1
      interval = 
      sql_timeout = 
      <qos_lists> overwrite
         <0> overwrite
            qos_name = logfile_usage
            qos_desc = SQL Server Log-file Usage
            qos_unit = %
            qos_abbr = %
            qos_max = 100
            qos_value = free_pct
            qos_key = $db_name
         </0>
      </qos_lists>
      <thresholds> overwrite
         <default> overwrite
            <0> overwrite
               tagid = 0
               value = 10
               unit = 
               sev = major
               msg = logfile_usage_2
               condition = <=
               clear_msg = logfile_usage_1
               scheduling = rules
               key_col_name = 
               key_col_value = default
            </0>
         </default>
      </thresholds>
   </logfile_usage>
<logfile_usage> overwrite
   active = yes
   send_alarm = no
   description = Monitors free space in log files
   qos = no
   qos_list = yes
   clear_msg = logfile_usage_1
   clear_sev = clear
   interval = 
   sql_timeout = 
   scheduling = rules
   use_exclude = no
   use_include = no
   samples = 1
   key = $db_name
   <thresholds> overwrite
      <default> overwrite
         <0> overwrite
            tagid = 0
            value = 10
            unit = 
            sev = major
            msg = logfile_usage_2
            condition = <=
            clear_msg = logfile_usage_1
            key_col_name = 
            key_col_value = default
         </0>
      </default>
   </thresholds>
   <qos_lists> overwrite
      <0> overwrite
         qos_name = logfile_usage
         qos_desc = SQL Server Log-file Usage
         qos_unit = %
         qos_abbr = %
         qos_max = 100
         qos_value = free_pct
         qos_key = $db_name
      </0>
   </qos_lists>
</logfile_usage>