Capacity Planning

CMG conference proceedings from 1997 through 2005 a unique collection of papers about capacity planning, performance engineering, and performance management

Dr. Neil Gunther's Site and Blog

Guerrilla Capacity Planning by Neil J. Gunther

Performance management and capacity planning CMG papers written by BMC Software and pre-acquisition BGS employees

Dr. Bernie Domanski's papers and presentations

Dr. Norton's publications include papers on Simalytic Modeling as well as a number of other modeling related topics

Capacity Planning and Performance Tuning Resources from Fortuitous

Adrian Cockcroft's Blog performance, modeling, and capacity planning

Capacity Planning for Internet Services. Quick planning techniques for high growth rates by Adrian Cockcroft and Bill Walker

Open Source Capacity & Performance Management Tools for Windows & Unix Systems by Brian Johnson

System Management by Exception by Igor Trubin

Using Transaction Cost Analysis for Site Capacity Planning from Microsoft

Capacity Model for Internet Transactions from Microsoft

A Capacity Planning Framework for Multi-tier Enterprise Services with Real Workloads

Capacity Planning for Internet Service Networks by Geoff Huston

Capacity Planning: An Essential Tool for Managing Web Services by Virgílio A.F. Almeida and Daniel A. Menascé

IBM Server and ERP Sizing Guides

Capacity Planning Directory

Quantitative System Performance the classic text by Lazowska, Zahorjan, Graham, and Sevcik

Stochastic Petri Nets - An Introduction to the Theory book by Falko Bause and Pieter Kritzinger

Tuning

It is often difficult to separate information how to design systems with good performance (architecture, performance patterns, language structures, etc.) from information how to tune and deploy systems, quite often both sides are considered. Although more tuning- and product - oriented links are placed here, a lot of related information can be found in the Performance section. See also Bottlenecks.

Windows
Windows 2000 Performance Tuning Microsoft white paper
Performance Tuning Guidelines for Windows Server 2003 Microsoft white paper
Windows Server 2003 Performance and Scalability Microsoft white paper
Windows System Resource Manager

Linux/Unix
Tuning IBM xSeries Servers for Performance IBM Redbook (Windows, Linux, NetWare, VMware)
SarCheck Linux & UNIX performance analysis and performance tuning tool
Solaris Internals and Performance FAQ
AIX 5L Practical Performance Tools and Tuning Guide IBM Redbook
Database Performance Tuning on AIX IBM Redbook
Tuning Red Hat Enterprise Linux on IBM Eserver xSeries Servers IBM Redbook
IBM System Planning Tool for POWER processor-based systems
IBM System i and System p System Planning and Deployment: Simplifying Logical Partitioning IBM Redbook
PowerVM Virtualization on IBM System p: Managing and Monitoring IBM Redbook
AIX and Midrange Virtualization by Jaqui Lynch

VMware
VMware Technical Resources a lot of performance-related technical papers
Performance Best Practices and Benchmarking Guidelines VMware Infrastructure 3 version 3.5 with ESX 3.5, ESXi 3.5, and VirtualCenter 2.5

Virtualization
V or Not to V: A Practical Guide to Virtualization paper and presentation by Gene Fernando

Apache Web (aka IBM HTTP) Server
Apache 1.3 Performance Notes
Apache 2.0 Performance Tuning
Apache Performance and Security Guide by Nasim Mansurov
Tuning Apache Web Servers for Speed by Dean Gaudet

Microsoft IIS
The Art and Science of Web Server Tuning with Internet Information Services 5.0
IIS 6.0 Performance Tuning

WebLogic
Workload Management in WebLogic Server 9.0 by Naresh Revanuru
Avoiding Unnecessary JSP Recompilation by Nagesh Susarla
WebLogic 9.2 Server Performance and Tuning manual
WebLogic 9.1 Server Performance and Tuning manual
WebLogic 9.0 Server Performance and Tuning manual
WebLogic 8.1 Server Performance and Tuning manual
WebLogic 7.0 Server Performance and Tuning manual

WebSphere
WebSphere Application Server V6: Scalability and Performance Handbook
WebSphere 6.0 Tuning Performance from WebSphere documentation
WebSphere 5.1 Performance Tuning and Monitoring (pdf) from WebSphere documentation
Recommended reading list: J2EE and WebSphere Application Server from IBM Software Services, includes Performance and Monitoring
WebSphere 5.0.2 Performance Tuning and Monitoring (pdf) from WebSphere documentation
WebSphere V5.1 Performance, Scalability, and High Availability IBM Redbook
DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide IBM Redbook
Meet the experts: Stacy Joines and Gary Hunt on WebSphere performance
Monitoring WebSphere Application Performance on z/OS

MQ
Performance: Getting the Most Out of WebSphereMQ

Microsoft SQL Server
SQL Server 2008, Monitoring and Performance from Microsoft MSDN
SQL Server 2005, Database Engine Administrator InfoCenter from Microsoft MSDN
SQL Server 2000, Optimizing Database Performance Overview from Microsoft MSDN
SQL Server 2000, Monitoring Server Performance and Activity from Microsoft MSDN
SQL Server Performance site about Microsoft SQL Server performance tuning and optimization
Analyzing and Optimizing Performance SQL Server 2000 Analysis Services, from Microsoft MSDN
SQL Nitro, network acceleration for SQL Server

