Friday, November 12, 2010

Video for perftesting tutorials

http://www.hyperformix.com/resources/videos/hyperformix-101

http://h30423.www3.hp.com/?rf=sitemap&fr_story=0f253e548d222cbf881c3f070aa434e65b188f3e&jumpid=reg_R1002_USEN

http://wepcontent-pro-dmz.austin.hp.com/production_common/cninv000000000063508/LR90_WS/lesson00/index.html

http://wepcontent-pro-dmz.austin.hp.com/production_common/cninv000000000064898/intro_to_lrunner90/lessons/Introduction/player.html

Web-based - VuGen 9.0 Scripting for the Web, CBT Download for offline video and audio files in hp load runner,Quality Center 9.0 with Service Test Management (WBT)
http://h20507.www2.hp.com/Saba/Web/Main/goto/CourseDetail?courseId=00120487


http://h30187.www3.hp.com/tutorials/viewHowTo/p/courseId/14167/Microsoft_Excel_2007_create_a_PivotTable.htm?courseSessionId=173981&campusId=11263&webPageId=1000012

http://h20507.www2.hp.com/Saba/Web_wdk/Main/content/players/SequencedPlayerRedirect.rdf;jsessionid=LjwG7zpN9K1YhnWwvZJLCCw6hPQwnJqRCj99Sms2wyWKp6S2FGGL!-1459960610!1273213124888?caller=&contextId=ctctx000000028467298&isContentComplianceTestMode=&callerId=&startUserSession=&subscriptionId=ctnsr000000000132222&contentServerId=media000000000000002&contentInventoryId=cninv000000000061100&returnToCatalog=&contentFormat=IMS QTP


http://wepcontent-pro-dmz.austin.hp.com/production_common/cninv000000000064878/LR_Adv_Analisys/lessons/Steps%20Involved%20in%20Finding%20Root%20Cause/player.html



http://www.c-for-dummies.com/sourcecode/ C source codes

http://h20507.www2.hp.com/Saba/Web_wdk/Main/content/players/SequencedPlayerRedirect.rdf;jsessionid=M2rRRpW0mLS6791zJTXydh3vL1nl3dVpH8WScCG2G1dQKdwnLLKQ!-1691054806!1279175665392?caller=%2Fcontent%2FcontentDetail.rdf&contextId=ctctx000000032273764&isContentComplianceTestMode=&callerId=&startUserSession=&subscriptionId=ctnsr000000000143615&contentServerId=media000000000000002&contentInventoryId=cninv000000000066179&returnToCatalog=&contentFormat=IMS

http://fcgmoodle.wipro.com/moodle/mod/resource/view.php?id=770 C from wipro

http://h30507.www3.hp.com/t5/HP-LoadRunner-and-Performance/Video-Understanding-Iteration-Pacing/bc-p/52277#M66

http://searchsqlserver.techtarget.com/SQL-Server-PerfMon-counters-for-tracking-Windows-memory SQL Server pt Metrics

http://searchsqlserver.techtarget.com/SQL-Server-PerfMon-counters-for-Windows-operating-system-OS Windows OS using perfmon

http://searchsqlserver.techtarget.com/Monitor-SQL-Server-disk-I-O-with-PerfMon-counters

http://searchsqlserver.techtarget.com/SQL-Server-PerfMon-counters-for-access-methods-and-buffer-manager-2

https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=bto&cp=1-11-126-17%5E8_4000_100__

https://h30406.www3.hp.com/campaigns/2008/demo/loadrunner/index.html

https://h30406.www3.hp.com/campaigns/2008/demo/loadrunner_sap/index.html?jumpid=in_r11374_w1/en/large/tsg/0508demo_lrsap_registration

http://nptel.iitm.ac.in/courses.php All BE semester course

http://www.guru99.com/loadrunner-tutorial-1.html

Good Performance Testing links

http://www.webwob.com/uk/testing/files/LoadRunner_Advanced_Scripting_Techniques.html

