{"text_format":"2","workbook":"xls","n_sheets":12,"sheets":["Introduction","Guidelines","Project Data Input","Output - Integration Server","Output - Enterprise Server","Base Calc Metrics","Benchmark Tables","CPU Sizing","Disk Space","Database Sizing","Adapter Architecture","Peak Memory Broker 6"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Guidelines","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,21,12],[16,2,16,12],[17,2,17,12],[2,2,2,12],[3,2,3,12],[4,2,4,12],[1,1,1,12],[20,2,20,12],[6,1,6,12],[19,1,19,12],[13,1,13,12],[7,1,11,1],[14,2,14,12],[15,2,15,12]],"flags":["formulas_cached_only"]}
[]
[null,"Guidelines for Use"]
[null,null,"This spreadsheet was developed to provide sizing information based on estimated volume information and a representative number of  architecture/deployment options. It uses webM performance benchmark figures from whitepapers and informal tests, best practice, and other accumulated deployment experience to determine the infrastructure required for each factor in the complete capacity and sizing model."]
[null,null,"To use the spreadsheet, fill in all the cells shaded in the Input spreadsheet. If the metrics given by the customer or prosepct are not in the dimensions specified conversion will be necessary. The output sheets yield sizing information for each of the technology options, i.e. \"Output - Enterprise\" yields the result for Broker + Enterprise Adapters & \"Output - Integration Server yields results for an IS Adapter Host architecture (i.e. wM 6.0). Note that if only one of the output options is required the Input sheet indicates which metrics can be omitted."]
[null,null,"NOTE: This spreadsheet produces a rough and preliminary sizing estimates.  The results should be used as an initial input to help make sizing decisions, and then updated over the lifecycle of the project to validate the process. The intent of the spreadsheet is to generate boundary conditions (best case, worst case) based on the constraint information entered in the spreadsheet. As the infrastrcuture matures it would be advisable to feedback results into the metrics in this tool to provide a more accurate sizing estimate."]
[]
[null,"Key to cells:"]
[null,null,null,"Indicates that input is required"]
[null,null,null,"Indicates guideline figures - can be changed if required"]
[null,null,null,"Cell contents should not be changed"]
[null,null,null,"Indicates a calculated figure that should not be changed. Key final answers are shown in bold"]
[]
[]
[null,"Assumptions"]
[null,null,"transactions within the system are relatively short lived, typically less than a few seconds."]
[null,null,"Error logging, & infrastructure messaging is excluded from the transaction volume calculations"]
[null,null,"Calculations account for average transaction volumes only. Number allowances for high availability/clustering, app topology, complex transactions, significantly larger documents"]
[null,null,"A Transaction is defined as a single business object being transported from application A to application B. Does not include the response document coming back, which would represent a separate transaction."]
[]
[null,"Future Refinements"]
[null,null,"Refine IS & Broker memory requirement based on document throughput & number of adapters hosted"]
[null,null,"Update metrics for wM6.0"]

