Usage Profile Beta Testing

Submitted by GV Administrator on Thu, 2010/03/04 - 21:08

NEW

  1. V1.5 includes support for active user data to be pulled from dataset
    1. now populates Session Activity (renamed to Active Users per Session)
    2. now populates User Activity (renamed to Averate Number of Transactions / User / Session)
  2. Spreadsheet now calculates number of seconds (from TIME data only) and uses that rather than 1 hour
  3. Spreadsheet now warns if the dates span a single day and (separately) if the time exceeds 1 hour
  4. Spreadsheet cacluates session activity percentage based on Active Users per Session and Total Active Users
  5. Gzipped file support added .. upload and recognize a gzipped csv file
  6. automatic / batch gunzip support so that gzipped uploaded files are unzipped and entered into the database using the same owner/user semantics as uploaded file
  7. All new fields can still be overridden via the Usage Profile Scenario form

OLD

  1. Full integration has been achieved ... each step provides a clickable URL to the next step and each step pre-fills in fields where it can
    1. DATE and TIME fields are pulled from the uploaded data, where possible, and used to prepoulate Usage Profile Scenario
    2. TaskID field is prepoulated from Usage Profile Gen step
    3. "Environmental Variables" provided default values (can be changed with Drupal Variables, not yet integrated)
    4. All relevant data fields in Usage Profile are placed in the TPS Calculator instance
  2. Rudimentary CSS applied to Usage Profile to allow for easy reading
  3. Thread & TPS Calculator reformatted for easier reading, all fields provided "hovertip" help

OLDER

  1. The automatic Thread Calculator integration is going well, though not quite ready for prime-time. Once you've completed your Usage Profile Generation you can go to http://www.livelink-experts.com/lle/tps-calc/%taskid   where %taskid is the taskid of your usage profile data.
  2. There is now a Windows command-line jScript to parse out a summary_timings file available at https://www.livelink-experts.com/lle/experts-only/windows-jscript-split-summary-timings-file, this will allow you to save on bandwidth and also get more data into a Usage Profile

 

Because of the importance of a Usage Profile to system scaling and performance tuning, we have provided two separate yet connected methods of
generating a Usage Profile: Manually or Automatically.

1) Automatic Method:
https://www.livelink-experts.com/admin/content/usage_profile_gen/add is a wizard-based approach to generating a Usage Profile. It walks you through the upload of a Summary Timings file, mapping the appropriate columns to profile, and then generates the summarized data from the uploaded file.

  • This is a four-step process (5 if you start from the landing page) that for most people amounts to one step and 4 clicks
  1. Select an existing or upload a new summary timings file --- there is currently a 25MB limit on uploaded files which provides over 500,000 transactions (if stripped)
  2. Select whether or not the first column has headers ... note that this page would also be where a different field and record delimiters are chosen (this is for extending this service to timings and connect logs in the future)
  3. Select the columns to map the information to -- this is most often columns 7 and 8 typically named as "Function.Action" and "Exec. Time" respectively but any column may be used (if, for instance, you wanted to see the SQL use).
  4. Review all the options and the sample data, if all looks well hit "Start Processing"
On the next page you will see a Javascript progress button as the data is processed. Processing time will depend on how much data is provided but averages about 1,000 records per second. Take note of the final number on the URL or review the "Task Details" on the final page looking for the "TaskID".


2) Manual Method: https://www.livelink-experts.com/node/add/usage-profile provides a User Interface to either display a previously created Usage Profile or two create a new one. This is a good interface to review the Usage Profile and possibly adjust it (removing and/or combining fields). IF YOU EDIT THE DATA then be sure to clear the TaskID, that will create a new data set using the values in the form; if you forget then you will lose all your changes as you cannot edit an existing dataset.

It is definitely in Beta mode, there are UI changes that need to be built and some helper functions (like telling you within the Manual Method what existing data sets are available for use) and the BIGGIE we are still working on that will see a saved Usage Profile automatically populate the Thread Calculator. Both pieces are working today, they just need the glue to put
them together.

When you try it out and find weirdness, don't forget to let us know so we can fix it and we will be happy to take feature requests to improve the toolset.

Thanks for your time and interest.

Livelink-Experts.com Management