Oracle
Oracle Database Performance Tuning Guide 11g Release 1 (11.1) manual from Oracle
Oracle Database Performance Tuning Guide 10g Release 2 (10.2) manual from Oracle
Oracle Database Performance Tuning Guide and Reference 9i Release 2 (9.2) manual from Oracle
Oracle database performance problems and tuning by SearchOracle.com (free registration required)
Oracle Statspack Survival Guide
Automatic Workload Repository
Learning Guide: Performance tuning by SearchOracle.com (free registration required)

DB2
DB2 UDB Practical Performance Tuning by John Maenpaa
DB2 8.2 Administration Guide: Performance (pdf) from DB2 8 documentation
DB2 7.2 Administration Guide: Performance (pdf) from DB2 7 documentation
DB2 UDB V7.1 Performance Tuning Guide IBM Redbook
DB2 Performance Expert for Multiplatforms V2 IBM Redbook
DB2PORTAL.com DB2 resources for the mainframe
DB2 UDB for z/OS Version 8 Performance Topics IBM Redbook
DB2 9 for z/OS Performance Topics IBM Redbook
DB2 UDB for z/OS: Design Guidelines for High Performance and Availability IBM Redbook
DB2 for z/OS: DB2 Universal Database concurrency by Fred Whitlark
A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS IBM Redbook
Local vs Remote Database Access: A Performance Test IBM Redpaper
DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide IBM Redbook

MySQL
MySQL Server Performance Tuning by Jeremy Zawodny (free Linux Magazine registration required)
MySQL 5.1 Reference Manual

Oracle Applications
Oracle Documentation for all products
Oracle E-Business Suite Technology - Optimizing Performance blog

Oracle EPM and BI
Oracle EPM and BI Documentation
Oracle EPM and BI White Papers

Modeling Tools

BMC Performance Assurance solutions (former BEST/1, Patrol Perform &Predict)

TeamQuest
        How to Do Capacity Planning

Metron Athene, "provides ITIL-compliant capacity management, automatic performance analysis and reporting for UNIX, Linux, Windows and Mainframe Servers."

HyPerformix Predictive IT Management Suite includes HyPerformix Optimizer (uses discrete event simulation modeling technology), HyPerformix Capacity Manager and HyPerformix Data Manager.
    Integrated with LoadRunner.LoadRunner is one of data sources for Hyperformix. For some time Mercury promoted HyPerformix as Mercury Capacity Planning.
    Wilson Mar's notes

OPNET IT Guru Systems Planner

PDQ - open source from Dr. Neil Gunther

Ptolemy II is a set of Java packages supporting heterogeneous, concurrent modeling and design from UC at Berkeley, free for academic and commercial use.

Microsoft System Center Capacity Planner

A Collection of Modelling and Simulation Resources on the Internet by Andrea Emilio Rizzoli

Application Performance Management Tools

Gartner Magic Quadrant for J2EE Application Server Management, 2005

Oracle Enterprise Manager manages Oracle and non-Oracle technologies within a single console. Oracle Application Diagnostics for Java.

HP Diagnostics (former Mercury) is integrated with both Performance and Business Availability Centers. Includes Mercury Diagnostics for J2EE (former LoadRunner Transaction Breakdown), .Net and ERP/CRM (Siebel, Oracle, and SAP NetWeaver) and Deep Diagnostics for J2EE (former Performant OptiBench).

Wily Introscope gives the ability to quickly isolate and resolve performance issues in each stage of the application lifecycle. J2EE.

Precise Software Application Performance Management (was also Symantec, Veritas) solutions to optimize the performance and availability of enterprise applications including J2EE, .NET, databases (DB2, Oracle, and SQL Server), and ERP/CRM (SAP, PeopleSoft, Siebel, and Oracle Applications).

Quest Application Management (including former Sitraka products) optimizing performance and availability for J2EE, Oracle E-Business, PeopleSoft, SAP, Siebel.
Quest Database Management  ensures database quality, performance, and availability for Oracle, DB2, SQL Server, MySQL, and Sybase.
Quest White Papers

IBM Tivoli Application Management, including products from acquired Cyanea and Candle
Large-Scale Implementation of IBM Tivoli Composite Application Manager IBM Redpaper
IBM Tivoli Composite Application Manager V6.0 Family: Installation, Configuration, and Basic Usage IBM Redbook

IBM Enterprise Workload Manager Resources. An IBM attempt to extend the mainframe technology to other platforms.
IBM Enterprise Workload Manager V2.1 IBM Redbook
Hardening the EWLM Performance Data IBM Redpaper
Performance monitoring with Enterprise Workload Manager. Enable ARM instrumentation for end-to-end performance monitoring in IBM middleware on AIX and Linux by CheKim Chhuor

