Stress Levels Calculator Tool

The ControlUp Stress Levels calculator gives ControlUp admins a better understanding of what to configure in their stress level settings. For details on how to configure stress levels, see Stress Settings.

Intro

The Stress Levels Calculator is a tool that you access from the ControlUp script library. You import your ControlUp monitoring data from Insights and from the console into the tool. The tool then calculates at what levels you should be setting your stress levels in the ControlUp Console based on actual data from your own ControlUp monitored environment. 

The calculations provided by the tool are recommendations and not requirements and can be changed in the configuration file described below. The tool uses the following levels as defaults for its recommendations:

Percentile Threshold Level
75% Yellow
90% Red

You should think about your ControlUp data and decide for which metrics you want to adjust stress levels. For example, you may want to see how your Sessions - Activity data performs and use the calculator to decide which stress levels would work best for that data. Or you may want to see CPU usage or how other resources perform.

You can export data from:

  • Monitor data - for data coming directly from the monitor. Best for dynamic, shorter duration data that can change during a session, where you need frequent snapshots of what's happening. For example, CPU usage or other resources.
  • Insights data - for data that is best calculated over time. For example logon duration or session activity that is calculated per session and has more interesting data over time.

The data you select to export for the tool should depend on which stress levels are most important for your organization to capture accurately.

Prepare ControlUp Data for Export

To get your data into the calculator tool, you first have to prepare the data from ControlUp for export.

While the Stress Levels Calculator can work against any CSV file that contains the right header, the following are the metrics for which it is recommended to run the tool. 

Monitor Data (via the Console)

Hosts:

  • Active memory
  • Consumed memory
  • CPU Usage %

Sessions:

  • CPU
  • Memory (working and private bytes)
  • GPU Encoder and Decoder Utilization
  • GPU Frame Bugger Utilization
  • Non-paged Pool Memory
  • Memory Utlization
  • Pages / Sec
  • Virtual Disk read or write IOPS

Folders:

  • Average CPU Usage
  • Average Machine Memory Utilization
  • Hosts CPU
  • Hosts Memory

Insights Data

User Sessions Activity:

InsightsDataUserSessions.png

Machine Statistics:

InsightsDataMachineStatistics.png

Monitor Data - Export via Console

Use monitor data for shorter durations where you would benefit from seeing frequent snapshots of what's happening in your environment.

As part of the monitor data export, you must define a time period and interval for which you find the monitor data relevant. We recommend exporting data of the busiest times of the day per minute for a full hour per minute so you can set stress levels at the most 'stressful' times. 

  1. To store and export monitor data, you must have a file share where one of your shared credentials has write access.
  2. Open the Real-Time Console and in the menu ribbon, select Settings > Monitors.
  3. Select Monitor Settings. MonitorSettings.jpg
  4. Select Export Schedule > Add Export Rule... AddExportRule.jpg
  5. In the Add Export Rule dialog, select the Export view from the dropdown options. These include the contextual views you can view in the console, such as Folders, HostsSessions. AddExportRuleDialog.jpg
    Note: The data exported is always based on the Default preset of the Column Presets. ColumnPreset.jpg
  6. Select the relevant Days of the week, Start time, End time and Interval.
    Tip: We recommend selecting 1 minute intervals over an hour period during your busiest time of day.
  7. Repeat these steps to create an export rule for each view you want to export. Each schedule you create is added to the list of Export Schedules. You can identify your schedule by the view and times selected. 
    You can use the X icon to delete the schedule or the pencil icon to edit it.
  8. Enter a shared file location as the Reports Directory and the credentials to use to access that shared file location.
    Note: The location you select must be a shared location so that all the monitors in your ControlUp site/environment can report their data and write to this location. ReportsDirectory.jpg
  9. Once you have gathered the data, we recommend copying the files to a system with fast SSDs and high CPU speed to process them faster.

Insights Data

Use Insights to export data that is more interesting for you over a longer period of time, for example session data.

  1. Log into Insights and go to the report for the data you want to export, for example Sessions - Activity.
  2. Select a data range that represents a good example of the data you want to use as a representation of stress levels, for example 1W for one workweek. You can also select a specific range using the calendar.InsightsStressActivityRange.png
  3. Select Export > CSV. InsightsStressActivity.png
  4. When prompted, save the file to logical location. You will need this location when working in the tool.
    InsightsSave.png

Run the tool

