Skip to Content
avatar image
Former Member

Workload Management : User Statement Prioirty

Hi,

We're facing issues with memory and CPU consumption in HANA due to competition for resources between many sessions. I looked to Workload Management for a solution and while it has good features, I'm not sure it fits our scenario. Our high profile jobs run only for a part of the day (night time) during which they should not be disturbed. However, for the rest of the time, Reporting users should not need to be restricted by way of CPU/memory.

Could simply setting User statement priority (value: 9) to the Job DB user do the trick? Theres not much info on how this parameter works.

Any information will be appreciated

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 24, 2017 at 08:56 AM

    The priority is used for a relative ranking of competing resource requests. It's not as if there is a 'priority lane' in the CPU scheduler for higher priority requests.

    Having said that I recommend reviewing the SAP HANA documentation and the relevant SAP notes, e.g. 2222250 - FAQ: SAP HANA Workload Management .

    Other than that, be aware that using the 'user tags' in a question does not work on user names. Neither Florian nor I have been notified about this question - that's just not a feature of the current community platform.

    Add comment
    10|10000 characters needed characters exceeded