Hi folks,
For your comparisons:
ADSM: 3.1.2.20
AIX: 4.3.2
HW: SP2 Silver Node (4x332 MHz, 2 GB RAM)
Database striped across 4 x 9.1 SSA 160 disks and mirrored to four more, with
6225 adapter with FWC
Log has the same set up (the logs primary four disks are the databases mirror,
and vise versa)
DB hit rate: >98%
DB size: 4988 MB
Percent used: 16
Buffer Pool Pages: 32 768
Here is some summary data: (expiration starts at 11:00)
Time(s) Objects Objects/ s
*-------------------------------------------------------------------
454 404048 889
412 401168 973
...
420 427680 1018
Our database isn't very big, but these numbers seems high, in comparison. As
the DB grows does performance really drop off?
Cheers Miles
Here is the actual data:
ADSTAR Distributed Storage Manager
Command Line Administrative Interface - Version 3, Release 1, Level 0.7
(C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.
Session established with server UNXR: AIX-RS/6000
Server Version 3, Release 1, Level 2.20
Server date/time: 01/20/00 10:24:55 Last access: 01/20/00 10:23:39
ANS8000I Server command: 'q actlog begind=today-30 search=ANR0812I'
Date/Time Message
--------------------
----------------------------------------------------------
--------
12/30/99 11:07:34 ANR0812I Inventory file expiration process 806
12/30/99 11:07:34 ANR0812I Inventory file expiration process 806
completed:
examined 404048 objects, deleting 5513 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
12/31/99 11:06:52 ANR0812I Inventory file expiration process 909
completed:
examined 401168 objects, deleting 8542 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/01/00 11:06:39 ANR0812I Inventory file expiration process 945
completed:
examined 395631 objects, deleting 7477 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/02/00 11:06:02 ANR0812I Inventory file expiration process 948
completed:
examined 389632 objects, deleting 1468 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/03/00 11:06:10 ANR0812I Inventory file expiration process 951
completed:
examined 390375 objects, deleting 320 backup objects,
563
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/04/00 11:06:25 ANR0812I Inventory file expiration process 976
completed:
examined 391171 objects, deleting 1404 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/05/00 11:07:48 ANR0812I Inventory file expiration process 1037
completed:
examined 391072 objects, deleting 1322 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/06/00 11:06:53 ANR0812I Inventory file expiration process 1070
completed:
examined 400658 objects, deleting 1687 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/07/00 11:06:21 ANR0812I Inventory file expiration process 1105
completed:
examined 403699 objects, deleting 1813 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/08/00 11:07:14 ANR0812I Inventory file expiration process 1132
completed:
examined 406856 objects, deleting 6267 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/09/00 11:06:11 ANR0812I Inventory file expiration process 1142
completed:
examined 401888 objects, deleting 629 backup objects,
0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/10/00 11:06:21 ANR0812I Inventory file expiration process 1176
completed:
examined 403080 objects, deleting 251 backup objects,
0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/11/00 11:06:57 ANR0812I Inventory file expiration process 1235
completed:
examined 405197 objects, deleting 1885 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/12/00 11:06:32 ANR0812I Inventory file expiration process 1265
completed:
examined 405070 objects, deleting 1842 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/13/00 11:06:39 ANR0812I Inventory file expiration process 1338
completed:
examined 411424 objects, deleting 1826 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/14/00 11:06:41 ANR0812I Inventory file expiration process 1385
completed:
examined 412969 objects, deleting 1599 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/15/00 11:12:46 ANR0812I Inventory file expiration process 1425
completed:
examined 425683 objects, deleting 4064 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/16/00 11:06:45 ANR0812I Inventory file expiration process 1435
completed:
examined 428222 objects, deleting 1347 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/17/00 11:09:31 ANR0812I Inventory file expiration process 1474
completed:
examined 429106 objects, deleting 1980 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/18/00 11:07:05 ANR0812I Inventory file expiration process 1508
completed:
examined 429304 objects, deleting 3495 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/19/00 11:07:00 ANR0812I Inventory file expiration process 1631
completed:
examined 427680 objects, deleting 1931 backup
objects, 0
archive objects, 0 DB backup volumes, and 0 recovery
plan
files. 0 errors were encountered.
01/20/00 10:24:55 ANR2017I Administrator QUERY issued command: QUERY
ACTLOG
begind=today-30 search=ANR0812I
ANS8002I Highest return code was 0.
-------------------------------------------------------------------------------------------
----------------
Miles Purdy
Miles Purdy
System Manager, NISA
(204) 984-1602
purdym AT nisa.gc DOT ca
>>> "Medico, Frederic" <FMedico AT KJS DOT COM> 01/20/00 07:49AM >>>
Hi All,
I am running some performance stat's on our Adsm servers and I am interested
to have some numbers from different platform, version, etc ...
( Statistics coming from last 10 days in activity log
Obj/s = Number of expired objects / (End expiration - Begin expiration)
in second
)
Server Os Adsm DB Objects Expiration
Server Os Adsm DB Objects Expiration Obj/s
------ -- ---- Used Avail Avg
Max Min
Max Min
---- ----- ---
--- ---
SP2 HighNode 4 ways Aix 4.3.1.0 3.1.2.42 1,691,328 / 2,432,000
14.55 39.36 0.47
S7A 4 ways Aix 4.3.2.0 3.1.2.40 205,112 / 512,000
13.99 16.81 10.64
I am really surprise that our S7A expire at the same speed as our old High
node (despite the
S7A is also running a development dataware-house)
Any comments or numbers are welcome.
Thanks,
Frederic Medico
SP2 System Engineer
|
