SAP ASE Modernization Webcast series

SAP are running a series of SAP ASE seminars looking at the  4 key strategic thrusts of development : XOLTP, Cloud & Virtualization, Data Center Operations (Security, Availability, etc.) and integration with SAP HANA.

SAP ASE 16 Feature Overview and Roadmap: May 16, 1500 HRS BST

Accelerate your ASE based data-driven insights to near real-time with HANA: June 21, 1500 HRS BST

ASE Cloud Overview including Subscription Model Support: July 11, 1500 HRS BST

More info and to book

 

SAP Sybase DBAs, have you heard of Asemon? If not, you are missing a trick.

As more and more companies move their SAP Sybase database operations to the cloud, the need for accurate database monitoring is becoming ever more acute. But did you know that one of the best systems on the market, Asemon is completely free? I’ve been using it for years and rate it highly. Here I explain why every SAP DBA needs to know about it.

What is Asemon?

Asemon is a performance monitoring tool for SAP Sybase ASE, SAP Replication Server (SRS) and SAP IQ. It is widely used and has the huge benefit of being a mature and stable product (first delivered in 2004 and actively maintained ever since). And, offered as a GNU General Public License version 2.0, Asemon is completely free to use.

Why is it needed?

As anyone familiar with the excellent Sybase data management suite will know, Sybase did not have a focus on delivering ‘easy to use’ monitoring solutions. Yes, Sybase products did deliver detailed monitoring but getting useful information out could be tricky, requiring DBAs to write their own bespoke, scripted solutions.

A number of third party commercial products developed to fill this gap, delivering a cohesive, graphical overview of server processing. And this is exactly what Asemon does – and does it very, very well.

How is it structured?

Asemon consists of three components:

A “Logging” process for each monitoring component; A “Reporting” process – HTML GUI for Asemon; A “Data Repository” (ASE or IQ) which stores the captured data.

Asemon is a centralised monitoring solution, with a central Reporting server and Repository for each site. The result is centralised monitoring of all your ASE, SRS and IQ servers in one place.

Is it hard to use?

Absolutely not. Simplicity and ease of use are the great benefits of Asemon. Setup is simple with configuration of each capture component completed by a simple configuration file.

The web based reporting GUI is well laid out and highly intuitive:

What we really like about it

As well as its ease of use and general simplicity, there are a number of features which make the DBA’s job so much easier:

  • Comprehensive server metrics monitoring
  • Centralised, web based reporting and monitoring
  • The ability to configure different environments to meet your specific needs – e.g. you might capture pretty much all metrics from a test environment (including executed SQL and associated plans) whereas on a production system you are likely to focus on server metrics
  • Excellent ‘Trends’ feature – this is a very simple feature that’s very well executed. Get an overview of key system metrics over months at a click of a button:
  • Export to Excel – One easy click to export results to Excel
  • Want to alter a report? One click in Asemon takes you directly to the SQL used to generate that screen – so if you want to modify that report or create another based on it simply take the SQL and change as you require (we’re DBAs – we write SQL!)

Are there any drawbacks?

Asemon captures data on the server itself, which has its limitations. Capturing a full range of server metrics and user activity can place a significant load on the monitored ASE server, especially on servers with a high volume of user activity.

Like most traditional monitoring systems, it is also constrained by being entirely IT centric. This is great if a problem began in IT but what if, as is often the case, database performance is being degraded by user decisions? We came across a complementary solution to this several years ago in the form of the excellent iWatch database performance monitoring solution. Unlike Asemon and other traditional monitoring systems, iWatch is non-intrusive – it resides outside of the database and works by capturing every SQL user interaction with the database. This holistic “capture all” approach gives the business an unparalleled picture of what is happening and why – from the viewpoint of the user – with of course no CPU impact. Trends in performance become incredibly easy to identify as well as areas where the most dramatic performance improvements could be made. Comprehensive reporting features ensure that following an incident, iWatch can be used to immediately identify what has changed and why e.g. has user behaviour changed since this morning, yesterday, last week…? These are significant advantages, particularly in complex, distributed environments where critical time can be wasted simply determining which area of expertise within the IT organization can best be brought to bear to resolve a particular issue.