Compuware Vantage products, including Vantage Analyzer for J2EE
Compuware Strobe application performance management for z/OS applications

OPNET application performance solutions including Panorama (former Altaworks) "realtime application monitoring and analytics".

QuickVision from ClearApp Production Monitoring & Diagnostics for WebLogic and WebSphere (former Acsera)

Identify AppSight is positioned a little differently. "AppSight's patented Black Box technology monitors application execution and captures a synchronized record of user activity, configuration, and code execution in real time. Simply play back the Black Box log to quickly pinpoint the root cause of problems. That's any problem - performance, configuration, functional, or user errors - in Windows, .NET, and J2EE applications". Part of BMC Software.

BEZ Systems BEZPlus Predictive Performance Management solutions for Oracle, DB2, and Teradata.

Symphoniq TrueView "monitors Web application performance from browser to back-end to automatically detect and diagnose problems inside or outside the datacenter."

Nimsoft (acquired Indicative) proactive service level, application performance and business service management

dynaTrace performance diagnostics of Java/J2EE and .NET Applications, promises a deep look into the inner workings of applications under load

Performance Management directory from KnowledgeStorm

Enterprise Monitoring Tools

PerfMan from ISM, cross-platform from Windows to z/OS

PerfCap Performance Management and Capacity Planning software, supported on IBM-AIX, HP-UX, SUN Solaris, Tru64 Unix, Linux, Windows NT/2000/XP and OpenVMS platforms

WHAM monitoring and low-overhead profiling for AIX, Solaris, and Linux

Performance SeNTry (also known as NTSMF) from Demand Technology, high-performance Windows performance monitor

Sysload from Sysload Software, cross-platform including agents for databases and applications

Meta-View Performance Manager from Lund, Windows and different flavors of UNIX

Performance and Availability Management from NetIQ

PROGNOSIS from Integrated Research (IR), "real-time, systems management software for high-availability computing environments"

Performance Management from ASG (acquired Landmark)

MonitorIT from Breakout Software, "Complete WINDOWS, SNMP, & SYSLOG Monitoring"

Heroix multiplatform, automated monitoring and management software

BMC ProactiveNet Analytics (former ProactiveNet) end-to-end performance monitoring and real-time analysis to identify performance issues

List of Free Performance Monitoring Tools from MFJ Associates

Transaction Tracking / Business Activity Monitoring

Oracle Enterprise Manager Real User Experience Insight (former Moniforce UXInsight) monitors real user activity, provide analysis and notifications

HP TransactionVision (former Bristol Technology) tracks customer transactions throughout their entire lifecycle. It provides Business Process Monitoring that increases visibility into your customer facing transactions.

SeaView/RTM (Response Time Monitor) "passively captures network packets via a spanned port on the server switch. The software discovers and captures granular data describing all application sessions in real time. Built into the SeaView architecture is the ability to plug in application-specific modules that probe deeply into captured packets to measure the performance of actual business transactions."

TeaLeaf "provides real-time, browser-level visibility into every customer's online experience."

OpTier "delivers end-to-end visibility and control of all business transactions, across all tiers."

Quest End User Management

Coradiant End-User Experience Management

Business Activity Monitoring with WebSphere Business Monitor V6.1 IBM Redbook

Business Activity Monitoring (BAM) directory from KnowledgeStorm

Performance-Related Technologies

DataSynapse virtualizes applications across a real-time infrastructure

Appistry Enterprise Application Fabric (Appistry EAF) "software-based environment for running large-scale, time-critical applications on commodity-grade computers, without sacrificing dependability or manageability"

Network Performance Management

NetPerformance.com "the first Web site dedicated to network performance management"

Guide to Network Performance Management and Network Performance Management from TechTarget (free registration required)

The End All of Network Performance Management by Bruce Boardman, six network performance management products tested (Argent Guardian 6.0a, Compuware Vantage 8, Concord eHealth Suite 5.0.2, NetScout nGenius Performance Manager 1.4, NetQoS SuperAgent 3.0, and ProactiveNet 4.1.2)

Network Performance Directory

List of Free Performance Monitoring Tools from MFJ Associates

John Sellens's System and Network Monitoring Page

NetQoS "Performance First Network Management"

  LoadRunenr没有监控Tomcat的专用监控器，为了用lr达到监控tomcat的目的可以通过打开Tomcat自带的Status页面之后，利用lr的关联技术得到相关的数据，把数据输出到lr自定义的监控器中。

   1.打开Tomcat的status页面，方法为编辑Tomcat的conf目录下的tomcat-users.xml文件，在文件中添加
<tomcat-users>
  <role rolename="manager"/>
  <user username="admin" password="pass" roles="manager"/>