http://ramya-moorthy.blogspot.com/

http://www.pea-online.com/resources.htm

http://lbdigest.com/

http://performancetesting-loadrunner.blogspot.com/2008/01/web-services-are-natural-delivery.html

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.perf.doc/perf48.htm

https://passport2.hp.com/hppcf/login.do?hpappid=SABA&TYPE=33554433&REALMOID=06-000659ec-5e07-18ee-ae15-1416ea5077b7&GUID=&SMAUTHREASON=0&METHOD=GET&SMAGENTNAME=$SM$4nTPdLmqlNKf7SEub%2bc05IBZsZn1hSSeCTB0wFM2xgz1IIv5Bb%2bR2QUT1LTx%2boLH&TARGET=$SM$http%3a%2f%2fh20507%2ewww2%2ehp%2ecom%2fSaba%2fWeb%2fMain

http://forums11.itrc.hp.com/service/forums/categoryhome.do?categoryId=915&filterType=1&pageNum=2

http://testscripts.blogspot.com/2006/10/dynamic-transaction-names-in.html

http://support.openview.hp.com/support.jsp


http://www.blogcatalog.com/blog/loadrunner-tips-tricks/bf1d2ddad7b64e751faf78a55b9c5ae8

http://www.jds.net.au/tech-tips/loadrunner-script-checklist/

http://loadrunnertnt.blogspot.com/

http://support.openview.hp.com/selfsolve/manuals

http://www.jds.net.au/?s=.net+in+load+runner

http://motevich.blogspot.com/2007/11/execute-qtp-script-from-loadrunner.html

http://ptfrontline.wordpress.com/2009/09/

http://www.embeddedsystems.com.au/kb/index.php/Category:LoadRunner

http://learnloadrunner.com/introduction/vugen-controller-and-analysis/


http://motevich.blogspot.com/2007_11_01_archive.html

http://www.myloadtest.com/

http://loadrunnertnt.blogspot.com/search/label/Full%
20Extended%20Log

http://www.alexanderpodelko.com/

wilsonmar.com

http://safari.informit.com/0201844540/pref01

Great links. I have a few related ones as well. (one could make a career out of understanding NT or W2K monitoring results):

Great website and a must for every development that builds Web applications with MS components. A lot of no nonsense information.
I learned a lot here! http://local.15seconds.com/focus/Performance.htm

Performance Tuning for MS SQLServer 7: http://www.microsoft.com/technet/treeview/default.asp?url=/Tech Net/prodtechnol/sql/maintain/optimize/sql7pt.asp

Optimizing IIS 5 (similar links on 4 can be found as well): http://support.microsoft.com/default.aspx?scid=kb;EN-US;q305313

Great starting page for deploying internet solutions that work with tons of interesting topics: http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/tcevents/i tevents/q1track2.asp

Performance Tune SQLServer 2000: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/tceve nts/itevents/sql2000/tnt04.asp

Any search in http://www.microsoft.com/technet/ using "performance", "tuning" etc. will give you a ton of information and documents.

Writing MTS-style Transactions with Visual Basic and SQL Server 7.0: http://www.microsoft.com/msj/defaulttop.asp?page=/msj/1099/mtsvb/mtsvb.htm

An informative white paper from Lucent on Network Performance Engineering Issues and Strategies http://www.lucent.com/livelink/161949_Whitepaper.pdf

Performance Analysis and Optimization of MS Windows NT Server http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/pro dtechnol/winntas/tips/ent407ef.asp

A set of slides and tips on general Web Performance Tuning: http://patrick.net/wpt/

A complete site devoted to SQLServer Performance, with tips, white papers etc. http://www.sql-server-performance.com/

http://www.alexanderpodelko.com/PerfManagement.html

http://perfwolf.com

http://loadstorm.com/blog

http://www.performancecompetence.com/wordpress/2009/11/26/performance-target-concurrent-usersactive-vs-connected-userspassive/