{"sheet":"Project Data Input","index":2,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Required Input Variables"]
[null,"Variable","Phase 1","Phase 2","Phase 3","Req For Ent Sizing","Req for IS Sizing","Comment"]
[null,"Project Phase","Phase I","Phase II","Phase III","ü","ü","Names for each project phase"]
[null,"Number of applications",4,6,7,"ü","ü","Total number of applications being integrated"]
[null,"Number of end-to-end integrations",50,75,150,"ü",null,"Total number of end-to-end integration processes implemented"]
[null,"Adapters centrally located?","NO","NO","NO","ü",null,"If the adapters are centrally located (I.e. on the Broker Server) then memory needs to be allocated for them"]
[null,"Average Number of transactions per integration per day",9730,17500,45500,"ü","ü","Number of transactions = number of instances of the integration service created."]
[null,"% simple integrations",0.5,0.4,0.3,"ü","ü","A simple integration is defined as invocation of a single parent service, which calls no more than 2-3 child services. The integration involves a simple transformation and inteaction with a single backend application, typically to query for information."]
[null,"% medium integrations",0.4,0.4,0.3,"ü","ü","A medium integration is defined as invocation of a 1-3 parent services, each of which calls no more than 3-5 child services. The integration involves a more complex transformations and interaction with a 2-3 backend applications, either to query information or to perform a simple update."]
[null,"% complex integrations",0.1,0.2,0.4,"ü","ü","A complex integration is defined as invocation of a 1-5 parent services, each of which calls 5 or more child services. The integration involves very complex transformations and interaction with a 3 or more backend applications, typically to insert data into the backend system."]
[null,"% transactions with no audit logging",0.9,0.75,0.7,"ü","ü","Audit logging adds a performance penalty of roughly 1-5% to each transaction processed."]
[null,"% transactions with audit logging for errors only",0.1,0.2,0.2,"ü","ü","Full audit logging adds a performance penalty of roughly 5-10% but only when a transaction fails to process successfully."]
[null,"% transactions with full audit logging",0,0.04999999999999999,0.10000000000000003,"ü","ü","Full audit logging adds a performance penalty of roughly 5-10% to each transaction processed."]
[null,"Number hours in a day avail to perform processing",1,1,1,"ü","ü","Number of hours in the day required to process the volume."]
[null,"Number of documents created in a single transaction",4,4,4,"ü","ü","Number of documents transported from application A to application B through the Broker as part of a single transaction. Includes volatile events, ackNumberwledgements, etc."]
[null,"Number of hours to perform a whole days volume at peak load",0.5,0.5,0.5,"ü","ü","Even though the process is real time the business process or other constraints may force all transactions to go through the infrastructure in a shorter space of time. This value allows the peak volume to be calculated. "]
[null,"Number of Business Objects per integration process",2,2,2,"ü",null,"An integration process may involve the exchange of a PO, a PO Ack, and Invoice, and an Invoice Ack. This metric allows the calculation of adapters required should an adapter be required for each business object."]
[null,"Number of Infrastructure Adapters",2,5,10,"ü","ü","e.g. Number of adapters for error logging or translation that are reused across the entire infrastructure"]
[null,"Proportion of documents that are guaranteed",0.5,0.5,0.5,"ü","ü","If documents are not guaranteed then they can be discounted from the Broker disk bound IO calculation"]
[null,"Average Document Size (kB)",2.8,2.8,2.8,"ü","ü"]
[null,"Number of working days in a year",250,250,250,null,"ü","Allows for database storage requirements to be calculated."]
[]
[]
[null,null,"Note: numbers for each phase should be cumulative"]
[null,null,"For example, if Phase II adds 25 new interfaces to a system which has 50 already, the total entered shoulf be 75"]
{"$rows_empty":40}
[null,null,"Number of hours in a day",12]
[null,null,"Number of working days in a year",250]
[null,null,"Average transaction size",1024]
[null,null,"Total Number of transactions per hour"]

{"sheet":"Output - Integration Server","index":3,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Integration Server Sizing Estimates"]
[]
[null,"Option 1","IS per Application"]
[null,null,"Project Phase","Phase I","Phase II","Phase III"]
[null,null,"Number of Physical Broker Servers Required",1,1,1]
[null,null,"Number of Broker Server CPUs Required",2,2,2]
[null,null,"Broker Server Infrastructure Utilisation",0.1,0.15,0.175]
[null,null,"Total Broker Server RAM Requirement (MB)",500,500,500]
[null,null,"Number of Integration Servers Required",6,11,17]
[null,null,"Total Integration Server RAM Requirement (MB)",2380.44,3020.44,3788.44]
[]
[null,"Option 2","Single Centralized IS - Throttle: IS Throughput"]
[null,null,"Project Phase","Phase I","Phase II","Phase III"]
[null,null,"Peak Document Throughput (Docs per sec)",21.62222222222222,38.88888888888889,101.11111111111111]
[null,"Bridge 4.6","Number of Integration Servers Required",8,15,36]
[null,null,"Total Server RAM Requirement (MB)",1196.44,2092.44,4780.44]
[null,null,"Number of Physical Broker Servers Required",1,1,1]
[null,null,"Number of Broker Server CPUs Required",2,2,2]
[null,null,"Broker Server Infrastructure Utilisation",0.2,0.375,0.9]
[null,null,"Total Broker Server RAM Requirement (MB)",500,500,500]
[null,"6.0","Number of Integration Servers Required",4,8,16]
[null,null,"Total Server RAM Requirement (MB)",1201.76,2403.52,4807.04]
[null,null,"Number of Physical Broker Servers Required",1,1,1]
[null,null,"Number of Broker Server CPUs Required",2,2,2]
[null,null,"Broker Server Infrastructure Utilisation",0.1,0.2,0.4]
[null,null,"Total Broker Server RAM Requirement (MB)",500,500,500]
[]
[]
[null,"Option 3","Transaction Volume"]
[null,null,"Project Phase","Phase I","Phase II","Phase III"]
[null,null,"Peak Document Throughput (Docs per Sec)",21.62222222222222,38.88888888888889,101.11111111111111]
[null,null,"Average Document Throughput (Docs per Sec)",10.81111111111111,19.444444444444446,50.55555555555556]
[null,null,"Average Number of Guaranteed Events per Second",5.405555555555555,9.722222222222223,25.27777777777778]
[null,null,"Peak Number of Guaranteed Events per Second",10.81111111111111,19.444444444444446,50.55555555555556]
[null,null,"Number of Broker Servers Required For Average",1,1,1]
[null,null,"Number of Physical Broker Servers Required For Peak",1,1,1]
[null,null,"Number of Broker Server CPUs Required",2,2,2]
[null,null,"Broker Server Infrastructure Utilisation",0.09084967320261438,0.16339869281045755,0.42483660130718953]
[null,"Bridge 4.6","Number of Integration Servers Required",8,15,36]
[null,null,"Total IS Server RAM (MB) ",2403.52,4506.6,10815.84]
[null,null,"IS Infrastructure Utilisation",0.9256944444444444,0.9814814814814815,0.9799382716049383]
[null,"6.0","Number of Integration Servers Required",4,8,16]
[null,null,"IS Infrastructure Utilisation",0.7868163240641254,0.88292834897853,0.9603068536720891]
[]
[]
[null,"Database Sizing"]
[null,null,"Time Period","Phase I","Phase II","Phase III"]
[null,null,"Total Number Documents per day",38920,70000,182000]
[null,null,"Total data volume per day (kB)",108976,196000,509599.99999999994]
[null,null,"Total Number of transactions per Qtr",2432500,4375000,11375000]
[null,null,"Total data volume per Qtr (kB)",6811000,12250000,31849999.999999996]
[null,null,"Total Number of transactions per year",9730000,17500000,45500000]
[null,null,"Total data volume per year (kB)",27244000,49000000,127399999.99999999]
[null,null,"DB Storage Req per day (kB)",326928,588000,1528799.9999999998]
[null,null,"DB Storage Req per Qtr (kB)",20433000,36750000,95549999.99999999]
[null,null,"DB Storage Req per year (kB)",81732000,147000000,382199999.99999994]

{"sheet":"Output - Enterprise Server","index":4,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Enterprise Adapter Sizing Results For All Architecture Options"]
[]
[null,"Option 1","Adapter per BO per Application"]
[null,null,"Project Phase","Phase I","Phase II","Phase III"]
[null,null,"Number of Adapters",102,155,310]
[null,null,"Number of Broker Servers Required",3,4,8]
[null,null,"Number of Broker Server CPUs Required",6,8,16]
[null,null,"Total Server RAM Requirement (MB)",1500,2000,4000]
[null,null,"Broker Infrastructure Utilisation",0.85,0.96875,0.96875]
[]
[null,"Option 2","Single Adapter per Application"]
[null,null,"Project Phase","Phase I","Phase II","Phase III"]
[null,null,"Number of Adapters",6,11,17]
[null,null,"Number of Broker Servers Required",1,1,1]
[null,null,"Number of Broker Server CPUs Required",2,2,2]
[null,null,"Total Server RAM Requirement (MB)",500,500,500]
[null,null,"Broker Infrastructure Utilisation",0.15,0.275,0.425]
[]
[null,"Option 3","Hybrid"]
[null,null,"Project Phase","Phase I","Phase II","Phase III"]
[null,null,"Number of Adapters",10,17,24]
[null,null,"Number of Broker Servers Required",1,1,1]
[null,null,"Number of Broker Server CPUs Required",2,2,2]
[null,null,"Total Server RAM Requirement (MB)",500,500,500]
[null,null,"Broker Infrastructure Utilisation",0.25,0.425,0.6]
[]
[null,"Option 4","Transaction Volume"]
[null,null,"Project Phase","Phase I","Phase II","Phase III"]
[null,null,"Average Number of Guaranteed Documents per Day",19460,35000,91000]
[null,null,"Average Number of Guaranteed Documents per Second",5.405555555555555,9.722222222222223,25.27777777777778]
[null,null,"Peak Number of Guaranteed Documents per Second",10.81111111111111,19.444444444444446,50.55555555555556]
[null,null,"Number of Broker Servers Required For Average",1,1,1]
[null,null,"Number of Broker Servers Required For Peak",1,1,1]
[null,null,"Number of Broker Server CPUs Required",2,2,2]
[null,null,"Broker Infrastructure Utilisation",0.09084967320261438,0.16339869281045755,0.42483660130718953]

{"sheet":"Base Calc Metrics","index":5,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Metric","Value","Source"]
[null,"Number Adapters per Broker Server",40,"Sizing paper for customer paper, rule of thumb"]
[null,"Memory required per adapter (MB)",40,"Sizing paper for customer, product literature"]
[null,"Memory required per Broker Server (MB)",500,"Sizing paper for customer, product literature"]
[null,"Avg Doc Size used for benchmark lookups",10,"Takes the average document size and rounds it to the nearest 10."]
[null,"Broker Server IO limit for guaranteed docs (docs per second)",119,"Half of the disk bound performance for 1 Broker Server doubled to allow for up to 2 Broker Servers running on the same Broker Server but using different physical disks."]
[null,"Number of Broker Servers required for IO limit for guaranteed docs",2,"Assume 2 Broker Servers on same server using different disks doubles 30 docs per second througput"]
[null,"Number of Broker CPUs required for IO limit for guaranteed docs",2,"From Enterprise Scalability white paper"]
[null,"Broker Package 4.6 Max Throughput (docs per sec)",4,"Rule of thumb 4-8"]
[null,"6.0 IS<-->ES Max Throughput (docs per sec)",80,"Rough estimate…need to validate with once 6.0 performance #'s are released"]
[null,"Max IS Throughput",18.84675,"The max IS throughput, calculated based on doc size, # of txns and weighed for txn complexity and logging"]
[null,"Recommended RAM per IS 4.6",128,"Double Mark Breissinger's minimum plus head room - depends on the size of the documents being transmistted. Next stage is to create a metric to calculate this based on minumum requirements plus volume of documents/data passing through."]
[null,"Typical RAM usage per IS Package",32,"Each custom package requires approximately 32Mb of RAM to load and operate"]
[null,"Number of IS custom packages per IS",5,"Estimate of number of packages needed to implement all integrations"]
[null,"Average Number of Integrations per Package",10]
[null,"Document Memory",12.44,"(MB) Amount of memory necessary to manage average document processing load. "]
[null,"Fudge Factor For Database Sizing",3,"Assumed storage space per document for database sizing"]
[]
[null,"Logging Performance Adjustment Factor"]
[null,"Number Audit Logging",1]
[null,"Audit Logging for Errors Only",0.75]
[null,"Full Audit Logging",0.5]
{"$rows_empty":31}
[null,null,"Number of hours in a day",12]
[null,null,"Number of working days in a year",250]
[null,null,"Average transaction size",1024]
[null,null,"Total Number of transactions per hour"]

{"sheet":"Benchmark Tables","index":6,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,2,16,4],[16,1,17,1]],"flags":["formulas_cached_only"]}
[]
[null,"Broker Document Processing Benchmarks IO Bound"]
[null,"Source: Performance & Scalability of webmethods Enterprise White Paper"]
[null,"Document Size (kB)","Documents per Second"]
[null,1,133]
[null,10,119]
[null,100,33]
[]
[null,"wM 6 IS<-->ES Throughput"]
[null,"Document Size ((kB)","Documents per Second"]
[null,1,80]
[null,10,40]
[null,100,5]
[]
[null,"Integration Server Document Processing Benchmarks (Estimates)"]
[null,"Estimated throughput based roughly on 1 CPU, JVM1.3.0, Solaris throughput figures for document parsing"]
[null,"Document Size (kB)","Documents per sec"]
[null,null,"Simple","Medium","Complex"]
[null,1,67.5,22,7]
[null,10,30,10,3.3]
[null,100,6.8,2.2,0.7]
[]
[null,"Simple = parsing small XML documents only (metrics from the Integration Server Performance & Scalability White Paper)"]
[null,"Complexity factors: Trading Networks, Persistence Layer, Transformation logic, Error Handling Logic, Backend Processing Logic"]

{"sheet":"CPU Sizing","index":7,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,7]],"flags":["formulas_cached_only"]}
[null,"IS CPU Sizing Spreadsheet"]
[]
[null,"Instructions:"]
[null,"1. For each row in the first table, fill in the four colored fields (if you have fewer doc types, rows may be left blank)"]
[null,"2. Select the type of hardware type, approximate GHz rating, and # of CPUs/box in the colored fields of the second table"]
[null,"3. # of boxes required appears at the bottom"]
[null,null,"Size in KB","# docs/sec","Complexity (high/med/low)","Total KB/sec \nreqd","Target busy percentage","GHz reqd"]
[null,"Doc type #1",5,1,"Low",5,80,0.010416666666666668]
[null,"Doc type #2",25,5,"High",125,80,1.5625]
[null,"Doc type #3",10,5,"Medium",50,80,0.20833333333333331]
[null,"Doc type #4",2,5,"Low",10,80,0.020833333333333336]
[null,"Doc type #5",2,15,"High",30,50,0.6]
[null,"Doc type #6",100,2,"Medium",200,80,0.8333333333333333]
[null,"Doc type #7",30,25,"Low",750,80,1.5625]
[null,"Doc type #8",2,10,"Medium",20,80,0.08333333333333334]
[null,"Doc type #9",10,1,"Low",10,80,0.020833333333333336]
[null,"Doc type #10",22,2,"Low",44,80,0.09166666666666666]
[]
[null,"Average",20.8,71,null,1244,"Total GHz",4.9937499999999995]
[]
[null,"Hardware type","Sun SPARC"]
[null,"Ghz/CPU","1.5GHz",1.5,null,null,null,1.5]
[null,"CPUs/box",2,2,null,null,null,1.8]
[null,"Usable GHz/box",null,2.7]
[null,"# boxes required",null,2]
[null,"Conclusion: you need 2 (2-way) 1.5GHz Sun SPARC boxes"]
[]
[null,"Caveats:"]
[null,"1. This is an experimental sizing, and should not be relied on as an exclusive measure."]
[null,"2. The definitions of high/med/low are very subjective."]
[null,"3. The formulas assume that the machine is CPU-bound; if it's limited by memory or disk or application lock contention,"]
[null,"   this assumption will be false."]
[null,"4. GHz are not the only measure of a CPU; the cache size is extremely important.  For sake of argument, though, the"]
[null,"   calculations ignore other factors."]

