Occasionally, it is a good idea to assess the architecture, configuration and operating environment of your production database deployments in order to effect a high performing implementation and to ensure that you are getting the most out of your database product. The health check for SAP Sybase sever environment service does that. SAP consultants come in and perform the assessment (‘health check’) of a database environment for you and provide a prioritized list of recommendations on everything from server uptimes and maintenance windows to best practices on product investigation, analysis, tuning, or operations. I did some reading of recent Health Check Reports and found three stories of successful adjustments made by customers based on health check recommendations to share with you in this blog post.
SAP Sybase IQ
In one case, a health check of a SAP Sybase IQ installation discovered that not only was the customer running the product on an un-supported out-of-date hardware operating system but the delivery consultant also suggested a new data architecture schema to improve query performance and reduce load times. The schema developed as well as the hardware upgrade dramatically decreased load time by 75% and queries that previously had taken five minutes to return results now return in 45 seconds— and across a larger data set.
SAP Sybase Adaptive Server Enterprise (ASE)
A health check of a production ASE installation recommended that the customer could most efficiently and cost-effectively address its query performance and system availability concerns by upgrading to the latest version of ASE to taking advantage of its partitioning and query processing capabilities. Once the recommendation was implemented, the customer did indeed see performance improvement—query response time was slashed by an average of more than 40 percent.
SAP Sybase Replication Server
A health check engagement was looking for a solution to a suspected performance problem with the Replication Server system. The delivery consultant, while using the Replication Server monitors and counters, was able to isolate the specific database replication connections that were having latency issues due to poorly configured replication and database parameter s. As a result of the Health Check Report recommendations, the customer tuned the replication environment so that they improved their throughput by 30-35% and reduced latency for some transactions by 80%.
Three Dramatic results – yes?
How about you?
Have you made time to perform a health check on your database environment in the past 6 months or since you last did a product upgrade? You may be missing out on an opportunity to be proactive about product and resource utilization.