</tomcat-users>

  2.开发lr脚本

  lr_start_transaction("monitor tomcat");
  web_reg_save_param("JVMFreeMemory",
     "LB=Free memory: ",
     "RB= MB",
     "Ord=1",
   LAST);
   web_reg_save_param("JVMTotalMemory",
   "LB=Total memory: ",
   "RB= MB",
   "Ord=1",
   LAST);
 
    web_reg_save_param("JVMMaxMemory",
     "LB=Max memory: ",
     "RB= MB",
     "Ord=1",
    LAST);
 
    web_url("status",
        "URL=http://{ServerName}/manager/status",
        "Resource=0",
        "RecContentType=text/html",
        "Referer=",
        "Snapshot=t1.inf",
        "Mode=HTTP", 
    LAST);
 
   lr_end_transaction("monitor tomcat", LR_AUTO);
 
// Tomcat JVM metrics
  lr_user_data_point("Tomcat JVM Free memory", atof(lr_eval_string("{JVMFreeMemory}")));
  lr_user_data_point("Tomcat JVM Total memory", atof(lr_eval_string("{JVMTotalMemory}")));
   lr_user_data_point("Tomcat JVM Max memory", atof(lr_eval_string("{JVMMaxMemory}")));

     10年企业靠人、50年企业靠制度、100年企业靠文化。精神不是公司的规章制度，不是公司的发展战略，它是公司的愿景、使命和核心价值观。公司是一个有生命的组织，如果它没有思想、文化、灵魂，它就会失去生命。公司愿景是指企业实现的未来景象，回答的是“企业在未来将成为什么样的企业”。也就是企业长期发展的方向、目标、目的、理想、愿望,以及企业自我设定的社会责任和义务，明确指定公司在未来社会范围是什么样子。

     伟大的公司一定是长跑冠军的公司、做长线的公司、经营未来的公司、做百年老店的公司。

     转： “没有愿景，就没有灵魂。为了赚钱而赚钱，就不会赚钱。为了追求理想，就要不断地学习，向前走，就会成长。人没理想是很痛苦的事。企业也像人一样，先要有下一个理想等着你。公司是一个实现理想的地方，让所有的人成为一个团队，实现共同的梦想。”

       星期天下午到公司，接到一封同事孙宗卫发给我的邮件，附件有一份聊天纪录，看了聊天纪录之后，心里特别不舒服，以为是我们自己的学员。事情是这样一个人在网站（www.51testing.net）上咨询51testing的培训，然后加了孙忠卫咨询，后来说到就业问题的时候，该学员指责51testing上的就业名单都是虚假的。其中该小伙义愤填膺，多次脏话出口，后来说是51testing在深圳已经毕业的学员，而且毕业了5个多月了（但是深圳51testing第一期学员要到12月20日左右才毕业，现在班级里接近三分之一已经找到工作），如果毕业后在一定时间里没有找到工作51testing是要全额返回学费的，他后来又改口说自己是北京的学员，找到北京的同事，北京说没有这样的学员。

      看了下聊天纪录分析来分析去，也不像我们自己的学员。所以把这个人的qq个人信息打开，看看有什么蛛丝马迹看到个人信息有一个51JOB上的个人简历，就登陆到51JOB上察看该人简历，看到了该人简历之后，终于明白了，该人为 “某培训机构“ 的学员，简历中写他在一家公司工作，但是这家公司根本就是一个培训的公司不可能有他写的职位（该公司的招聘岗位信息  http://www.tarena.com.cn/job.asp）。

    为什么会这样，我觉得很多都是培训机构的功利行为，只为了赚钱而不是为了真正帮学员解决问题，在北京的时候，记得很早以前就有两个做测试的两口子做软件测试培训，晚上在自己的家里开课，周六周日上课，既不耽误工作又可以赚钱，想想我自己也挺羡慕的。在上海一个朋友给某一个培训机构当兼职老师，觉得挺不错然后自己搞了一个网站，拉了一帮人 全国到处做培训，另外一个人培训lr 600块两天培训，有人说骗钱 培训一点没有效果自己都没有把问题搞明白就去给别人培训。捞一笔的人太多了，导致大家对培训都不信任了。

   附上聊天纪录：

追风  13:36:30
你们的就业情况怎么样
孙老师 13:36:51
来选择一个培训主要有二点，一点是学到实际的技能， 二点是有个好的工作
孙老师 13:37:00
这两点在51都能保体现
追风  13:37:21
哦
你们拿什么保证　
孙老师 13:38:47
关于技能，从04年开始到目前一直致力于软件测试专业培训，涉及有企业内训，就业培训，周未培训，测试外包服务，测试工具等业务，
孙老师 13:39:16
关于就业是通过入学考试签订合同保证就业
追风  13:39:45
哦
你们要学哪些课程
追风  13:40:14
你们是用什么语言的
孙老师 13:40:49
考试要考C语言和数据库
追风  13:42:44
什么考试
孙老师 13:43:49
入学考试
追风  13:44:54
哦
这么严重

追风  13:48:04
哦
可不可以看看你们的就业名单

孙老师 13:48:19
网上每一期学员的就业信息都有的
追风  13:48:39
什么网址
追风  13:48:53
我要看真实的