{"sheet":"Disk Space","index":8,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Determining Disk Space Requirements"]
[]
["Component","Estimating Factor","#","Disk Space per unit (MB)","Disk Space Required (MB)","Location (Unix)","Notes"]
["Broker"]
["Broker Server Footprint","# Ent Servers",1,100,100,"/opt"]
["4.x Adapter Monitor Footprint","# Ent Servers",1,100,100,"/opt"]
["4.x Adapters Footprint","# 4.x Adapters",15,10,150,"/opt"]
["Broker Guaranteed Storage File","# Ent Servers",1,1024,1024,"/var/opt","depends on broker storage file size"]
["Broker Log File","# Ent Servers",1,128,128,"Unix system log dir"]
["Shell scripts","# Ent Servers",1,0,0,"/etc/rc3.d"]
[null,null,null,"Total:",1502]
[]
["Integration Server"]
["Integration Server Based Footprint","# Integration Servers",1,1000,1000,"configurable"]
["Installed Custom Packages","# of Custom Packages",5,100,500,"configurable","depends on complexity of packages"]
["Integration Server Log Files","# Integration Servers",1,1000,1000,"configurable","depends on the log level/amount and archival rate"]
["6.x Adapters","# 6.x Adapters",5,100,500,"configurable"]
[null,null,null,"Total:",3000]

{"sheet":"Database Sizing","index":9,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,7],[17,1,17,7],[32,1,32,7]],"flags":["formulas_cached_only"]}
[]
[null,"TN Database Requirements"]
[]
[null,"Parameters"]
[null,"# of Bizdoc attributes",4]
[null,"Average Bizdoc size (KB)",10]
[null,"# Transactions / day",10000]
[null,"# days of transactional data to retain prior to archival",90]
[]
[]
[null,"TN Storage Requirements"]
[null,"Type of data","Disk Space Required (MB)"]
[null,"Initial schema size (init.xml) and master data",5]
[null,"Document Storage Requirements",9226.80013]
[null,"Activity Log Requirements",4950]
[null,"Total Database Storage Required",14181.80013]
[]
[null,"Audit Logging Database Requirements"]
[]
[null,"Parameters"]
[null,"# of service invocations per day",2000000]
[null,"% log error only",0.4]
[null,"% log error, success",0.1]
[null,"% log error, success, start",0.1]
[null,"% log pipeline",0.1]
[null,"Average input pipeline size (KB)",3]
[null,"# days of logging data to retain prior to archival",14]
[]
[null,"Audit Logging Storage Requirements"]
[null,"Type of data","Disk Space Required (MB)"]
[null,"Total Logging Storage Requirements",51461.7919921875]
[]
[null,"Workflow Database Requirements"]
[]
[null,"Parameters"]
[null,"# of Workflow Versions",4]
[]
[]
[null,"Workflow Storage Requirements"]
[null,"Type of data","Disk Space Required (MB)"]
[null,"Initial schema size",10]
[null,"Workflow Model Requirements",2.734375]
[null,"Total Database Storage Required",12.734375]

