The Performance Focus
September - October | July - August | May - June
Welcome to “The Performance Focus”, the regular online round-up of news, technical tips and events of interest to the community at large from Enteros.
In this our premier edition, we reintroduce ourselves to our customers and launch us to the general user community and announce product launch of Load2Test 5.0, technical tips and much much more. In future issues of the Newsletter, we will share interesting articles, events and papers that will be of general interest to the performance and production IT community.
As the editor of the The Performance Focus please let me know how we are doing and what features you would like to see.
- Introduction to Enteros
- Patent Information for Enteros Root Cause Analysis
- Product Launch
- Technical Tip
Enteros is an innovative software and services company specializing in Production Performance Management. Enteros solutions help IT find and fix performance problems in business-critical applications, websites and data centers with unprecedented speed, accuracy, precision, and scope.
We achieve this by integrating support for production performance management across the production performance lifecycle. From proactive problem identification, real-time performance remediation, and advanced problem diagnosis, to accelerated problem resolution and scalable performance validation, we are the only company that puts it all together in one comprehensive, extensible platform.
Senior Management Team
• Ron Warshawsky, Founder & CTO, prior: EBAY (Principal of Database technology for SWAT/Production Architecture group), Allied Group Insurance/Nationwide Insurance and Principal Financial Group. As founder and Chief Technology Officer, Ron is responsible for the technical vision and direction for the Enteros product line. Ron holds an M.S. in Computer Science from Georgia Tech. University and a B.S. in Computer Science from Georgia Tech. University
• Ron Sigura Founder, President & CEO, prior: PDF Solutions (Vice President Sales & Marketing), WaferYield Inc. (Founder & CEO) acquired by PDF Solutions, Sycon Design (VP Operations, Sales & Marketing), WebAppoint (Founder & CEO) acquired by Microsoft, GuideTech (Founder GM VP Sales and Marketing).
Enteros’s CTO Ron Warshawsky was granted a patent for his real-time database performance and availability change root cause analysis method and system Document Type and Number: United States Patent 7203624
Abstract: Root cause analysis of changes impacting database performance, availability and continuity to the underlying business may be performed. A system for doing so may include analytical and visual comparison root cause analysis engines to identify changed database performance statistical parameters (such as CPU consumption, physical I/O, etc) related to a historical period of time on a single database or across multiple databases. Result data may be displayed through a series of charts and reports that may indicate whether correlations exist between unexpected database performance and relative changes in database performance statistical parameters. A visual root cause analysis system may further apply noise reduction algorithms to clarify trends in changes of database system performance.
Load2Test Release 5.0
Load2Test Release 5 introduces a more intuitive and elegant Load2Test User Interface. Everything, from the look of the scenario text editor and to the way the real-time load test data is displayed to the user, has been redesigned to be more appealing and accessible. Under the surface, Iteration 5 established Load2Test as a more powerful business flow recording tool, with support added for many more web protocols such as POP3, SMTP, FTP, JDBC and more. Additionally, flow playback has been made more versatile through extended agent configuration options, allowing the user to pass additional parameters to the databases and to configure output and rt logging separately. Furthermore, Load2Test iteration 5 continues to expand its template based summary and executive report creation functionality. Graphing of transaction data on sequence and flow levels has been added, and support for data aggregation, smoothing, and typecasting has been implemented to improve processing of vastly diverse multisource collections of data. Also, template creation has been made easier through the introduction of support for rational expressions and data typecasting.
“Plugging in” production AWR extracts into Enterprise PMDB and usage with PE-i™.
These are instructions on how to extract AWR production data and transport it into an enterprise PMDB. The transportable option of AWR will let production DBA’s to sustain manageable SYSAUX sizes and comply with the growing demands for performance data to be used for spikes analysis, capacity planning, trend analysis, what-if questions to name few. Upon completion of the data upload the reader will be presented with the way to view the newly data.
Setup: First, both databases must be running 10g, though different minor versions and different endian are supported. It is assumed that the PMDB will be running the higher minor version.
Extracting AWR data:
• At the SQL prompt, enter:
2. A list of the databases in the AWR schema will be displayed.
3. Specify the database from which the AWR data will be extracted:
4. Enter value for db_id: 3549044023
5. In this example, the database with the database identifier of 3549044023 is selected.
6. Specify the number of days for which you want to list snapshot Ids.
7. Enter value for num_days: 30
8. A list of existing snapshots for the specified time range is displayed. In this example, snapshots captured in the last 30days are displayed.
9. Define the range of snapshots for which AWR data will be extracted by specifying a beginning and ending snapshot Id:
10. Enter value for begin_snap: 17750 Enter value for end_snap: 20301
11. In this example, the snapshot with a snapshot Id of 17750 is selected as the beginning snapshot, and the snapshot with a snapshot Id of 20301 is selected as the ending snapshot.
12. A list of directory objects is displayed.
13. Specify the directory object pointing to the directory where the export dump file will be stored:
14. Enter value for directory_name: DATA_PUMP_DIR
15. In this example, the directory object DATA_PUMP_DIR is selected.
16. Specify the prefix for name of the export dump file (the .dmp suffix will be automatically appended):
17. Enter value for file_name: awrdata_17750_20301
18. In this example, an export dump file named awrdata_17750_20301 will be created in the directory corresponding to the directory object you specified:
19. Dump file set for SYS.SYS_EXPORT_TABLE_01 is: /orahome/app/oracle/product/10.2.0/rdbms/log/awrdata_17750_20301.dmp Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 08:58:20
20. Depending on the amount of AWR data that needs to be extracted, the AWR extract operation may take a while to complete. Once the dump file is created, you can use Data Pump to transport the file to another system or use regular FTP
Loading AWR data:
• At the SQL prompt, enter:
2. Specify the directory object pointing to the directory where the export dump file is located:
3. Enter value for directory_name: DATA_PUMP_DIR
4. Specify the prefix for name of the export dump file (the .dmp suffix will be automatically appended):
5. Enter value for file_name: awrdata_17750_20301
6. Specify the name of the staging schema where the AWR data will be loaded:
7. Enter value for schema_name: AWR_STAGE
8. Specify the default tablespace for the staging schema:
9. Enter value for default_tablespace: SYSAUX
10. Specify the temporary tablespace for the staging schema:
11. Enter value for temporary_tablespace: TEMP
12. A staging schema named AWR_STAGE will be created where the AWR data will be loaded. After the AWR data is loaded into the AWR_STAGE schema, the data will be transferred into the AWR tables in the SYS schema:
13. Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Completed 113 CONSTRAINT objects in 111 seconds
14. Depending on the amount of AWR data that needs to be loaded, the AWR load operation may take a while to complete. After the AWR data is loaded, the staging schema will be dropped automatically.
• Viewing the AWR data in PE-i™
Figure 1 – Choose the right DBID from the enterprise PMDB
Figure 2 – Display the available loaded snapshots and the unique DBID from the enterprise PMDB
Customers small and large are making business intelligence (BI) and corporate performance management (CPM) top priorities as they scramble to get a handle on putting the right data in the hands of users as corporate strategies shift with the economy. It’s no surprise that the big move towards performance management business intelligence is emerging at many enterprises with the downturn in economy and the growing requirements for server consolidation and virtualization. With the usage of simple Oracle API’s and Enteros PE-i™ enterprises today have the ability of building PMDB (Performance Management database), answer the growing requirements for the need for tools that are user-friendly, integrate lot of different data sources/databases, right now.
April 20-23 2009, Santa Clara Convention Center Santa Clara, CA Enteros participated in the MySQL Conference and Expo. This year the conference hosted close to 2000 attendees. The 7th annual MySQL Conference & Expo, was co-presented by Sun Microsystems and MySQL. The conference brings over 2,000 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. This technical conference brought together all of that creativity, energy, and knowledge together in one place for four very full days.
Close to 200 attendees visited the Enteros exhibit booth over a two day period. Activities at the Enteros booth included a raffle for a Kindle Reader.
Visitors to the booth saw demonstrations of MySQL products including Load2Test for SugarCRM. Enteros Load2Test is an integrated, extensible load-testing framework for scalability validation and root cause analysis prior to production deployment. Load2Test provides advanced support for load test development, execution, and concurrent root cause analysis. It can be applied to custom, composite, and packaged applications such as SugarCRM. Load2Test’s unique approach to scalability validation reduces load test development time by 80%, helps development teams identify exact root causes of load test bottlenecks, and accommodates wide ranges of applications, load levels, and environments. Other Enteros offerings for MySQL: HLC and Grid2GO, were available for visitor review. A new offering Zero-i for MySQL was presented for visitor examination. This is a zero impact SQL performance analyzer for production MySQL databases. Zero-i for MySQL captures executing SQL in real-time, normalized similar SQL statements and record performance analytics related to the executed SQL. These offerings were met enthusiastically by exhibit visitors.
May 21, 2009 CarrAmerica Conference Center 4400 Rosewood Drive, Pleasanton, CA 94588 Enteros will be exhibiting at this conference. 8:00 - 9:00 Registration and Continental Breakfast - Refreshments Served 9:00 - 9:30 General Session and Welcome - Hanan Hit, NoCOUG President For additional information and complete agenda please visit http://nocoug.org/next.html. Attendees can RSVP online Conference attendance is free for NoCOUG members and $50 for non-members.