孙老师 13:49:06
网上信息是真实的
追风  13:49:28
你们是不是先就业后付款的
追风  13:49:55
什么网址
孙老师 13:50:44
www.51testing.net
追风  13:56:59
你们学生全部没有电话号码的
追风  13:57:13
又没有工资的
追风  13:57:29
不随便你们怎么写都行
追风  13:59:35
鬼才相信你们呢
孙老师 14:00:53
嗯，给你发了邮件，里面有信息，你可以查收一下
追风  14:02:29
这些都是没用的
追风  14:02:42
你知不知道达内
追风  14:03:03
别人还先就业后付款呢
追风  14:03:21
也有一大堆人未就业
追风  14:03:40
不要再骗人了
孙老师 14:03:51
嗯，你要这样说我就没有什么话可以说了
孙老师 14:04:01
先就业后付款需要本科学历，不是没有的
追风  14:05:22
妈的
垃圾
我就是从你们哪里毕业的
追风  14:05:31
现在没找到工作
孙老师 14:06:05
嗯，那你为什么不直接在客户聊天的信息直接说呢，而非要等待到我这里呢
追风  14:07:02
没有呀
是你们的一个贱人要我加的
追风  14:07:19
我操你们老母
孙老师 14:08:32
可以说说你现在的问题吗，我能帮你做些什么的
孙老师 14:08:47
你这么发脾气也解决不了问题，你说是吗
追风  14:09:23
我花了钱
还是找工作不到
追风  14:09:41
你们教的东西没用

追风  14:09:59
你们还要到处骗人
孙老师 14:10:01
嗯，你可以把你的简历发给我吗
追风  14:10:21
发给你有个屁用
追风  14:10:38
不要再忽悠别人了
孙老师 14:10:37
我这边找我们就业老师帮你修改给公司推荐的
追风  14:11:11
我们班上现在还只有几个人找到工作了
追风  14:11:34
怎么办
靠你们早就饿死了
孙老师 14:12:41
你是在哪里培训的呢
追风  14:13:00
深圳
追风  14:13:12
我现在到广州找工作了
追风  14:13:22
就快要回家过年了
孙老师 14:13:25
可以说下你的名字吗
追风  14:13:51
妈的
骗死人不偿命
孙老师 14:15:12
首先不管怎么说，如果没有找到工作，半年之内是需要把学费退还给你们的
追风  14:15:44
有吗
那我就快五个月了
孙老师 14:16:12
对于目前的工作情况是因为金融危机的影响而且再加上过年了，好多公司都停止招聘了
孙老师 14:16:39
嗯，您是51testing培训的吗
追风  14:16:52
是呀

孙老师 14:16:58
深圳51testing培训暂时还没有毕业的
追风  14:17:11
就是被你们骗的

孙老师 14:17:16
你是否弄错了的
追风  14:17:36
绝对没错
孙老师 14:18:10
嗯，那应该学员还没有毕业的
孙老师 14:18:35
最早一期学员要到12月20日左右全部结束课程的
追风  14:20:15
妈的
老子还是北京学的
到北京，深圳，广州都找不到
孙老师 14:20:56
嗯，你是在北京学的哪一期学员
追风  14:21:17
告诉你有用吗
孙老师 14:21:28
可以的
追风  14:21:56
我已经对你们失去了信心

追风  14:22:14
明年就等你们退钱了
孙老师 14:22:50
嗯，你有跟学样签合同的
追风  14:23:17
是呀
孙老师 14:23:37
嗯，是可以按照所签合同履行条款的，这个你不用担心
追风  14:23:47
你们不退钱
老子就去你们哪里吵
追风  14:24:17
把你们的牌子砸了
孙老师 14:25:13
不会的，你是什么时候毕业的呢

    觉得这个孩子挺可怜的

    希望世界上少一点急功近利的公司 多一些真真做事情的公司 真正为大家解决问题。

本文转之北京同事马丽的空间，北京51testing从2007年3月23日开始做就业培训以来，到现在已经开了接近20期班（马上月底就业开新的一期班），现在北京同时并行开班8个班，在读学员就有300多人。离开北京有4个多月，很怀念北京的同事，看到本篇11楼的厕所，感慨万千。。。。。。。。。。。

http://new.qzone.qq.com/274115296

11楼的厕所比较倒霉
因为51TESTING的存在，11楼的厕所每天都跟过年一样的热闹
可能整个大厦只有11楼的厕所每天都是大门敞开，气味新鲜
11楼打扫卫生的阿姨每天唠叨个不停，虽然不知道她今年多大岁数，但我怀疑她应该是开始更年期提前。
她像个卫生监督员
只要白天她在这个楼层工作，就会跟交通警察一样，盯着每一个上厕所的人，并且指导你如何正确使用公用厕所。
每次上厕所如果遇见她，就会莫名其妙的变的紧张……
不光是我们得到她的特殊照顾，连隔壁办公室的大爷们拎暖壶打热水，她也要照看，并且不时的盯着壶底儿是否漏水
阿姨特别希望能做我们的生活班主任，我觉得如果她做生活班主任，绝对够资格，她巴不得每次开班都站在讲台上给全体新生介绍一下公共厕所的使用须知、注意事项。