{"sheet":"Adapter Architecture","index":10,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,5],[8,0,8,5]],"flags":["formulas_cached_only"]}
["Broker - Architecture Options"]
["Option Number",1,2,3,4]
[null,"Adapter per BO per Application","Single Adapter per Application","Hybrid","Transaction Volume","Comment"]
["Description","Use an adapter instance for each document type exchanged with the back bone.","Use a single adapter per application to handle all inbound and outbound documents.","Two adapters, one for inbound documents, one for outbound documents.","Sizing based purely on transaction volumes."]
["Number of adapters per application","N/A",1,2,"N/A","Option 2 has a Single adapter for each application, Option 2 has an inbound and outbound adapter for each application."]
["Number of adapters per integration",1,"N/A","N/A","N/A","Option 1 calculates one adapter for each integation process"]
["Number of technology adapters per application",0,0,0,"N/A","May need an adapter e.g. email, flat file for each application"]
[]
["IS Adapters - Architecture Options"]
["Option Number",1,2,3,4]
["Option ","IS per Application","Single Centralized IS - Throttle: IS Throughput","Transaction Volume",null,"Comment"]
["Description","Single IS server for each application being integrated","Single centralised IS provides adapter service for all applications","Number of components required based purely on throughput for IS & Broker components"]
["Number of Broker Clients per IS",1,1,"N/A"]
{"$rows_empty":43}
[null,"Number of hours in a day",12]
[null,"Number of working days in a year",250]
[null,"Average transaction size",1024]
[null,"Total Number of transactions per hour"]

