Performance Tuning with Plumber

on 15/08/2009

1. Requirement of Performance Tuning

A few weeks before, the lady (let’s say Lady D) lives downstairs in our apartment building complained that, there was a deep water creep from the wall inside her unit, and the water stream was not running stably, our daily life and the adjacent sub modules are being affected extensively. As a result, we guessed it might be some bottlenecks or ‘memory leaks’ during the processes in which water runs inside the pipes. It must be tackled immediately as an emergent case.

 

2. Client

Lady D, My Landlord and me (As a coordinator).

 

3. Project Charter

Real Estate Agent, Body Corporate, Lady D and My Landlord.

 

4. Human Resource

Five people of AU team in total, they are Project Manager, Plumber, electrician, cementer01 and cementer02.

 

5. Scope of Work

Project Manager, responsible for project planning and scheduling, organizes the specialists of different aspects in implementing the project, bridges the communication gaps through Lady D, My Landlord and each project members.

Plumber, responsible for monitoring and fixing all the pipe modules in the unit, similar to debugging application sub modules, tracing and fixing application bugs.

Electrician, responsible for monitoring and debugging modules other than pipe, similar to tracing operating system and database system modules, pinpoint the bottleneck among operating system layer or database system layer or application layer.

Cementer01 and cementer02, responsible for fixing and consolidating the broken walls as well as ceramic tiles, ensure the project closes perfectly, similar to patching for the application or database system or operating system.

 

6. Implementation

1st Day:

1) Project Manager, Lady D and Landlord attended the kick-off meeting, confirmed the project timetable and schedule

2nd Day:

1) Plumber monitored and traced all the pipe modules inside the unit

2) Diagnosed the exception raised by the pipe module inside the wall of the bathroom

3) Further in-depth layers traced needed by electrician

3rd Day:

1) Electrician asked me about the impacts of the surrounding modules caused by the questionable water module as well as additional information when invoking the water module

2) Electrician took in-depth tracing and analysis focusing on water module in the bathroom by an advanced monitoring and debugging tool

3) Eventually, the electrician found out the severe ‘memory leaks’ of the water module inside the wall of the bathroom without unclenching the ceramic tiles and breaking the wall

4) Electrician suggested to hang on the specific water module to prevent further ‘memory leaks’

4th Day:

1) Plumber unclenched the ceramic tiles and the wall

2) Plumber took a double checking inside the water module and subsequently pinpoint the statement line that raised the leaking exactly

3) Plumber fixed the questionable water module

4) Reloaded the water module, water service was back on track

5th Day ~ 20th Day (a little bit uncomfortable about this):

1) There was a risk on human resource of the project that the cementers could not be available as the fixed project schedule

2) Project hanged until the day that the cementers were available

21st Day:

1) Cementer01 and Cementer02 back to the project

2) Cementer01 and Cementer02 fixed the broken wall and ceramic tiles caused by previous in-depth tracing and analysis through the water module

3) Cementer01 and Cementer02 consolidated the wall and ceramics followed by updated patching

4) Water module in the bathroom would back on track with normal service in couples of hours after the automatic patching

22nd Day:

1) Each module ran normally with full services

2) Each module downstairs ran normally which indicates the performance tuning project successfully completed

 

7. Comparison with CN project

1) It takes more or less one working day to complete this kind of project by CN team

2) It takes 1 ~ 2 people as human resource in CN team, in most cases, the one who plays the role as project manager will also act as plumber, electrician and cementer simultaneously

 

8. Summary

1) AU team follows the project standard strictly which makes the project runs smoothly, it is more suitable for big project rather than small project

2) AU team has a higher cost on human resource which indicates a higher risk implicitly

3) AU team requires every specialist demonstrates an in-depth technical skill in his area in the project, whereas as a contract, the synthetic ability might not be required in the first place

4) CN team follows a agile project standard with compacted project schedule, it is more suitable for medium and small projects

5) CN team has a lower cost on human resource which reduces the risk of resource

6) CN team requires a higher synthetic ability in the project, lacks of top specialists in the specific field

7) It is the best bet to work on the project consisted by AU team and CN team: AU team responsible for project management, CN team members act as project members; AU team responsible for top specialists in each field while CN team responsible for the Chief Technical Officer