As a result, we now pair Asemon with iWatch for really comprehensive database performance monitoring. The two products complement each other perfectly, addressing the different database performance monitoring problems that face modern businesses.

And both products can be used in conjunction with SAP ASE in the cloud – Asemon can reside locally and iWatch can be used as a BYOL, with plans afoot to make it available on AWS.  

Our first look at SAP ASE public cloud edition

We’ve been using SAP ASE on AWS, want to know what we think? Then read on…

This is a really compelling offering from SAP and AWS, with the promise of superb flexibility and significant reductions in licensing, infrastructure and administration costs.   But is it the right move for everyone?

How easy is it to use?

Our initial test shows great ease of use – the solution is well designed and we were up and running in minutes.  It is currently available in London (EU) and USA (East and West).

We used the m4.4xlarge (‘Vendor Recommended’) server. This is an 8 core 64Gb server. The operating system is Red Hat Enterprise Linux Server 7.4. The installation allowed for configuration of a user database as part of the installation process.  

ASE configuration ‘out of the box’ is very good with the key parameters set to reasonable values with well designed caches (note we’ve not had time yet to review the other sizings so cannot comment at this time whether they are as optimally configured). Configuration changes will be required for many implementations however it seems SAP have provided, at the very least, an excellent starting point.  And let’s not forget that most (if not, all) customers moving to this solution will also upgrade ASE in the process so we’d expect at least some configuration changes.

SAP DBA Cockpit is started automatically. SAP ASE has a rich set of performance metrics but we aren’t that keen on SAP’s GUI interface so we tend to use a third party solution.  Asemon is our prefered solution for customers (note – it’s free and we will be reviewing Asemon online shortly).  For detailed SQL monitoring we recommend iWatch which, sitting outside of the database, has the dual benefit of being able to capture the true origin of problem (whether it’s db centric, or not) whilst not eating up valuable CPU power.

So what are the advantages?

We are all aware of the generic benefits of moving to the cloud – flexibility, scalability, quicker implementations, lower TCO… and cost reduction is certainly a big benefit here. For the 8 core m4.4xlarge instance we used, licensing is $4 an hour (50 cents a core). Infrastructure costs for an M4.4xlarge is priced $1.058 an hour, giving a total hourly cost of $5.058 per hour. This appears to be extremely good value, even more so when you consider that you only pay for the system when it’s switched on.  And of course, this fee also includes the costs of hardware and software ongoing maintenance.

However to my mind, the flexibility of this approach is the biggest benefit. This is a true “pay as you go” model with no caveats. You switch off the system and you stop paying immediately.  Flexibility of usage is incredible – in a matter of minutes the system can be scaled up or down, allowing you to react quickly to your business requirements with no cost penalty.

So should you move?

The answer to this question is of course complex. Yes, on paper SAP ASE on AWS is a very workable financial no-brainer, at least for a one server setup. But cost is just one of the factors that you need consider here: what is your current landscape, what are your current needs, where do you want to be, what are your drivers, what is practical for your organisation? For some SAP ASE users, AWS will be ideal but the reality is that every customer’s needs are different – and requirements have a habit of changing through time…  

What is certain is that this is a very welcome new model from SAP, offering its customers yet another level of business agility.  SAP Licensing is already agile, offering a wealth of benefits e.g. all use outside of production is free, global usage, sub capacity licensing and of course there’s the very flexible ASE Platform Edition model which allows interchange between ASE, IQ and Rep Server, as requirements dictate.  It is worth noting that ASE Platform Edition can also be delivered on AWS under a BYOL model.  

All said, SAP ASE on AWS is well engineered and very well priced and definitely worthy of consideration. However, in my opinion, we need to think of as another feather in the bow of SAP’s already comprehensive suite of licensing options, rather than purely as a replacement. Some customers will move completely to the cloud but I see others, in the short term at least, exploiting the model’s flexibility to the full, using AWS to complement their existing SAP licenses as and when required.

Get in touch if you’d like to chat through your requirements.

 

