RG007 – UsageTracking DBsize Calculator

By Max Ranzau

 

The DBsize Calculator will let you estimate how big your Workspace Managerdatabase will be approximatly. Now, before you jump in, here’s a brief reality check. The calculator only deals with the largest tables in the Workspace Managerdatastore, namely the Usage Trackingtables. These are the ones that matter. The rest of the database would rarely exceed 100 Meg anyway. Just to be clear, the following items are not taken into consideration:

  • Custom Resources
  • Uploaded .ADM files
  • Desktop and Screensaver bitmaps
  • Odd-sized icons
  • Other stuff you upload into the database.

The Usage Trackingengine in Workspace Managerwill create database records the moment a user starts an application or launches a website. When the user closes the app or website, the record created earlier is updated with and end-timestamp. Each record created by Usage Trackingis 512 bytes in size.
The calculator is an external spreadsheet powered by EditGrid.com, where one can make online spreadsheet calculators, so here it is. Hit the “Click to Edit” button below to start using it (note: may take a little while to load)

 

A few notes regarding the fields: Average # of apps launched and Average # of websites visited. The default value for these two fields have been determined as a deacent starting point: Over the years there has been opportunity to investigate some databases, focusing on the the average amount of applications and websites utilized per day. The average number of applications started per day is 30. This average number of websites opened per day is 35. These numbers can ofcourse be changed if you think your users behave diferently. Days to keep detailed data is per default 7 in the RES Management Console. If you want to have an idea how much data this amounts to in a year, try inserting 240 in this field. The total number of users field, you insert the number of users who are exposed to PowerFuse, i.e. how many users provide data to the database. This is not the est. concurrent users, as Usage Trackingdata is historic. Finaly, the additional custom data size field allows you to add extra known data to the equation. For example, if you know your existing database including custom ressources, etc is 85MB, then enter it into this field. This is just a way to tweak the end result for better accuracy.

No Comments

No comments yet.

RSS feed for comments on this post.

Leave a comment

Comments are welcome as always. Just do the math below. * Time limit is exhausted. Please reload the CAPTCHA.