Home > Tools / Products >

  Excel Add-in: M/M/m Queuing Theory Functions (1a, Nov 2007)
 
 
Our Price: Free


Availability: Available for download now
Product Code: QUEUE_ADDIN_1A

Features
 
 
Features
  • This Excel based Add-In contains nine queuing theory related functions allowing one to perform M/M/m queuing theory analysis. These are the same industry standard formulas used in OraPub's Queuing Theory Spreadsheet. We just separated the functions and made an Excel Add-In. This way you don't need to start with our spreadsheet. You can start with any spreadsheet!
  • Here is how to add the Add-In:
    • 1. Start Excel, and do Tools, Add-Ins, Select, OraPub_Queuing_functions_addin.xla
    • 2. You should now see the OraPub M/M/m Queuing Theory in the selection box.
    • 3. Click the check box and click OK.
  • That's it! Now the functions are available to you.
  • What Functions? To see a list of the functions, click Insert, Function, User Defined, and look for all functions that start with f_.
  • There are nine functions in all. Here is a list of the core functions:
    • f_TI(service time, arrival rate at each queue). Traffic Intensity at each queue. For modeling CPU subsystems there is only one queue, so the arrival rate at each queue is the total arrival rate. But for modeling IO subsystems, the arrival rate at each queue is the system arrival arrival rate divided by the number of queues.
    • f_UTIL(traffic intensity,servers per queue). Average server utilization (1=100%)
    • f_TW(servers per queue, service time, lamda). Queue time based upon Erlang-C mathematics.
  • How to use this tool in real life is presented in our Forecasting Oracle Performance class and Mr. Shallahamer's book of the same name.


Browse for more products in the same category as this item:

Tools / Products


Getting Started Optimizing Oracle Performance PRESENTATION (21-March-2008, IOUG/Collab '08) Free
Getting Started Forecasting Oracle Performance (v1d, 14-March-2008, IOUG/Collab '08) Free
Adventures in Tuning the Shared Pool for Web Applications (mar-01) Free
Oracle Centric CPU Speed Test (1c, 22-Jan-09) w/Results Posted! Free
Statistical Analysis Excel Workbook (1b 21-Oct-98) Free
Forecasting data collection script for Oracle and OS (v1.1 May 11, 2007) Free
Automatic Undo Internals (June-2003) Free
Modern Performance Myths - Presentation RMOUG/IOUG/Collab'06/OOW'06 (October 2006) Free
Me? Forecast Performance? Free