倒霉的11楼的厕所，每天都是灾难重重
每次一下课，
排队现象不差于买火车票了
就连12层的厕所也跟着倒霉
呵呵，谁让我们人多呢。

http://www.51testing.com/batch.download.php?aid=12211

     转：一位"准失业者"写下了这样感伤的文字："七成的公司不招新员工了，八成的人不跳槽了，2009年的毕业生加往届生总共有600多万，我是其中一个不幸者。我将第一个离开深圳，麻烦最后离开的人，把灯关掉。"

     一直以来觉得金融危机对我来说只是一个话题，对自己可能影响不大，没想到金融危机的影响就在身边。前几天妈妈从韩国打电话过来，说韩国现在经济不景气，很多企业都倒闭了，现在韩币也贬值和去年的收入由于汇率的影响收入就减少了一半，妈妈也准备从国外回来了。这点可能对岛国外务工的人经济危机意味着收入减少，可能对国内出去旅游留学的人来说是一个好消息，可以节省很大一笔开支。

      记得5月份的时候同事王威去番禺交流回来来，说那里已经有很多企业倒闭那个时候更多直接的原因是人民币汇率上升，导致很多对外制造加工企业没办法生存下去，而现在更多的企业倒闭是因为国外订单减少，下半年很多企业生产的都是上半年的订单，估计到明年年初还要有很多企业倒闭，不知道有多少人要失业。

      金融危机的影响从10月份开始逐渐显示出来，9月份和10月份企业对情势的预估跟现在完全不一样，前两周去深圳中兴交流，一位部长就表示9月份和现在他们对形势的判断是两个样子，9月份的时候觉得明年会业务增长很快，但是现在觉得明年就不明朗了，本来要做的高校招聘也由于金融危机的影响暂时停止了。因为51testing的有就业培训的业务，要保证就业，其中有一家公司本来已经给我们6个学员口头的offer，其中三个已经得到了正式的offer，另外三个一直在等着家公司总经理的批准，据说以前没有这么流程繁琐，但是他们公司刚开了一个会议由于经济危机影响所以招聘人员一定要通过总经理审批，进人要慎重。老婆所在的公司在10月份虽然获得了风投的资金投入，但由于经济危机影响预备过冬，内部员工大部分做了降薪处理。

     北京的一位作测试的朋友在msn上交流的时候告诉我最近在找工作，但是他周围的人都反馈各个公司在裁员，她自己虽然有四年多的工作经验但是随着时间推移，对薪水要求也一降再降只要5k，但是工作仍然没有找到。我通过一个朋友知道了另外一位朋友因为公司裁员离职了，现在在找工作，这位朋友2年多的工作经验薪水12k/m多，因为金融危机也从新踏上了找工作的路。

     冬天来了，你做好准备了么？不知道春天什么时候回来，应该做好过冬的准备，今天买了2本书准备加强学习，练好内功，以备不时之需。

社保不是很了解，总以为是交得越多越好，因为你交得多，公司相应就交得更多。但是最近这两天仔细研究了一下社保政策，真是有点大吃一惊，发现完全不是这么回事，从某种意义上来说，反而是交得越多越亏。

　　 以上海为例，社保的基数上限是前一年的平均工资的三倍，2006年为2235*3=6705元，假设你的工资为8000元，那么将以6705为基数缴纳社保。

　　 首先是养老保险，这个金额是最大的，个人8%，即536元，单位22%，1475元。但是请注意，单位交的一分钱都不会进入你的个人账户！全部用于社会统筹。那么到了你老了养老金怎么领取呢，这个我在网上查了一下，居然找不着一个明确的官方文件说明。比较普遍的说法是，养老保险累计缴纳15年并达到法定退休年龄后，可以按月领取养老金，养老金金额=基础养老金＋个人账户养老金=退休前一年全市职工月平均工资×２０％＋个人账户÷１２０。这就相当于，除了个人账户不一样外，大家领的基础养老金都是一样的。那么显然现在交得越多是越亏的，因为个人账户其实都是你自己交的钱，你不交社保把它存银行也是一样的。但是公司替你交的那部分就完全替国家做贡献了，交的越多贡献越多。难怪很多公司都把基本工资开得很低，而提高奖金和补助，这样可以把省下来的那部分保险作为福利发给个人。而同时，你享受的养老保险待遇不会有什么差别。

　　再说医疗保险，个人2%，134元，单位12%，804元。同样，只有自己交的进入个人账户，单位交的全部被统筹。医保的报销政策是：对于门诊，先由其个人帐户资金支付，帐户资金用完后由个人自负。说白了就是一分钱不给报，而且还只能去指定的医院用指定的药！对于住院，有个起付标准，好像是两千多吧，这个标准以下由个人账户支付，个人账户不足的自己掏现金，也就是这两千多还是全部你自己出。超过起付标准且低于医保最高限额的由统筹基金支付85%。这个标准同样是大家统一的，与你交得多少没关系。与养老保险一样，公司交的那部分医疗保险被国家给“劫富济贫”了，与你没有任何关系。

