Request for SAP hardware recommendations for enterprise SQLA

[Breck_Carter]

Here is a request from an enterprise SQL Anywhere 16.0.0.2614 database customer ( where the adjective "enterpise" applies to both customer and database... whatever you're thinking, think bigger :)...

Are you aware of any official SAP documents that define hardware requirements or guidelines?

Anything that might refer to hardware RAM recommendations, processor speed or count, hard drive IOPS or read/write speed?

Anything we might be able to submit as official/supporting documentation, or performance white papers, in a push for a better hardware platform than what we have currently?

[MCMartin]

SAP SQL Anywhere Hardware Requirements

But I doubt the mentioned mininum requirements will help with your enterprise...

[VolkerBarth]

Well, it contains the inevitable "It depends":

In general, evaluate the hardware configuration to see if it is adequate for the kind of workload being placed on the database server.

[Breck_Carter]

> But I doubt the mentioned mininum requirements will help with your enterprise

You are exactly correct, it does not help at all 🙂

The context is a service provider trying to convince an extremely large, wealthy and conservative client to upgrade hardware to support a rapidly growing workload... with "extremely conservative" being the [cough] primary characteristic.

[Breck_Carter]

> evaluate the hardware configuration to see if it is adequate

The following statement appears in more than one non-SAP source: "SAP itself does not make any hardware recommendations; the responsibility for sizing and detailed hardware configuration lies with the hardware partners."

It is contradicted by SAP's provision of a QUICK SIZER Tool, but that doesn't seem to apply to SQL Anywhere.

[Vlad]

Maybe this old answer can be helpful: https://sqlanywhere-forum.sap.com/questions/12501/how-to-size-a-machine-for-sqlanywhere-with-1000-co...

[Breck_Carter]

When asked to "please provide guidelines" engineers hear "please tell us exactly what we must have" which leads to the correct but completely useless response "it depends"... which is basically what that conversation leads to 🙂