DBAppraise™ – News & Events

See us at PUG Challenge in Amsterdam!

Join Adam Backman and Tom Bascom at PUG Challenge in Amsterdam November 3rd & 4th 2011.

Tom Bascom:  Scatter!
Nov 3 10:00 Salon C


Abstract: "Scatter" is a measure of how your data is sprinkled across the disk. In this session you will learn about different ways to measure scatter, why they matter to the performance of your database and what you can do about it if your data is scattered to the winds!

  • Scatter vs Fragmentation -- what's the difference?
  • What is the "scatter factor" shown in DBANALYS telling me?
  • What is "logical scatter"?
  • Why should I care about logical scatter?
  • How can I measure logical scatter?
  • A case study: Using knowledge of logical scatter to improve performance.

Adam Backman:  Buying Database Hardware
Nov 3 12:30 Salon A


Abstract: This presentation will cover the basics of how to buy hardware for your OpenEdge environment. It will include where to invest and where to save. Strategies to get the most for your money without compromising on performance.


Tom Bascom, Adam Backman, Dan Foreman Paul Koufalis:  Performance Tuning Workshop
Nov 3 14:30 Urk & Muiden


Abstract: Hands-on Performance Tuning Workshop

  • Intro - All
  • General Architecture and Disks (storage areas + physical disks) - Adam
  • **BASELINE LAB - no parameters set
  • Safe Starting point - Paul Koufalis
  • **Safe starting point lab
  • Buffer pool - Tom Bascom
  • **Buffer pool lab
  • Latching - Dan Foreman
  • **Latching lab
  • BI File - Tom Bascom
  • **BI Cluster size lab
  • After Imaging/Replication - Paul Koufalis
  • **AI lab
  • Conclusion - ALL

Tom Bascom, Adam Backman, Dan Foreman Paul Koufalis:  Database Administration Birds of a Feather
Nov 3 18:00 Urk & Muiden


Abstract: If the database is healthy, the business can perform well. If this is your credo, this casual discussion round with the database operations, tuning and trouble shooting experts: Adam Backman and Tom Bascom from White-Star Software, Bravepoint's Dan Foreman and Progress Wiz' Paul Koufalis.


Tom Bascom:  Highly Parallel Database Dump & Load
Nov 4 9:45 Salon A


Abstract: Migrating to a new release of OpenEdge doesn't require a dump and load of your database but getting the maximum benefit from new features often does. In this session we will highlight OpenEdge Database features that benefit from a dump and load, cover several alternative approaches to D&L and then develop a specific process for migrating databases in a highly parallelised manner that takes maximum advantage of machine resources. This session will include live demonstrations and take-away code that you can immediately put to use migrating and upgrading your own systems.


Adam Backman:  Top 10 Performance Tips
Nov 4 11:15 Salon A


Abstract: Performance tuning is a process where application response times are recorded and modifications to the environment are made is a systematic manner in an effort to reduce the amount of time it takes to complete system tasks.

A process of moving the bottleneck to the fastest resource.


Tom Bascom:  Using the Progress Profiler
Nov 4 12:30 Urk & Muiden


Abstract: The most confounding performance problems are often application coding issues. These problems can be far more difficult (and expensive) to diagnose and cure than hardware or database & operating system tuning problems. A very powerful, yet little known tool that helps you take the guesswork out of the equation in order to target real problems rather than chasing phantoms and produce dependable results is the Profiler. The Profiler can be used in all versions and on all platforms of Progress from v8.2 forward.

This talk will cover practical usage of the profiler and includes demo code that you can put to work immediately.


Tom Bascom:  The Buzz about Buffer Pools
Nov 4 16:00 Salon A


Abstract: Maybe you've heard of the excitement about the new "alternate buffer pool"? If you're wondering what that is and why it might be important this is the session to come to! Learn how to configure B2 and how to decide which database objects belong in it and how to get the most benefit from this powerful new feature!


Consultingwerk to Offer DBAppraise Service

For Immediate Release
November 9, 2009
Cologne Germany/Nashua NH USA

Simplifying the job of managing and monitoring the world's best business applications has become even easier with today's agreement to bring the DBAppraise remote monitoring and management service to European OpenEdge customers. Consultingwerk Ltd, DBAppraise LLC and White Star Software LLC executives have announced that Consultingwerk will be the exclusive European sales representative for DBAppraise. Mike Fechner, Director of Consultingwerk said, "The hosted DBAppraise service offers our customers the perfect solution for expertly monitoring and managing their OpenEdge databases." "We are very happy that Consultingwerk is representing us." added Tom Bascom, President of DBAppraise, "Consultingwerk's depth of expertise and reputation for excellence and integrity are a perfect fit".

Mr. Bascom added "Everyone on our staff has more than 20 years of experience with Progress OpenEdge which allows us to bring an unprecedented level of expertise to our customers. We never substitute inexperienced call center technicians for the experienced experts that our customers deserve. Should a customer have a problem they are immediately working with a deeply experienced DBA who knows their systems."

"The technical features of the DBAppraise solution, its flexibility and its compact profile that requires no special effort from the customer make it an excellent choice for both centralized and distributed deployments." continues Mr. Bascom. "DBAppraise is unique in that it allows customers to simultaneously increase both breadth of coverage and depth of expertise at a reasonable price. By subscribing to the DBAppraise service our customers eliminate the overhead, cost and time burden associated with recruiting, training and retaining full-time Progress OpenEdge database administrators. At the same time they gain the knowledge and insight of the community's best team of DBA experts."

Customers who already have DBAs on staff but who are looking to expand or who would like a second opinion on important decisions also benefit from DBAppraise. According to Adam Backman, President of White Star, "DBAppraise continuously collects key performance and capacity metrics. The data is available through the DBAppraise Portal, a clean and uncluttered web based interface for analysis and trending. Whether planning an upgrade or analyzing the impact of a new release this data is an incredibly powerful tool."

For real-time performance analysis the DBAppraise Command Center is an OpenEdge GUI for .NET tool for monitoring both Progress 9 and OpenEdge 10 databases. This powerful tool provides a detailed picture of real-time database performance metrics and allows the user to 'drill down' and examine the underlying cause of problems. "The DBAppraise Command Center gives unprecedented insight into runtime problems. Being able to see what tables and indexes a user is actually using, and precisely how heavily they are using them as well as inspecting the program call stack in real-time saves a great deal of debugging time and analysis. This tool has been an invaluable help in focusing our efforts."

In today's information-driven, cost-conscious business environment, your company relies on 24x7x365 access to mission-critical data. Now, more than ever, you need to be certain that your systems are in good hands. Managing and monitoring Progress OpenEdge business applications has never been easier!

About:

Consultingwerk Ltd. is an IT consulting firm with an emphasis on architecture, design and development of future-proof business applications for enterprises and institutions at home and abroad.

DBAppraise, LLC provides remote administration, management and monitoring of Progress OpenEdge databases and applications for customers worldwide.

White Star Software, LLC is the leading provider of independent consulting expertise to the Progress Application development and end-user community, serving the Progress Community since 1985.

For additional information contact:

Consultingwerk Ltd.
Mike Fechner
+49 (0) 221 / 27 609-40
mike.fechner@consultingwerk.de
http://www.consultingwerk.de

DBAppraise, LLC
Tom Bascom
+1 603 396 4886
tom@dbappraise.com
http://dbappraise.com

White Star Software, LLC
Lori Lashway
+1 603 897 0297
lori@wss.com
http://www.wss.com