Once you have exported data from your monitors and/or Insights, you can run the tool from the ControlUp Console.

Access and define arguments

Running this tool is like accessing any of ControlUp's scripts from the script library. You have to have at least one device connected so that you can locate and run the script for the tool.

  1. Right-click any of the connected devices in the ControlUp Console's grid. It can be any device as long as it's connected. The menu opens with a search at the top.
  2. In the search field, enter the word stress to locate the tool's script to run it. Search.jpg
  3. Click to select ControlUp Stress Settings calculator as the only available option. SearchResult.jpg
    The tool opens with the list of arguments you can edit as follows: 

 

Argument Description Default Value
Yellow Percentile Percentile for the tool to calculate Yellow threshold levels. 75
Red Percentile Percentile for the tool to calculate Red threshold levels. 90
Filtered Accounts Comma-separated list of unwanted accounts because they may generate too much irrelevant data* Loginbot
Default Import Location Location where the tool accesses the data from ControlUp If no value given here, you can browse to (or copy) a location when running the tool.
Default Export Location Location to where the data is exported from the tool If no value given here, you can browse to (or copy) a location when exporting the data from the tool.

* We recommend you use the Filtered Accounts argument to optionally filter out accounts from the data to control the accuracy of the data imported into the tool. For example if you run Scoutbees, you would want to filter out all Scoutbees account because they might generate a lot of data regarding login sessions that is not relevant for calculating stress levels.

If you don't change any of these values, you can run the tool with these defaults in the configuration file but you must change the folder locations while running the tool. 

Import the data

Once you set your arguments as described above and you click OK, you see the following tab options:
- Monitor Data. Use this tab to calculate the values for data exported from the Console for the monitor. 
- Insights Data. Use this tab to calculate the values for the CSV data exported from Insights.
- Help. Access help information for running the tool.

  1. In either the Insights Data or Monitor Data tab, click Browse and select the CSV file for Insights data, or the folder for Monitor Data.
    Note: If you added a value for the Default Import Location in the arguments pop-up, the tool may import the data automatically and you may not have to select a folder for Monitor Data.
  2. For Monitor Data only, select the type of data you want to calculate. Make sure that the folder you previously selected has export files for the option you select.
  3. Click Load Data. The data may take a while to load and it may seem like the scripts are not responding. The data is loaded when the dropdown menu with with the message Load Data first has changed to Select Metric. LoadDataFirst.jpgSelectMetric.jpg
  4. Optionally for Monitor Data, if you selected Folders, Hosts or Machines as the data metric, a dropdown appears to Select a folder with a list of available folders in your ControlUp organization so you can further filter on the folder level.SelectFolder.jpg
  5. In the Select Metric field, select from the available metrics in the dropdown list.SelectMetric2.jpgConsumedMemory.jpg
  6. Optionally, you select these options for the metrics:
    - Ignore 0 values - For some metrics, like Latency and Logon duration, we recommend choosing to ignore the values that appear as N/A or 0 in the console.
    - Show Median - Displays an actual median value among all the values imported. 
    - Show Average - Displays the calculated average of all values imported.
  7. The Suggested Stress Level column gives you the stress level that you should define for both Yellow and Red values as defined your arguments when opening the tool (defaults are Yellow=75th Percentile, Red=90th Percentile).
    Go to the ControlUp Real-Time Console to adjust your stress levels for these metrics. For details, see Stress Settings.
  8. Click Clear at the bottom of the dialog to clear the data and begin calculating another metric.

Export Data from the Tool

You may want to export the data from the tool so you can see why you changed your stress levels and on what those changes were based. You can also go back and see if changing those levels caused any changes in your environment.

You may want to export the data from the tool so you can use this file as future reference on how you want to change the thresholds.  as you may want to do a review of the data one after the other. The tool doesn't save the information so exporting it will enable you to keep historical information of what the ControlUp Stress calculator recommended.

You can export the tool data in the following ways. These options appear at the bottom of the tool's dialog:

  • Copy CSV Data - if you select to copy the data, you can paste the data into your favorite text editor.
  • Export to CSV - if you select this option, you must supply a location to save the CSV file. The default names of the export files depend on from where you exported the data:
      • Monitor Stress Levels Calculation.csv
      • Insights Stress Levels Calculation.csv

Tip: Name these files based on the data you exported. For example: Monitor Stress Levels Calculations for CPU Usage.csv

 

 

 

 

 

Powered by Zendesk