Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Performance issue
Operating Systems AIX Performance issue Post 302623003 by vjm on Friday 13th of April 2012 03:10:37 AM
Old 04-13-2012
Hi,

The interpolicy is minimum. The sybase db and tempdb are on filesystems.
The sybase version is 12.5.2 on both live and new environment.
On P7 disk are from XIV directly attached to server and not from VIO. On old P6 the disk are from DS8k via SVC.

To zaxxon
The P7 lpars has dedicated processors same as P6, the only difference is P6 is 4Ghz and P7 s 3.5Ghz. The EOD process is absolutely same. As per the dba the database is indexed. The old environment is tuned and is on 5.3. As per the IBM documentation aix 6.1 is already tuned.

Yesterday I have disabled the multi threading and the time taken is reduced to 37 min. But its much more than live which is 25 min.

As zxmaus has suggested need to check by creating raw disk for temp db. I will check and revert.

I am posting the latest iostat and vmstat

Code:
#iostat -Dl -T

System configuration: lcpu=3 drives=3 paths=48 vdisks=2

Disks:                     xfers                                read                                write                                  queue                    time
-------------- -------------------------------- ------------------------------------ ------------------------------------ -------------------------------------- ---------
                 %tm    bps   tps  bread  bwrtn   rps    avg    min    max time fail   wps    avg    min    max time fail    avg    min    max   avg   avg  serv
                 act                                    serv   serv   serv outs              serv   serv   serv outs        time   time   time  wqsz  sqsz qfull
hdisk1           0.1 186.9K  22.0  24.3K 162.6K   0.5   3.6    0.4   51.0     0    0  21.5   1.0    0.6   99.5     0    0   0.1    0.0  173.7    0.0   0.0   0.1  12:08:58
hdisk0           0.1 210.9K  24.8   1.1K 209.9K   0.2   4.7    0.4   44.4     0    0  24.6   1.2    0.6  116.2     0    0   1.1    0.0   31.1S   0.0   0.0   0.6  12:08:58
hdisk5           0.0   4.9K   0.8   2.1K   2.7K   0.2   2.0    0.4   60.6     0    0   0.6   1.1    0.6   80.0     0    0   0.0    0.0    3.2    0.0   0.0   0.0  12:08:58

Code:
vmstat -Iwt 1 20

System configuration: lcpu=3 mem=16384MB ent=3.00

   kthr            memory                         page                       faults                 cpu             time
----------- --------------------- ------------------------------------ ------------------ ----------------------- --------
  r   b   p        avm        fre    fi    fo    pi    po    fr     sr    in     sy    cs us sy id wa    pc    ec hr mi se
  0   1   0    1028538     585864     0   801     0     0     0      0   790  59329  5278  5  6 40 50  0.33  11.1 12:09:44
  0   1   0    1028541     585861     0   799     0     0     0      0   786  59183  5321  5  6 39 50  0.32  10.7 12:09:45
  0   1   0    1028542     585860     0   820     0     0     0      0   808  61256  5455  5  6 36 54  0.33  10.9 12:09:46
  0   1   0    1028544     585858     0   798     0     0     0      0   789  61245  5285  4  6 39 51  0.32  10.8 12:09:47
  0   1   0    1028545     585857     0   802     0     0     0      0   793  60842  5307  5  6 41 48  0.34  11.2 12:09:48
  0   1   0    1028546     585856     0   672     0     0     0      0   668  50270  4503  4  5 40 51  0.28   9.2 12:09:49
  1   0   0    1028547     585855     0   694     0     0     0      0   689  53163  4611  4  5 40 51  0.28   9.5 12:09:50
  1   1   0    1028549     585853     0   777     0     0     0      0   772  60547  5146  4  6 37 52  0.33  10.9 12:09:51
  1   0   0    1028550     585852     0   759     0     0     0      0   750  56675  4983  4  5 40 50  0.31  10.2 12:09:52
  0   1   0    1028552     585850     0   777     0     0     0      0   763  58379  4973  4  6 37 53  0.32  10.5 12:09:53
  1   1   0    1028553     585849     0   712     0     0     0      0   705  53933  4822  4  5 36 54  0.29   9.8 12:09:54
  0   1   0    1028554     585848     0   729     0     0     0      0   719  55416  4809  4  5 39 52  0.30  10.0 12:09:55
  0   1   0    1028556     585846     0   849     0     0     0      0   835  61534  5513  5  6 40 49  0.34  11.4 12:09:56
  1   1   0    1028557     585845     0   905     0     0     0      0   893  68578  5922  5  7 38 50  0.37  12.3 12:09:57
  1   1   0    1028561     585841     0   735     0     0     0      0   730  58778  5250  8  6 40 47  0.42  13.8 12:09:58
  1   1   0    1028562     585840     0   939     0     0     0      0   921  12491  6995  4  5 40 52  0.28   9.3 12:09:59
  2   0   0    1028562     585840     0     2     0     0     0      0    21 176114 60259 19 25 57  0  1.42  47.4 12:10:00
  2   0   0    1028562     585840     0     1     0     0     0      0     7 238561 86684 12 34 54  0  1.54  51.4 12:10:01
  3   0   0    1028563     585839     0   204     0     0     0      0   205 214269 70577 10 29 51  9  1.32  43.9 12:10:02
  1   1   0    1028563     585838     1   385     0     0     0      0   295   4683  2530 23  2 56 19  0.75  25.1 12:10:03