http://github.com/randakar/y-lib very good link for load runner programing

http://blog.testsautomation.com/tag/loadrunner/ web and web click and script links

http://ajaxian.com/archives/why-load-testing-ajax-is-hard AJAX

http://www.httpwatch.com/download/ HTTP watch Profiling tool

http://www.adobe.com/devnet/livecycle/articles/lces_performance_testing.html Silk performer

http://www.1202performance.com/2009/09/calculating-concurrency-from-performance-test-results/

http://www.loadrunnerbythehour.com/testexecution

http://www.testingperformance.org/loadrunner-oracle-nca-part1.php

http://www.kods.net/stag/loadrunner-script-for-writing-output-file-in-excel/

http://www.experts-exchange.com/Software/System_Utilities/Diagnostics/Q_22735416.html

http://software.intel.com/en-us/blogs/2008/04/03/using-perfmon-to-tune-n-tier-net-applications/

http://performancetestinginfo.blogspot.com/2010/04/client-side-certificates-with.html

http://www.pha.com.au/kb/index.php/LDAP_Search_Script ldap://hx30:6389/

http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm good for command line codes

http://randomsync.com/tag/Loadrunner/ for downloading pics

http://ajaxpatterns.org/On-Demand_Javascript Java lazy loading
From Subject Received Size
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [11-Nov-10] Thu 12:05 PM 74 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [9-Nov-10] Tue 10:48 AM 80 KB
Udhay Kumar VR(WT01 - SECURITIES) HAPPY and PROSPEROUS DIWALI - Performance Practice Tue 11/2 179 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [2-Nov-10] Tue 11/2 145 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [28-Oct-10] 10/28/2010 96 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [26-Oct-10] 10/26/2010 147 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [21-Oct-10] 10/21/2010 139 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [7-Oct-10] 10/7/2010 170 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [5-Oct-10] 10/5/2010 141 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [30-Sep-10] 9/30/2010 150 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [28-Sep-10] 9/28/2010 142 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [23-Sep-10] 9/23/2010 109 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [21-Sep-10] 9/21/2010 82 KB
Udhay Kumar VR(WT01 - SECURITIES) [IMPORTANT - PERF ENGRS] PoC on Lotus Notes Domino 9/16/2010 9 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [16-Sep-10] 9/16/2010 165 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [14-Sep-10] 9/14/2010 203 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [9-Sep-10] 9/9/2010 116 KB
Udhay Kumar VR(WT01 - SECURITIES) IBM RPT Certification - Rush your nominations - Limited Seats! 9/8/2010 141 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [7-Sep-10] 9/7/2010 53 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [3-Sep-10] 9/3/2010 129 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [31-Aug-10] 8/31/2010 113 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [26-Aug-10] 8/26/2010 53 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [24-Aug-10] 8/24/2010 182 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [19-Aug-10] 8/19/2010 69 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [17-Aug-10] 8/17/2010 143 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [12-Aug-10] 8/12/2010 144 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [11-Aug-10] 8/11/2010 67 KB
Udhay Kumar VR(WT01 - SECURITIES) HP Performance Center - Launching Web-based Training 8/9/2010 112 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [5-Aug-10] 8/5/2010 78 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [3-Aug-10] 8/3/2010 210 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [29-Jul-10] 7/29/2010 190 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [22-Jul-10] 7/22/2010 80 KB
Udhay Kumar VR(WT01 - SECURITIES) RE: Require O POSITIVE blood donors - URGENT! 7/21/2010 12 KB
Udhay Kumar VR(WT01 - SECURITIES) FW: Require O+ve blood donors - URGENT! 7/21/2010 11 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [20-Jul-10] 7/20/2010 56 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [19-Jul-10] 7/19/2010 100 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [16-Jul-10] 7/16/2010 153 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [15-Jul-10] 7/15/2010 152 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [14-Jul-10] 7/14/2010 50 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [13-Jul-10] 7/13/2010 48 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [8-Jul-10] 7/8/2010 111 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [7-Jul-10] 7/7/2010 103 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [6-Jul-10] 7/6/2010 101 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [2-Jul-10] 7/2/2010 126 KB
Udhay Kumar VR(WT01 - SECURITIES) RE: Performance Booster [1-Jul-10] 7/1/2010 162 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [1-Jul-10] 7/1/2010 203 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [30-Jun-10] 6/30/2010 179 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [29-Jun-10] 6/29/2010 84 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [28-Jun-10] 6/28/2010 137 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster [24-Jun-10] 6/25/2010 146 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun '10, Week 4, Issue 4 6/24/2010 136 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun '10, Week 4, Issue 3 6/23/2010 93 KB
Udhay Kumar VR(WT01 - SECURITIES) RE: Performance Booster - Jun '10, Week 4, Issue 2 6/22/2010 57 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun '10, Week 4, Issue 2 6/22/2010 78 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun '10, Week 4, Issue 1 6/21/2010 205 KB
Udhay Kumar VR(WT01 - SECURITIES) FW: TeS Competency Awareness Session - June 2010 6/18/2010 16 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun '10, Week 3, Issue 4 [TGIF] 6/18/2010 135 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun '10, Week 3, Issue 3 6/17/2010 126 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun '10, Week 3, Issue 2 6/16/2010 117 KB
Udhay Kumar VR(WT01 - SECURITIES) Performance Booster - Jun 10, Vol 1 6/15/2010 92 KB