{"sheet":"Peak Memory Broker 6","index":11,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,7]],"flags":["formulas_cached_only"]}
[null,"Determining Peak Memory Requirements for Broker 6.0"]
[]
[null,"Note: Assumes 1 broker per broker server"]
[]
[null,"Broker Parameters"]
[null,"Storage Log File Size",1024]
[null,"Configured Cache Size",1024]
[]
[null,"Number of Document Types",50]
[null,"Number of Territory Peers",1]
[null,"Number of Client Groups",5]
[null,"Number of Volatile Clients",10]
[null,"Number of Subscriptions to Volatile Clients",5]
[null,"Number of Guaranteed Clients",10]
[null,"Number of Subscriptions to Guaranteed Clients",3]
[null,"Average Doucment Size (KB)",50]
[]
[null,"Number of Volatile Documents Enqueued",60]
[null,"Average Enqueued Volatile Document Size (KB)",40]
[]
[null,"Peak Number of Concurrent Threads",20]
[null,"Average Size of Incoming Document (KB)",50]
[null,"Average memory required for each operation (KB)",0.2]
[]
[]
[null,"Memory Requirements"]
[null,"Broker Memory Usage Summary","Memory Reqd (MB)"]
[null,"Process Overhead",15]
[null,"Peak Storage Subsystem Memory Requirements",3078]
[null,"Peak Broker Configuration Data Memory Requirements",5.6416015625]
[null,"Peak Transient Data Memory Requirements",2.35546875]
[null,"Peak Operational Data Memory Requirements",0.98046875]
[null,"Peak Memory Requirements",3101.9775390625]