SAP launch ASE on AWS

SAP has launched extreme transactional processing capabilities on AWS marketplace with new hourly (on demand) pricing for SAP ASE. SAP ASE public cloud edition is the Enterprise Edition plus advanced options including: Security, Encryption, Compression, Partitioning and Workload Optimisation.
We are currently testing out the new service – watch this space for our reviews.

SAP announce ASE public cloud edition

SAP has launched extreme transactional processing capabilities on AWS marketplace with new hourly (on demand) pricing for SAP ASE. SAP ASE public cloud edition is the Enterprise Edition plus advanced options including: Security, Encryption, Compression, Partitioning and Workload Optimisation.

We are currently testing out the new service – watch this space for our reviews.

Contact us to talk through how we could help you move to the cloud.

 

Sybase Users, what are you waiting for?

Recent research commissioned by SAP among leading IT decision makers has confirmed what we all know to be true: firstly, the majority of organisations aren’t getting the most out of their data and secondly, data landscapes are so fragmented and complex that they limit business agility. Source: Data 2020: State of Big Data Study

No shocks here but, as more and more Sybase users are discovering, it doesn’t have to be this way.

Those organisations who choose to convert Sybase estates to SAP (or indeed migrate from any other provider) access a level of technological flexibility and business agility that previously they could have only dreamed of. The game changer? The option to convert all licenses to SAP’s revolutionary Adaptive Server Platform Edition.

What makes Adaptive Server Platform Edition ground-breaking is its deployment flexibility. Using Platform Edition businesses can interchange deployment between cores of SAP ASE, SAP IQ or SAP Replication Server whenever required, giving the flexibility to re-architect landscapes in response to market conditions, peak periods or new business demands – without the need to invest in new licenses each time.  Yes, you read this correctly, Platform Edition is, in essence, three different SAP Sybase data management technologies in one. This level of agility is unprecedented within the data management market. Highly efficient, Platform Edition eliminates technological waste, ensuring that every license within an estate can be used to the full.

Lower Future Costs and TCO

However, flexibility and increased business agility are not the only features that set Platform Edition apart. The license model includes as standard 15 otherwise chargeable specialist options, significantly reducing future TCO. Standard options are:

  • SAP ASE – Partition, Encryption, Compression, High Availability, Security and Directory Services, Tivoli Storage Manager.
  • SAP IQ – Advanced Security, In-Database analytics, Unstructured Data Access, Very Large Database Management.
  • SAP RS – Replication to HANA and Hadoop, Change Data Capture, Real-time loading, Advanced Services, Data Assurance.

Extended Usage Rights to support Business Agility

What is also impressive is that this technological agility is mirrored by licensing flexibility. The business landscape is ever-changing and as a result, SAP offers its customers generous Extended Rights. As standard, non-production use comes at no additional cost so that “Full-Use” licenses are deployed 100% for operational usage. Licenses may also be used globally on any machine or any current or future supported platform, and cloud deployment is straightforward. As virtualisation moves up the business agenda with urgency, the inclusion of sub capacity rights allowing virtualisation of entire Sybase estates is yet another extremely valuable benefit.

As those customers who have already converted will testify, the move unlocks the massive potential of SAP Sybase technologies to fully exploit Big Data – with the superior speed of IQ data warehousing delivering powerful on-demand analytics capabilities across the entire organisation.

The end result is a simplified data environment that is efficient, agile and cost-effective.

As a leading UK SAP Sybase consultancy and reseller, J2 are experienced in helping Sybase customer evaluate the benefits of converting their estates to SAP.  Get in touch if you would like to discuss how your organisation could benefit from a conversion.   

 

Use SAP’s Advanced SQL Migration tool with J2

The SAP® Advanced SQL Migration tool has been developed to meet one one of the key challenges of database application migration, SQL code Conversion. SAP® Advanced SQL Migration tool automatically converts SQL queries, stored procedures, and database schema to reduce the effort, complexity and risk of migrating your custom applications to SAP database platforms. More

Although it is not available for direct use by customers, it is available through SAP partners such as J2.  Get in touch to find out how it could be used to help your conversion.