Performance Booster – Jun 10, Vol 1

Performance Booster – Jun 10, Vol 1

Performance Article

How do you monitor SAp in loadrunner?



In LoadRunner SAP monitor, it requires the SAP CCMS (Computer Center Management System) for monitoring to be effective. This is unlike the typical monitoring mechanism that is used for Windows or Oracle, which is directly querying the monitor data from Windows Perfmon or Oracle v$ dynamic views. LoadRunner SAP monitor requires an additional component, SiteScope to act as an intermediary between SAP CCMS and LoadRunner.



LoadRunner itself does not have the capability to monitor SAP directly and solely depends on SiteScope to query/monitor SAP CCMS. SAP CCMS is already a powerful component in SAP as it is able to monitor anything in the SAP system. This ranges from server resources (e.g. processor or memory utilization) to oracle databases (e.g. buffer efficiency). You may not even require other tools to do monitoring in the first place! No additional configuration needed for monitoring Windows resources (Windows Resources) as SAP CCMS handles it by a single channel through SiteScope.



For SiteScope to communicate to SAP CCMS, it will require SAP Java Connector (JCO) to be installed on the SiteScope box with some configurations to access the SAP system. The detailed configuration can be found in Configuring Sitescope Monitors documentation (instead of LoadRunner). To download SAP Java Connector, you can go to Connectors in SAP site. You will need a valid SAP account to access the download page.



On the ports portion, you will need to have TCP32xx between the SiteScope and the SAP system and TCP8888 between SiteScope and LoadRunner. TCP32xx is the typical port number used by SAPGUI Front-end to talk to the SAP application servers while TCP8888 is used by LoadRunner to query the monitoring data displayed on the XML page of SiteScope. Both port numbers are to be opened on a two-way traffic communication.



As SiteScope is querying monitoring data just like a normal user running the CCMS transaction from SAPGUI Front-end, a SAP account on the SAP system required. The following information must be ready prior the setup of the monitoring.

• SAP Client

• System Number

• Authorization User Name

• Authorization Password

• SAP Router String (Optional)

Note: SiteScope requires an optional license to monitor SAP CCMS.

Performance Tip of the day

During run-time, ‘threaded’ vusers share a common memory pool. So threading supports more Vusers per load generator.

Test your IQ

Which is the most efficient DML statement? Why?

(a) SELECT …. FROM DEPT WHERE SAL * 12 > 25000

(b) SELECT …. FROM DEPT WHERE SAL > 25000/12