on 12-01-2010 4:21 PM
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
Hello Markus,
please update with output of the commands "psrinfo -pv" and "uname -a".
Please review the sun docu at
Thank you and best regards, Natalia Khlopina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
> 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
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
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
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
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.