Regards,

VJM

---------- Post updated at 12:40 PM ---------- Previous update was at 12:14 PM ----------

The below are the sybase settings.

Code:
[Named Cache:abwslive_data_cache]
	cache size = 750M
	cache status = mixed cache
	cache replacement policy = DEFAULT
	local cache partition number = DEFAULT
[16K I/O Buffer Pool]
	pool size = 100.0000M
	wash size = DEFAULT
	local async prefetch limit = DEFAULT
[4K I/O Buffer Pool]
	pool size = 360.0000M
	wash size = DEFAULT
	local async prefetch limit = DEFAULT
[Named Cache:default data cache]
	cache size = 800M
	cache status = default data cache
	cache replacement policy = DEFAULT
	local cache partition number = DEFAULT
[16K I/O Buffer Pool]
	pool size = 100.0000M
	wash size = DEFAULT
	local async prefetch limit = DEFAULT
[Meta-Data Caches]
	number of open databases = DEFAULT
	number of open objects = 4000
	open object spinlock ratio = DEFAULT
	number of open indexes = 700
	open index hash spinlock ratio = DEFAULT
	open index spinlock ratio = DEFAULT
	partition groups = DEFAULT
	partition spinlock ratio = DEFAULT
[Disk I/O]
	disk i/o structures = 600
	number of large i/o buffers = DEFAULT
	page utilization percent = DEFAULT
	number of devices = 30
	disable disk mirroring = DEFAULT
	allow sql server async i/o = DEFAULT
[SQL Server Administration]
	procedure cache size = 107520
        runnable process search count = 100
        number of aux scan descriptors = 1000
[User Environment]
	number of user connections = 500
	stack size = DEFAULT
	stack guard size = DEFAULT
	permission cache entries = 40
	user log cache size = 2560

Rest is default including network.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Performance issue

Hello all, I just stuck up in an uncertain situation related to network performance... I am trying to access one of my remote client unix machine from a distant location.. The client machine is Ultra-5_10 , with SunOS 5.5.1 The ndd result ( hme1 )shows that the machine is hooked to a... (5 Replies)
Discussion started by: shibz
5 Replies

2. AIX

performance issue

We have a AIX v5.3 on a p5 system with a poor performing Ingres database. We added one CPU to the system to see if this would help. Now there are two CPU's. with sar and topas -P I see good results: CPU usage around 30% with topas I only see good results in the process output screen, the... (1 Reply)
Discussion started by: rein
1 Replies

3. UNIX for Advanced & Expert Users

performance issue

Hi, on a linux server I have the following : vmstat 2 10 procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy id 0 4 0 675236 39836 206060 1617660 3 3 3 6 8 7 1 1 ... (1 Reply)
Discussion started by: big123456
1 Replies

4. Shell Programming and Scripting

performance issue

I want to read a file. is it good to use File I/O or shell script?? which one is the best option? (1 Reply)
Discussion started by: vishwaraj
1 Replies

5. UNIX for Advanced & Expert Users

Performance issue!

In my C program i am using very large file(approx 400MB) to read parts of it frequently. But due to large file the performance of the program goes down very badly. It shows very high I/O usage and I/O wait time. My question is, What are the ways to optimize or tune I/O on linux or how i can get... (10 Replies)
Discussion started by: mavens
10 Replies

6. Solaris

Performance issue

Hi Gurus, I am beginner in solaris and want to know what are the things we need to check for performance monitoring on our solairs OS. for DISK,CPU and MEMORY. Also how we do ipforwarding in slaris Many thanks for your help Pradeep P (4 Replies)
Discussion started by: ppandey21
4 Replies

7. Shell Programming and Scripting

Performance issue or something else?

Hi All, I have the following script which I use in Nagios to check the health of the applications, the problem with it is that the curl part ($TOTAL) does not return anything after running for 2-3 hrs, even though from command line the script runs fine but not from Nagios. There are 17... (1 Reply)
Discussion started by: jacki
1 Replies

8. UNIX for Dummies Questions & Answers

Performance issue

hi I am having a performance issue with the following requirement i have to create a permutation and combination on a set of three files such that each record in each file is picked and the output is redirected in a specific format but it is taking around 70 odd hours to prepare a combination... (7 Replies)
Discussion started by: mad_man12
7 Replies

9. AIX

Performance issue

Hi We have an AIX5.3 server with application which is written in C. We are facing server (lpar) hangs intermediately. If we open new telnet window prompts for user and takes hell of a time to authenticate, not only that if we run ps -aef then also it takes lot of time. surprisingly there is no... (2 Replies)
Discussion started by: powerAIX
2 Replies

10. Red Hat

Performance issue in Linux

IN solaris, for network high-availability we are using IPMP concept, can u tell me in REDHAT LINUX what we are using... also pls share good step to read & understand the that concept... Also performance issue in linux what are step & cmd can u tell me??? (2 Replies)
Discussion started by: tiger09
2 Replies
All times are GMT -4. The time now is 09:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy