How can I determine, which (logical) CPUs are used by dbsrv16

One of our clients is experiencing performences problems. Their system administrator claims that the engine is not using all available cores, which we could neither verify nor prove wrong. I'm looking for a method to show the actual cores used bei the engine, in this case dbsrv16.exe.

Any ideas?

sa16 cpu performance

asked 13 Oct '16, 08:41

Reimer Pods
4.5k●38●48●91
accept rate: 11%

edited 13 Oct '16, 09:44

flat view

One Answer:

active answers oldest answers newest answers popular answers

Use sa_cpu_topology() http://dcx.sap.com/index.html#sqla170/en/html/81748db16ce210148df79a5821265ca3.html*loio81748db16ce210148df79a5821265ca3

permanent link

answered 13 Oct '16, 08:51

John Smirnios
11.4k●3●94●154
accept rate: 38%

Thanks john, that was exactly, what I've needed

(13 Oct '16, 09:44) Reimer Pods

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

performance ×273
sa16 ×23
cpu ×4

question asked: 13 Oct '16, 08:41

question was seen: 1,518 times

last updated: 13 Oct '16, 09:44

SAP SQL Anywhere

How can I determine, which (logical) CPUs are used by dbsrv16

Follow this question

Related questions