DBAnalyzer - "Number of logical CPU" weirdness

[markus_doehr2]

A DB Analyzer running on a Solaris x64 system is showing after starting:

*  I  Version information:
*  I  --------------------
*  I  Database Analyzer configuration file dbanalyzer78.cfg, version 7.8.01 Build 018-121-240-252
*  I  Kernel version: Kernel    7.8.01   Build 018-121-240-252
*  I
*  I  System information:
*  I  -------------------
*  I  Number of logical CPUs: 256, physical CPUs: 8, processor type: AMD64 (i86pc)
*  I  Physical memory 65533 MB, virtual memory 211936 MB, memory allocated from instance: 8906 MB
*  I  Operating system: SunOS 5.10 Generic_141415-07
*  I

% /usr/sbin/psrinfo
0       on-line   since 04/25/2010 17:54:35
1       on-line   since 04/25/2010 17:54:42
2       on-line   since 04/25/2010 17:54:44
3       on-line   since 04/25/2010 17:54:46
4       on-line   since 04/25/2010 17:54:48
5       on-line   since 04/25/2010 17:54:50
6       on-line   since 04/25/2010 17:54:52
7       on-line   since 04/25/2010 17:54:54

Where does the database get those 256 CPUs from? MaxDB 7.7 didn't show this behaviour. Not a problem actually, just curious.

Markus

[former_member229109 · Accepted solution]

Hello Markus,

please update with output of the commands "psrinfo -pv" and "uname -a".

Please review the sun docu at

http://www.sunsolarisadmin.com/general/psrinfo-find-number-of-physical-virtual-processors-in-solaris...

Thank you and best regards, Natalia Khlopina

[markus_doehr2 · Accepted solution]

Hi Natalia,

this is not a T-Series server with an UltraSPARC CPU but an AMD machine:

# psrinfo -pv
The physical processor has 4 virtual processors (0 2 4 6)
  x86 (chipid 0x0 AuthenticAMD family 16 model 2 step 3 clock 2311 MHz)
        Quad-Core AMD Opteron(tm) Processor 8356
The physical processor has 4 virtual processors (1 3 5 7)
  x86 (chipid 0x1 AuthenticAMD family 16 model 2 step 3 clock 2311 MHz)
        Quad-Core AMD Opteron(tm) Processor 8356

# uname -a
SunOS xvm006s 5.10 Generic_141415-07 i86pc i386 i86pc

As you see there are only 8 CPUs listed.

Markus

[former_member229109 · Accepted solution]

Hello Markus,

1.

I will check with DB analyzer developer on this question & update the thread after that.

2.

Could you please post the CPU statistics for the database server from /nst06N, if the database connected to the SAP system.

Thank you and best regards, Natalia Khlopina

[markus_doehr2 · Accepted solution]

> 1.

> I will check with DB analyzer developer on this question & update the thread after that.

Thanx!

> 2.

> Could you please post the CPU statistics for the database server from /nst06N, if the database connected to the SAP system.

You mean this:

hour   CPU    CPUavg
15	11	1,01
14	14	0,91
13	13	1,41
12	6	0,63
11	5	0,46
10	5	0,44
09	4	0,40
08	4	0,44
07	4	0,43
06	8	0,70
05	15	0,95
04	13	0,73
03	4	0,65
02	55	4,89
01	52	4,35
00	35	2,80
23	18	2,02
22	9	0,86
21	4	0,41
20	10	0,89
19	42	4,46
18	47	4,73
17	13	1,18
16	9	0,76

Markus

[former_member229109 · Accepted solution]

Hello Markus,

-> could you, please create the SAP message on this question.

-> Please update the message with output of the SQLcommand:

select * from MACHINECONFIGURATION

< Number of logical CPUs is value of 'CPUNUMBER', which you saw in DBAnalyzer protocol.

You could check dbanalyzer78.cfg located in /sapdb/<SID>/db/env >

Thank you and best regards, Natalia Khlopina

[markus_doehr2 · Accepted solution]

Hi Natalia,

sqlcli UGT=> select * from MACHINECONFIGURATION
| CPUNUMBER       | PHYSICALCPUNUMBER          | PHYSICALMEMORYSIZE          | VIRTUALMEMORYSIZE          
|
| --------------- | -------------------------- | --------------------------- | -------------------------- 
|
|             256 |                          8 |                       65533 |                     211936 
|
1 row selected (941 usec)

OSS call created: 993768 / 2010

Thank you!

Markus

[former_member229109 · Accepted solution]

Hello Markus,

you already got information from MAXDB developer in SAP message on posted issue.

Solution & more details: www.sapdb.org/webpts => PTS 1237776

So please close the thread.

Thank you and best regards, Natalia Khlopina

[simon_matter · Accepted solution]

This problem also affects version 7.8.02.21 on Linux. We are running on a HP DL585G7 with 4xAMD 12 core cpus and the following is logged:

2012-02-14 06:36:17 RTEKernel 22: Processors: 5 (logical: 48, cores: 6)

Regards,

Simon