　　 其次失业保险，个人1%，单位2%，加起来200，这个真的是一点用都没有，反正你都拿不到，即使你真的失业了。

　　 最后是住房公积金，个人7%，单位7%，一共938，这个倒是全归你个人，不过说到底其实本来就都是自己的钱，国家没有投进任何福利。

　　 这样算下来，公司在8000的工资以外，还要替你交1475+804+134+469=2882元，相当于实际每个月为你付出了10882元，而你实际得到的呢？首先，扣除社保后的工资为，8000-536-134-67-469=6793元，这6793元要扣掉663元的税，到手现金是6129元。再算上你个人账户里的养老保险、医疗保险以及公司和个人交的公积金总额，你一个月的实际收入为6129+536+134+938=7737元。

　　 我们假设另外一种情况，还是这个公司，它每个月在你身上的预算是一样的，即同样为你付出10882元。但是它把基本工资开得很低，按上海市规定的社保基数下限（月平均工资的60%，即2235*0.6=1341元）给你发，剩余的钱以奖金和补助形式发给你。这样，公司需要交纳的社保为：295.+160.9+26.8+94=577元，你个人交纳107.2+26.8+13.4+94=242元，扣掉四金后工资还剩1099元（还没到个税的起征点）。公司可以给你发的补助为10882-1341-577=8694元，这样你的补助加上扣除社保后的工资一共为：8694+1099=9793元，这9793元扣掉所得税1263元（据我所知很多公司这种福利和补助还可以避税，姑且把这个算上吧，毕竟纳税是每个公民的义务）剩8530元，这就是你到手的现金。算上个人账户的保险和公积金，一个月实际收入为8530+107+27+198=8862元。与上面一种情况相比，公司为你付出的钱都是10882元，但是你到手的现金多了8530-6129=2338元，实际收入多了8862-7737=1125元。而你享受到的基础养老金、医保统筹金这些国家福利是一样的！

　　 不能不说这是一种很不公平和合理的制度，社保至少应该保证“高投入，高福利”，但是实际上反而成了交得越少，却能获得更高的利益。不知道这应该是谁的悲哀。

Necessary Tools

WinDbg (Debugging Tools for Windows – Microsoft FREE utility to debug programs)

IDA32 (Interactive Disassembler – to reverse binaries to asm source)

Hiew32 (Hex editor – to change binaries)

Assembler language knowledge J

Short brief

I’ll skip all my wrong attempts to find real initialization/license checking code block (it took almost two days to get to the right program point to start thinking on) and as usual, its was mostly done by intuition.