水管工的性能调优

on 14/08/2009

1. 性能调优需求

前段时间,我租住的公寓楼下的一位女士D反映说,她家的墙壁出现大面积渗水,水流速度不稳定,严重影响日常生活用水,以及水管的周边模块。我们猜测可能水在水管中运作过程出现性能瓶颈或者内存泄漏,事关紧急,需要尽快处理。

 

2. 客户

女士D、我的房东(我是接口人)

 

3. 性能调优项目立项

中介,物业管理,女士D和我的房东

 

4. 人力资源

共5人,他们分别是:项目经理,水管工,电气工,水泥工01,水泥工02

 

5. 任务说明书

项目经理,负责制定项目计划,组织各领域的专家执行项目,是女士D、我的房东和各项目成员之间的沟通桥梁

水管工,负责全屋水管模块检测与更换,相当于所有应用程序子模块调试、跟踪以及修复程序漏洞

电气工,负责水管以外的模块检测与调试,相当于操作系统和数据库模块的跟踪,并定位瓶颈是否位于操作系统层或者数据库系统层,或者应用程序层

水泥工01和水泥工02,负责修复和巩固墙壁、瓷砖等工作,使项目实施能够完美结束,相当于给应用程序、数据库系统或者操作系统打补丁

 

6. 项目实施过程

第一天:

1) 项目经理和女士D、房东召开开工大会,确定项目时间以及日程表

第二天:

1) 水管工对全屋水管模块进行检测与跟踪

2) 初步诊断水管模块在浴室部分可能有异常

3) 需要电工进行底层跟踪

第三天:

1) 电气工向我询问了水管模块对周边模块的影响,以及我平常调用水管模块的详细信息

2) 电气工采用先进检测调试工具,对浴室部分的水管模块重点进行底层跟踪和分析

3) 最终,电气工隔着瓷砖和墙壁确定出浴室墙壁里面的水管模块有严重“内存”泄漏现象

4) 电气工建议浴室的水管模块马上挂起,暂停使用,以免造成更多空闲“内存”泄漏

第四天:

1) 水管工对瓷砖和墙壁进行拆卸

2) 水管工直接对内部的水管模块进行再次诊断,并精准确定出泄漏的具体命令行

3) 水管工对出问题的水管模块进行修复

4) 重新加载水管模块,水管模块恢复对外提供服务

第五天 ~ 第二十天(这一点比较不习惯):

1) 项目人力资源出现风险,水泥工无法按预定计划参与项目

2) 项目暂时搁置,等待水泥工的空闲资源

第二十一天:

1) 水泥工01和水泥工02终于出现并重返项目组

2) 水泥工01和水泥工02修复由于水管模块深度跟踪与诊断而被破坏的墙壁与瓷砖

3) 水泥工01和水泥工02对墙壁和瓷砖进行巩固并打上最新补丁

4) 由于补丁自动升级需要若干小时,浴室水管模块要若干小时候才能重新恢复服务

第二十二天:

1) 全屋各个模块运作正常,所有业务对外提供完全服务

2) 楼下房屋的各个模块运作恢复正常,整个系统调优项目正式结束

 

7. 与国内项目组对比

1) 国内项目组一个工作日基本可以搞定

2) 国内项目组所需人力资源一般1~2人,同一个人同时扮演水管工、电气工以及水泥工角色,甚至兼职项目经理

 

8. 小结

1) 国外项目组项目流程规范,项目进行有条不紊,适合做大项目,不适合做小项目

2) 国外项目组人力资源费用昂贵,人力风险高

3) 国外项目组对每个方面的技术专家专业技能要求较高,但综合技能要求较低

4) 国内项目组项目流程简洁,项目时间紧凑,适合做中、小项目

5) 国内项目组人力资源费用较低,人力风险低

6) 国内项目组对专家综合技能要求较高,每个方面的顶尖技术专家较缺乏

7) 项目采用中西结合方式实施较佳,即项目管理由国外项目组承担,项目成员由国内项目组成员组成; 每个领域专家由国外项目组提供,但整个项目的首席专家由国内项目组提供