After reversing lm70.dll, I get very good source file with excellent function names and some links to interesting string variables, like “Init”, “CheckRWAccess”, etc. After investigation of such string variables, I found a function which makes “current operation” logs with status flag indications, so it was a real debug output (mb developers forgot to remove). The function makes output depending on “debug switch” on/off, so set to “true” to get operations results output in file ("C:\Documents and Settings\<user>\Local Settings\Temp\lm60trc.txt”). The most interesting is – all functions return only error codes (“0” all fine or “<> 0” on error)! Going thru “CheckRWAccess” the functions, I noticed some code sequence which fills some memory block with non-logic data, but before procedure ends, that non-logic block was decoded into different license database files names (cfgamp.dlls). After that I’ve changed my PC timer for 20 days forward. When investigating “Init” function results, I set results to “0”, but LoadRunner tells me “you have last day to evaluate program”. Nice… It was due to cfgamp the license database being encoded with sub-status – “you have one day left”. Finally, determined complete solution with no time restrictions and no message boxes.

Done with LRLauncher, but when executing LRController – it hangs on user amount – another procedure another check, so previous lookup method don`t help much.  After that I restored Temporary license to get closer look at LRController work. On user amount > 25 it shows license warning message box – excellent, lets start from MessageBoxA function. By setting breakpoint on MessageBox I get program point, where this message box called and un-winded execution until found where is condition checked “licensed max amount <= current_user_num”. It was single procedure called from lm70!Test function. After I set that procedure to return “0 (all fine)” it works with 100 users w/o problems.

Note: to get more detailed brief you need to install at least IDA32 or WinDbg.

Step 1: CPU usage
首先要通过通过了解CPU使用率来诊断SQL Server性能，
通常是方法有两种：
第一：你可以使用远程桌面的察看任务管理器中CPU的使用率
第二：监控以下计数器
Processor: % Privileged Time
Processor: % Processor Time
Processor: % User Time
System: Context Switches/sec
System: Processor Queue Length

Step 2: Disk IO
监控性能计算器：
Physical Disk: % Disk Read Time
Physical Disk: % Disk Write Time
Physical Disk: % Idle Time
Physical Disk: Avg Disk Bytes/Read
Physical Disk: Avg Disk Bytes/Transfer
Physical Disk: Avg Disk Bytes/Write
Physical Disk: Avg Disk Queue Length
Physical Disk: Current Disk Queue Length

Step 3: Memory
内存指标：
Memory: Available Bytes
Memory: Pages/sec
Process: Working Set
SQL Server: Buffer Manager: Buffer Cache Hit Ratio
SQL Server: Buffer Manager: Total Pages
SQL Server: Memory Manager: Total Server Memory (KB)
SQLServer:Cache Manager - Cache Hit Ratio - _Total
SQLServer:Cache Manager - Cache Pages - _Total
Memory: Page Reads/sec
Memory: Page Writes/sec
Memory: Page Input/sec
Memory: Page Output/sec
Paging File: % Usage

Step 4: Network
网络监控：
Network Interface: Bytes Received/sec
Network Interface: Bytes Sent/sec
Network Interface: Bytes Total/sec
Network Interface: Current Bandwidth
Network Interface: Output Queue Length

Step 5: Transaction-level performance
通过SQL事件探查捕捉事务运行情况。
Sp_monitor ：快照的SQL Server统计
Sp_who ：SQL Server进程快照
Master.dbo.sysprocesses ：存储SQL Server进程有关的信息的系统表
DBCC OPENTRAN
DBCC INPUTBUFFER

        2008年10月19日晚10许  深圳岗厦居民小区一住宅楼7楼  pcl老婆在家里客厅发现一只老鼠穿堂而过,全家哗然，二人惶恐不安，彻夜不眠  （佩服老鼠之高超绝技7楼也可登堂入室）

        2008年10月20日中午12点46分 深圳51testing华强北培训中心办公室 pcl请教高人-深圳公司捕鼠专家，曾经小时候抓过老鼠，吃过老鼠肉，老鼠听见就跑，见到就腿软得-小张（深圳51testing财务大臣），指点迷经，告知晚上搞定

        2008年10月20日晚20点36分，公司小盛归来，手拿多种捕鼠利器------老鼠胶，老鼠夹等，老婆和小盛经过仔细分析战略地形，部署阵地，在家中关键角落放置以上利器

        2008年10月20日晚22点24分，只听小盛高声呼叫”老鼠“，只看到一长约20厘米，腰围10厘米的老鼠在屋中客厅横躺在老鼠胶之上，翻滚腾越，小盛艺高人胆大拿起苕梳拍打，怕老鼠夺路逃跑，我用老鼠贴从上覆盖双面胶上老鼠，老鼠吱吱之叫，找盆覆盖，拿起老鼠胶放置兜子中，寻地扔掷。。。。。。。。。。。。

        2008年10月20日晚10点45分，我双手高举大袋，内中放置老鼠，空中响彻老鼠之嚎叫，我奔之楼下扔小区之垃圾桶中。。。。。。。。。。。。。。。

       2008年10月20日晚10点52分，急跑回7楼家中，发现汗流夹背，后怕不已。。。。。。。。

       不知今夜是否还有老鼠出没。。。。。。。。。。。。。。。。。。

winRunner api 调用，例子中实现如何获得功能执行时间

load_dll ("C:\\WINNT\\SYSTEM32\\kernel32.dll");
extern int GetTickCount();
<code code code>
start=GetTickCount();
<transaction to be timed code goes here>
end=GetTickCount();
# Note posting to a file
post_tick_count_time_lapse(start,end,"Transaction Title","C:\\temp.txt");

#-----------------------------------------------------------------------------------------------------------------
# FUNCTION CODE BELOW
public function post_tick_count_time_lapse (in starttime, in endtime, in transtitle, in filename)
{
# Declare variables
auto timelapse;
# Validate parameters
if (nargs() != 3 && nargs() != 4)
{
tl_step ("get_tick_count_time_lapse", FAIL, "Only 3 or 4 parameters are allowed.");
return(E_ILLEGAL_NUM_OF_PARAMS);
}
# Determine how long the transaction took and round
timelapse = int((endtime - starttime) + .5)/1000;
# Post timelapse
if (nargs() == 3) # Was no ouput file specified
report_msg (transtitle & " : " & timelapse & " seconds"); # Send output to the test results
else   # There was an ouput file specified
{
print (transtitle & " : " & timelapse & " seconds |" & get_time()) >> filename; # Append output to specified file
# Note "|" is a file delimiter above
close(filename);
}
return(E_OK);
} 

mysql 停止启动命令如下：

# 启动 MySQL Server
root@localhost root]#  service mysql start
# 停止 MySQL Server
root@localhost root]#  service mysql stop
#停止mysql的另类方法
root@localhost root]#  pkill mysql
#重新启动 MySQL Server
root@localhost root]#  service mysql restart

根据以上命令实现shell mysql 监控脚本（以下脚本在RH9.0上调试通过）

#!/bin/bash
# ------------------------------------------------------------------------
# Mysql Process Monitor
# Restart MySql Server When It Goes Down
# -------------------------------------------------------------------------
# Copyright (c) 2008 http://www.51testing.com
# -------------------------------------------------------------------------

#Mysql start command
restart_mysql="service mysql start"

pgrep="/usr/bin/pgrep"

# mysql daemon name,
mysql_service="mysqld"

# find mysql pid
$pgrep ${mysql_service}

#if mysql is not runnint
if [ $? -ne 0 ];then

 # restart apache
 $restart_mysql

fi