Solved: High CPU Utilization in Sybase

More details, please.

What brand and version of Unix? (Sun Solaris, HP HPUX, DEC OSF, etc.)
What kind and version of Sybase Server? (ASE, ASA, ASIQ, Open Server, etc.)

If an ASE server, have you run any sp_sysmons? You might post the output here
for review.

Cheers,
-bret

gyans

ASKER

SunSolaris 5.9
ASE 12.5.2
netstat:
*************** netstat_i_cmd: Started at Fri Feb 3 09:20:00 EST 2006 ***************

netstat column info:
Ierrs - # input errors on this interface since system was booted. Should be
extremely low (under .025%)
Oerrs - # output errors on this interface since system was booted. Should be
extremely low (under .025%)
Collis- # collisions detected since boot. Could be as high as 10%.
-------------------------------------------------------------------------------

Name Mtu Net/Dest Address Ipkts Ierrs Opkts Oerrs Collis Queue
lo0 8232 loopback localhost 54977127 0 54977127 0 0 0
ge0 1500 ccgdop-msw-01.ceg.corp.net ccgdop-msw-01.ceg.corp.net 2538163918 21882 1332094827 0 0 0
hme0 1500 ccgdop-msw-01-b.ceg.corp.net ccgdop-msw-01-b.ceg.corp.net 2490365125 44 17976576 0 0 0

*****************************
*************** ps_cmd: Started at Fri Feb 3 09:20:01 EST 2006 ***************

STAT Column: lots of P (waiting for pagein) and D waiting for diskio) could
mean disk performance or memory usage could be overloaded
-------------------------------------------------------------------------------

USER PID %CPU %MEM SZ RSS TT S START TIME COMMAND
sybase 3837 3.4 35.814460721434184 ? O Apr 12 50369:04 /home/sybase/ase1252/ASE-12_5/bin/dataserver
-ONLINE:2,0,0x617d3a8d, a
sybase 3835 2.2 35.814480561436904 ? S Apr 12 50154:03 /home/sybase/ase1252/ASE-12_5/bin/dataserver
-d/u01/d_master -e/home/s
sybase 3836 1.9 35.814460721434200 ? S Apr 12 50943:09 /home/sybase/ase1252/ASE-12_5/bin/dataserver
-ONLINE:1,0,0x617d3a8d, a
sybase 3838 1.7 35.814468561435088 ? S Apr 12 49900:12 /home/sybase/ase1252/ASE-12_5/bin/dataserver
-ONLINE:3,0,0x617d3a8d, a
root 3 0.6 0.0 0 0 ? S Apr 12 8034:00 fsflush
root 837 0.3 0.83911231760 ? S Apr 12 1962:57 /opt/perf/bin/scopeux
sybase 15457 0.1 0.1 2352 1432 pts/3 S Feb 01 11:19 top
sybase 23640 0.1 0.1 1096 880 ? S 09:20:00 0:00 sh -c /home/sybase/admin/perfbin/runmon.sh 2>/dev/nu
ll
sybase 23643 0.1 0.1 1888 1432 ? S 09:20:00 0:00 /bin/ksh /home/sybase/admin/perfbin/runmon.sh
root 23669 0.1 0.1 1128 744 ? O 09:20:01 0:00 /usr/ucb/ps -auxw
root 474 0.1 0.1 6232 3680 ? S Apr 12 453:26 /usr/lib/autofs/automountd
sybase 23663 0.1 0.1 1888 1432 ? S 09:20:01 0:00 /bin/ksh ps_cmd
root 12942 0.1 0.216752 6232 ? S Apr 29 99:31 opcmona
root 14 0.0 0.2 9056 6480 ? S Apr 12 16:03 vxconfigd -x syslog -m boot
root 16551 0.0 0.77892828168 ? S May 03 306:49 /usr/java/bin/java -Dviper.fifo.path=/var/run/smc89
8/boot.fifo -Xmx128
root 325 0.0 0.56700018536 ? S Apr 12 47:22 /opt/VRTSob/bin/vxsvc -r /opt/VRTSob/config/Registry
-e
root 0 0.0 0.0 0 0 ? T Apr 12 0:01 sched
root 1 0.0 0.0 1288 456 ? S Apr 12 70:46 /etc/init -
root 2 0.0 0.0 0 0 ? S Apr 12 0:00 pageout
root 61 0.0 0.1 2408 1456 ? S Apr 12 0:00 /usr/lib/sysevent/syseventd
root 67 0.0 0.1 2056 776 ? S Apr 12 0:00 /usr/lib/sysevent/syseventconfd
root 130 0.0 0.1 2944 1808 ? S Apr 12 0:00 devfsadmd
root 137 0.0 0.1 2208 1264 ? S Apr 12 0:00 /sbin/vxesd
root 249 0.0 0.1 3296 2416 ? S Apr 12 0:01 /usr/lib/picl/picld
root 332 0.0 0.1 2296 1376 ? S Apr 12 0:46 /usr/lib/inet/in.mpathd -a
root 364 0.0 0.1 9240 3944 ? S Apr 12 16:41 /opt/OV/dce/bin_exe/dced -b -S
root 413 0.0 0.1 2360 1536 ? S Apr 12 0:12 /usr/sbin/rpcbind
root 416 0.0 0.1 2456 1536 ? S Apr 12 1:12 /usr/sbin/keyserv
root 418 0.0 0.1 3360 2328 ? S Apr 12 1:07 /usr/sbin/nis_cachemgr
root 441 0.0 0.1 2480 1784 ? S Apr 12 0:01 /usr/sbin/inetd -s
root 463 0.0 0.1 2216 1512 ? S Apr 12 0:00 /usr/lib/nfs/lockd
daemon 464 0.0 0.1 2528 1936 ? S Apr 12 0:00 /usr/lib/nfs/statd
root 479 0.0 0.1 3360 1456 ? S Apr 12 1:27 /usr/sbin/sshd
root 491 0.0 0.1 4304 2456 ? S Apr 12 2:21 /usr/sbin/syslogd -t
root 495 0.0 0.1 2744 1840 ? S Apr 12 2:15 /usr/sbin/cron
root 511 0.0 0.2 5344 4552 ? S Apr 12 18:24 /usr/sbin/nscd -S passwd,yes
root 526 0.0 0.1 1080 760 ? S Apr 12 1:55 /usr/lib/utmpd
root 541 0.0 0.1 4448 1832 ? S Apr 12 1:02 /usr/lib/sendmail -bd -q15m
smmsp 542 0.0 0.1 4416 1240 ? S Apr 12 0:11 /usr/lib/sendmail -Ac -q15m
root 561 0.0 0.1 3096 1496 ? S Apr 12 0:00 /usr/sbin/mdmonitord
root 567 0.0 0.0 784 536 ? S Apr 12 0:00 /sbin/sh - /usr/lib/vxvm/bin/vxrelocd root
root 569 0.0 0.0 368 120 ? S Apr 12 0:00 /sbin/sh - /usr/lib/vxvm/bin/vxconfigbackupd
root 612 0.0 0.0 784 328 ? S Apr 12 0:00 /sbin/sh - /usr/lib/vxvm/bin/vxrelocd root
root 613 0.0 0.1 1864 1352 ? S Apr 12 0:00 vxnotify -f -w 15
root 666 0.0 0.0 368 112 ? S Apr 12 0:00 /sbin/sh - /usr/lib/vxvm/bin/vxconfigbackupd
root 667 0.0 0.1 1864 1352 ? S Apr 12 0:00 vxnotify
root 829 0.0 0.1 2128 1608 ? S Apr 12 0:00 /opt/perf/bin/ttd
root 836 0.0 0.1 1872 1024 ? S Apr 12 0:14 /opt/perf/bin/midaemon
root 854 0.0 0.110512 4352 ? S Apr 12 0:00 /opt/perf/bin/perflbd
root 863 0.0 0.1 2216 1608 ? S Apr 12 0:29 /usr/lib/snmp/snmpdx -y -c /etc/snmp/conf -f 0
root 867 0.0 0.1 2968 2432 ? S Apr 12 0:00 /usr/sbin/vold
root 870 0.0 0.1 2784 2448 ? S Apr 12 115:23 mibiisa -r -p 32812
root 912 0.0 0.1 1808 1264 ? S Apr 12 0:00 /usr/lib/saf/sac -t 300
root 915 0.0 0.1 1816 1312 ? S Apr 12 0:00 /usr/lib/saf/ttymon
root 1053 0.0 0.31896812376 ? S Apr 12 26:10 /opt/perf/bin/rep_server -t SCOPE /var/opt/perf/data
files/logglob
root 1054 0.0 0.210648 4848 ? S Apr 12 4:00 /opt/perf/bin/agdbserver -t alarmgen /var/opt/perf/d
atafiles/
root 1055 0.0 0.73344827800 ? S Apr 12 6:12 /opt/perf/bin/alarmgen -svr 1054 -t alarmgen /var/op
t/perf/datafiles//
root 1071 0.0 0.1 1816 1208 console S Apr 12 0:00 /usr/lib/saf/ttymon -g -h -p ccgdyp-msw-01 console l
ogin: -T xterms -
sybase 3822 0.0 0.1 1096 832 ? S Apr 12 0:00 sh -c /home/sybase/ase1252/ASE-12_5/bin/backupserver
-e/home/sybase/as
sybase 3823 0.0 0.41413613824 ? S Apr 12 558:30 /home/sybase/ase1252/ASE-12_5/bin/backupserver -e/h
ome/sybase/ase1252/
sybase 3833 0.0 0.1 1096 832 ? S Apr 12 0:00 /bin/sh ./RUN_sybccgp
root 4842 0.0 0.1 6008 2280 ? S Jan 31 0:00 /usr/sbin/sshd
sybase 4845 0.0 0.1 6096 2464 ? S Jan 31 0:06 /usr/sbin/sshd
sybase 4847 0.0 0.1 1496 1312 pts/3 S Jan 31 0:00 -csh
sybase 4850 0.0 0.1 1904 1440 pts/3 S Jan 31 0:00 ksh
root 5389 0.0 0.1 3640 2520 ? S Nov 29 10:32 /usr/bin/perl /CEG/scripts/MON/CEG_monitor
root 5391 0.0 0.1 3648 2232 ? S Nov 29 0:01 /usr/bin/perl /CEG/scripts/MON/check_messages
root 8138 0.0 0.1 2136 1320 ? S Jul 15 0:09 /usr/lib/inet/xntpd
root 12935 0.0 0.211928 6008 ? S Apr 29 12:09 opcctla -start
root 12937 0.0 0.211056 4648 ? S Apr 29 0:06 opcmsga
root 12938 0.0 0.1 6176 2768 ? S Apr 29 0:02 llbserver
root 12940 0.0 0.110752 3480 ? S Apr 29 19:42 opcacta
root 12941 0.0 0.110504 3960 ? S Apr 29 1:25 opcle
root 12943 0.0 0.110920 3808 ? S Apr 29 0:35 opcmsgi
root 12944 0.0 0.1 1152 888 ? S Apr 29 0:00 /bin/sh /opt/OV/bin/OvSvcDiscAgent.sh
root 12953 0.0 0.96385634056 ? S Apr 29 49:34 java -cp /var/opt/OV/bin/instrumentation:OvSvcDisc.j
ar:OvBbcHttp.jar:x
sybase 17539 0.0 0.1 1744 1608 ? S Apr 13 0:16 /home/sybase/ase1252/ASE-12_5/bin/sybmultbuf 20 99 1
02 /home/sybase/as
sybase 17540 0.0 0.1 3328 3120 ? S Apr 13 0:20 /home/sybase/ase1252/ASE-12_5/bin/sybmultbuf 20 99 1
02 /home/sybase/as
root 18857 0.0 0.1 1920 1456 ? S 08:50:01 0:00 /bin/ksh /var/opt/OV/bin/instrumentation/monitor_cpu
.sh
root 18872 0.0 0.1 1064 904 ? S 08:50:02 0:00 sar -uq 60 30
root 18873 0.0 0.1 1376 1096 ? S 08:50:02 0:00 /usr/lib/sa/sadc 60 31
root 19889 0.0 0.1 1920 1456 ? S 08:55:03 0:00 /bin/ksh /var/opt/OV/bin/instrumentation/monitor_cpu
.sh
root 19904 0.0 0.1 1112 952 ? S 08:55:03 0:00 sar -uq 60 30
root 19905 0.0 0.1 1456 1176 ? S 08:55:03 0:00 /usr/lib/sa/sadc 60 31
root 20162 0.0 0.1 6192 2040 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 20164 0.0 0.1 6128 1776 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 20166 0.0 0.1 1680 1280 pts/4 S Jan 04 0:00 -csh
root 21005 0.0 0.1 1920 1456 ? S 09:00:01 0:00 /bin/ksh /var/opt/OV/bin/instrumentation/monitor_cpu
.sh
root 21020 0.0 0.1 1112 952 ? S 09:00:01 0:00 sar -uq 60 30
root 21021 0.0 0.1 1456 1176 ? S 09:00:01 0:00 /usr/lib/sa/sadc 60 31
root 21792 0.0 0.1 1920 1456 ? S 09:05:02 0:00 /bin/ksh /var/opt/OV/bin/instrumentation/monitor_cpu
.sh
root 21811 0.0 0.1 1064 904 ? S 09:05:02 0:00 sar -uq 60 30
root 21813 0.0 0.1 1376 1096 ? S 09:05:02 0:00 /usr/lib/sa/sadc 60 31
root 22346 0.0 0.1 1920 1456 ? S 09:10:03 0:00 /bin/ksh /var/opt/OV/bin/instrumentation/monitor_cpu
.sh
root 22361 0.0 0.1 1064 904 ? S 09:10:03 0:00 sar -uq 60 30
root 22362 0.0 0.1 1376 1096 ? S 09:10:03 0:00 /usr/lib/sa/sadc 60 31
root 23291 0.0 0.1 1920 1456 ? S 09:15:01 0:00 /bin/ksh /var/opt/OV/bin/instrumentation/monitor_cpu
.sh
root 23324 0.0 0.1 1064 904 ? S 09:15:01 0:00 sar -uq 60 30
root 23326 0.0 0.1 1376 1096 ? S 09:15:01 0:00 /usr/lib/sa/sadc 60 31
root 25357 0.0 0.1 6192 2040 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 25359 0.0 0.1 6128 1776 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 25361 0.0 0.1 1680 1280 pts/5 S Jan 04 0:00 -csh
root 25729 0.0 0.1 6192 2040 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 25738 0.0 0.1 6128 1776 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 25740 0.0 0.1 1680 1280 pts/6 S Jan 04 0:00 -csh
root 26492 0.0 0.1 6192 2040 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 26494 0.0 0.1 6128 1776 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 26496 0.0 0.1 1608 1128 pts/7 S Jan 04 0:00 -csh
root 27110 0.0 0.1 6192 2040 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 27112 0.0 0.1 6128 1776 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 27114 0.0 0.1 1680 1280 pts/8 S Jan 04 0:00 -csh
root 27519 0.0 0.1 6192 2040 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 27521 0.0 0.1 6128 1776 ? S Jan 04 0:00 /usr/sbin/sshd
procmon 27523 0.0 0.1 1680 1280 pts/9 S Jan 04 0:00 -csh
*************** ps_cmd: Ended at Fri Feb 3 09:20:01 EST 2006 ***************

This is what I have so far ,thanks,Vinai

Joe Woodhouse

Some general comments first:

1) High CPU isn't a bad thing. It means your hardware is correctly sized for your current load and you are making good use of what you paid for! 8-> 100% is bad as that implies waits, but there's nothing to be upset by if your box is running constantly around 80%.

2) Sybase ASE CPU utilisation is not the same as host CPU utilisation. A lot of what ASE does is waiting (for a lock, for disk, for network) and because that waiting is done via spinlocks ("sit and spin" while waiting), that will look like work to host-level utilities like ps, vmstat and so on. This is why bret asked for some sp_sysmon results, because we don't know how busy ASE is without it.

For example, suppose vmstat tells you dataserver processes are collectively using 90% of CPU. But sp_sysmon might show average engine utilisation is just 50%. This means only 50% of the time a dataserver is running on a physical CPU is actual work being done. In this scenario, ASE is only using 50% x 90% = 45% of the total host CPU.

It's very common to see the host report high utilisation while ASE says it isn't doing much. ASE doesn't count waiting - the host does.

3) In the output you posted, the four dataserver processes are collectively using only 9.2% of the CPU! And because that is a host-level statistic, that *includes* all the waits for locks, disk and network. ASE is almost idle here. This is not a box that is running anywhere near capacity. All of the processes you show in your ps snapshot don't even sum to 20% CPU utilisation...

So, as bret says, more information please! Can we get some Solaris results like top and vmstat when things are busy, as well as (say) a 5 minute sp_sysmon (run: sp_sysmon "00:05:00" ).

So in summary, it is normal and expected to see CPU high as reported by the host... but even that isn't happening here. 8->

gyans

ASKER

Thank you for explaining.

I am waiting for the CPU to go high again and I will post the requested info .

It usually happens early morning .

thank you.

gyans

ASKER

TOP command when CPU was very high :

100% average CPU utilization over the last 30-minute period.
Average CPU Run Queue over this period was 2.0

load averages: 4.21, 4.23, 3.80 07:55:07
112 processes: 107 sleeping, 1 running, 4 on cpu CPU states: 0.0% idle, 97.7% user, 2.2% kernel, 0.0% iowait, 0.0% swap
Memory: 4096M real, 1068M free, 1769M swap in use, 5006M swap free

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
3838 sybase 161 0 0 1413M 1401M cpu/0 845.0H 24.71% dataserver
3835 sybase 118 0 0 1414M 1403M cpu/3 848.4H 24.60% dataserver
3836 sybase 110 0 0 1412M 1401M run 863.5H 24.28% dataserver
3837 sybase 111 0 0 1412M 1401M cpu/1 853.7H 24.23% dataserver
22134 root 1 59 0 2256K 1280K cpu/2 0:00 0.22% top
837 root 1 59 0 39M 32M sleep 33.5H 0.19% scopeux
22135 root 1 59 0 1920K 1464K sleep 0:00 0.08% monitor_cpu.sh
16551 root 25 29 10 77M 28M sleep 313:28 0.05% java
364 root 28 59 0 9240K 3944K sleep 17:01 0.03% dced
22151 root 1 59 0 1376K 1104K sleep 0:00 0.03% sadc
17555 root 1 59 0 1920K 1456K sleep 0:00 0.02% monitor_cpu.sh
870 root 7 59 0 2784K 2448K sleep 117:44 0.01% mibiisa
1053 root 10 59 0 19M 12M sleep 26:30 0.01% rep_server
12935 root 50 59 0 12M 5680K sleep 12:22 0.01% opcctla
20913 root 1 59 0 1376K 1104K sleep 0:00 0.01% sadc

************************

VMSTAT command during that time:
vmstat column info:
b - number of processes blocked. High number = disk throughput problems
w - number of processes swapped out. Nonzero=swapping. Serious memory shortage.
si - swap in
so - swap out
pi - page in
po - page outs. # 1k pgs/sec paged out. >0 for several intervals=bad performance
-------------------------------------------------------------------------------

kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m4 m7 in sy cs us sy id
0 0 0 5342032 1287272 0 0 1330 1 1 0 0 0 0 0 0 437 292 368 11 6 83
0 0 0 5125160 1101304 0 0 11 2 0 0 0 0 0 0 0 1297 2850 930 98 2 0
0 0 0 5125160 1101304 0 0 35 0 0 0 0 0 0 0 0 1239 1008 838 99 1 0
0 0 0 5125160 1101304 0 0 13 0 0 0 0 0 0 0 0 1333 1026 876 99 1 0
0 0 0 5125160 1101304 0 0 18 0 0 0 0 0 0 0 0 1264 938 838 99 1 0
0 0 0 5125168 1101312 0 0 70 0 0 0 0 0 0 0 0 1241 716 812 97 3 0
0 0 0 5125224 1101368 0 0 27 0 0 0 0 0 0 0 0 1231 917 822 99 1 0
0 0 0 5125224 1101368 0 0 78 2 0 0 0 0 0 0 0 1523 706 849 99 1 0
0 0 0 5124968 1101048 0 0 11 0 0 0 0 0 0 0 0 1243 994 846 99 1 0
0 0 0 5125160 1101304 0 0 27 0 0 0 0 0 0 0 0 1235 659 802 99 1 0
0 0 0 5125160 1101304 0 0 29 0 0 0 0 0 0 0 0 1256 902 850 99 1 0
0 0 0 5125160 1101304 0 0 32 0 0 0 0 0 0 0 0 1176 2380 848 97 3 0
0 0 0 5125160 1101304 0 0 11 0 0 0 0 0 0 0 0 1273 1525 849 98 2 0
0 0 0 5125160 1101304 0 0 40 2 0 0 0 0 0 0 0 1265 1303 859 99 1 0
0 0 0 5125160 1101304 0 0 34 0 0 0 0 0 0 0 0 1246 1114 855 98 2 0
0 0 0 5125160 1101304 0 0 24 0 0 0 0 0 0 0 0 1280 688 844 99 1 0
0 0 0 5125160 1101304 0 0 27 0 0 0 0 0 0 0 0 1370 1583 875 99 1 0
0 0 0 5125160 1101304 0 0 27 0 0 0 0 0 0 0 0 1258 1000 839 97 3 0
0 0 0 5125160 1101304 0 0 5 0 0 0 0 0 0 0 0 1212 705 804 99 1 0
kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m4 m7 in sy cs us sy id
0 0 0 5125152 1101296 0 0 37 2 0 0 0 0 0 0 0 1400 766 853 99 1 0
0 0 0 5125144 1101288 0 0 22 0 0 0 0 0 0 0 0 1246 1101 840 99 1 0
0 0 0 5125144 1101288 0 0 22 0 0 0 0 0 0 0 0 1246 664 822 99 1 0
0 0 0 5125144 1101296 0 0 21 0 0 0 0 0 0 0 0 1190 736 841 99 1 0
0 0 0 5125112 1101264 0 0 11 0 0 0 0 0 0 0 0 1165 2540 868 97 3 0
0 0 0 5125152 1101304 0 0 29 0 0 0 0 0 0 0 0 1280 1472 863 99 1 0
0 0 0 5125056 1101248 0 0 104 2 0 0 0 0 0 0 0 1277 1190 864 99 1 0
0 0 0 5125144 1101296 0 0 19 0 0 0 0 0 0 0 0 1259 1449 863 98 2 0
0 0 0 5125144 1101296 0 0 21 0 0 0 0 0 0 0 0 1260 680 826 99 1 0
0 0 0 5125144 1101296 0 0 27 0 0 0 0 0 0 0 0 1332 679 844 99 1 0
0 0 0 5125144 1101296 0 0 16 0 0 0 0 0 0 0 0 1224 765 818 97 3 0
0 0 0 5125144 1101296 0 0 22 0 0 0 0 0 0 0 0 1239 726 828 99 1 0
0 0 0 5125208 1101360 0 0 19 2 0 0 0 0 0 0 0 1376 676 817 99 1 0
0 0 0 5125152 1101304 0 0 3 0 0 0 0 0 0 0 0 1171 1114 833 98 2 0
0 0 0 5125144 1101296 0 0 35 0 0 0 0 0 0 0 0 1244 797 826 99 1 0
0 0 0 5125144 1101296 0 0 22 0 0 0 0 0 0 0 0 1234 680 814 100 0 0
0 0 0 5123544 1100104 0 0 21 0 0 0 0 0 0 0 0 1286 4154 967 94 6 0
4 0 0 5121880 1098912 0 0 14 0 0 0 0 0 0 0 0 1285 3485 928 96 4 0
4 0 0 5122928 1099912 0 0 29 2 0 0 0 0 0 0 0 1243 8914 997 90 10 0
kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m4 m7 in sy cs us sy id
0 0 0 5125112 1101176 0 0 34 0 0 0 0 0 0 0 0 1219 2697 840 98 2 0
0 0 0 5124352 1101112 0 0 16 0 0 0 0 0 0 0 0 1243 838 843 99 1 0
2 0 0 5118888 1098928 0 0 227 0 0 0 0 2 0 1 1 1797 6278 1574 93 6 0
0 0 0 5119152 1098448 0 0 40 0 0 0 0 2 0 1 1 1454 3013 1167 95 5 0
0 0 0 5119640 1098256 0 0 13 0 0 0 0 2 0 1 1 1338 932 849 99 1 0
0 0 0 5119896 1098336 0 0 56 2 0 0 0 2 0 1 1 1579 4091 1020 96 4 0
0 0 0 5120136 1098456 0 0 89 0 0 0 0 2 0 1 1 1306 1249 926 99 1 0
0 0 0 5122088 1099536 0 0 14 0 0 0 0 2 0 1 1 1270 932 881 99 1 0
0 0 0 5125024 1101160 0 0 62 0 0 0 0 2 0 1 1 1286 957 962 99 1 0
0 0 0 5124984 1101120 0 0 26 2 2 0 0 2 0 1 1 1268 2567 884 96 4 0
0 0 0 5125048 1101184 0 0 11 0 0 0 0 2 0 1 1 1289 1617 885 99 1 0
0 0 0 5125088 1101224 0 0 2 2 0 0 0 2 0 1 1 1215 1066 838 99 1 0
0 0 0 5125088 1101224 0 0 0 0 0 0 0 2 0 1 1 1176 941 800 99 1 0
0 0 0 5125024 1101160 0 0 2 0 0 0 0 2 0 1 1 1161 800 830 99 1 0
1 0 0 5124648 1100952 0 0 0 2 2 0 0 2 0 1 1 1236 1513 869 98 2 0
1 0 0 5124680 1101000 0 0 24 0 0 0 0 2 0 1 1 1134 3646 913 94 5 1
0 0 0 5125160 1101296 0 0 37 0 0 0 0 2 0 1 1 1175 1085 899 99 1 0
0 0 0 5125248 1101384 0 0 30 2 2 0 0 2 0 1 1 1525 994 1008 99 1 0
0 0 0 5125232 1101368 0 0 2 0 0 0 0 2 0 1 1 1363 1453 1131 98 2 0
kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m4 m7 in sy cs us sy id
0 0 0 5125232 1101368 0 0 2 0 0 0 0 2 0 1 1 1249 671 835 99 1 0
0 0 0 5125232 1101368 0 0 0 0 0 0 0 2 0 1 1 1193 870 833 99 1 0
0 0 0 5124752 1101136 0 0 126 2 2 0 0 2 0 1 1 1329 2841 1002 97 3 0
0 0 0 5124640 1101024 0 0 57 6 6 0 0 2 0 1 1 1578 2890 1058 97 3 0
0 0 0 5124464 1100824 0 0 30 2 0 0 0 2 0 1 1 1303 1672 924 98 2 0
1 0 0 5123384 1099752 0 0 37 0 0 0 0 2 0 1 1 2894 3097 3311 86 13 0
1 0 0 5121792 1098240 0 0 35 0 0 0 0 2 0 1 1 3655 2634 4321 82 18 0
0 0 0 5121784 1098232 0 0 18 0 0 0 0 2 0 1 1 1534 1009 961 99 1 0
1 0 0 5121760 1098208 0 0 18 0 0 0 0 2 0 1 1 2754 2365 3302 84 16 0
0 0 0 5121736 1098184 0 0 14 0 0 0 0 2 0 1 1 1380 913 1191 98 2 0
0 0 0 5121736 1098184 0 0 27 2 0 0 0 2 0 1 1 1472 858 878 98 2 0
0 0 0 5122280 1098712 0 0 13 0 0 0 0 2 0 1 1 1168 993 846 99 1 0
0 0 0 5125400 1101568 0 0 26 0 0 0 0 2 0 1 1 1229 704 832 99 1 0
0 0 0 5125456 1101624 0 0 18 0 0 0 0 2 0 1 1 1161 739 826 99 1 0
0 0 0 5125344 1101512 0 0 38 0 0 0 0 2 0 1 1 1244 2589 855 96 4 0
0 0 0 5125344 1101512 0 0 16 0 0 0 0 2 0 1 1 1262 1552 846 98 2 0
0 0 0 5125344 1101512 0 0 30 2 0 0 0 2 0 1 1 1315 940 837 99 1 0
0 0 0 5125344 1101512 0 0 13 0 0 0 0 2 0 1 1 1124 1132 859 99 1 0
0 0 0 5125344 1101512 0 0 30 0 0 0 0 2 0 1 1 1159 672 808 99 1 0
kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m4 m7 in sy cs us sy id
0 0 0 5125344 1101512 0 0 22 0 0 0 0 2 0 1 1 1218 659 808 99 1 0
0 0 0 5125344 1101512 0 0 16 0 0 0 0 2 0 1 1 1287 815 860 97 3 0
0 0 0 5125352 1101520 0 0 27 0 0 0 0 2 0 1 1 1348 717 817 98 2 0
0 0 0 5125408 1101576 0 0 27 2 0 0 0 2 0 1 1 1227 751 854 98 1 0
0 0 0 5125408 1101576 0 0 18 0 0 0 0 2 0 1 1 1187 1110 849 99 1 0
0 0 0 5125344 1101512 0 0 22 0 0 0 0 2 0 1 1 1234 706 858 99 1 0
0 0 0 5125344 1101512 0 0 37 0 0 0 0 2 0 1 1 1196 1622 859 99 1 0
0 0 0 5125296 1101472 0 0 27 0 0 0 0 2 0 1 1 1222 2513 906 97 3 0
0 0 0 5125344 1101512 0 0 24 0 0 0 0 2 0 1 1 1211 953 851 99 1 0
0 0 0 5125256 1101464 0 0 19 2 0 0 0 2 0 1 1 1192 1674 856 98 2 0
0 0 0 5125344 1101512 0 0 46 0 0 0 0 2 0 1 1 1131 1864 868 99 1 0
0 0 0 5125344 1101512 0 0 6 0 0 0 0 2 0 1 1 1157 707 831 99 1 0
0 0 0 5125344 1101512 0 0 16 0 0 0 0 2 0 1 1 1269 687 838 99 1 0
0 0 0 5125344 1101512 0 0 32 0 0 0 0 2 0 1 1 1220 677 868 97 3 0
0 0 0 5125344 1101512 0 0 45 0 0 0 0 2 0 1 1 1226 1580 863 99 1 0
0 0 0 5125344 1101512 0 0 16 2 2 0 0 2 0 1 1 1152 711 864 99 1 0
0 0 0 5125224 1101288 0 0 29 0 0 0 0 2 0 1 1 1188 1064 910 99 1 0
0 0 0 5125344 1101504 0 0 19 0 0 0 0 2 0 1 1 1182 725 831 100 0 0
0 0 0 5125344 1101504 0 0 21 0 0 0 0 2 0 1 1 1126 722 842 99 1 0
kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m4 m7 in sy cs us sy id
0 0 0 5125320 1101480 0 0 10 0 0 0 0 2 0 1 1 1160 2377 847 97 3 0
0 0 0 5125264 1101424 0 0 38 0 0 0 0 2 0 1 1 1151 2065 916 98 2 0
0 0 0 5125328 1101488 0 0 18 2 0 0 0 2 0 1 1 1238 865 877 99 1 0
0 0 0 5125328 1101488 0 0 13 0 0 0 0 2 0 1 1 1182 972 852 99 1 0
0 0 0 5125328 1101488 0 0 86 0 0 0 0 2 0 1 1 1135 754 844 99 1 0
0 0 0 5125328 1101488 0 0 67 0 0 0 0 2 0 1 1 1148 693 850 100 0 0
0 0 0 5125280 1101440 0 0 26 0 0 0 0 2 0 1 1 1200 678 834 97 3 0
0 0 0 5125280 1101440 0 0 53 0 0 0 0 2 0 1 1 1410 991 962 99 1 0
0 0 0 5125312 1101480 0 0 316 2 0 0 0 2 0 1 1 1241 852 926 99 1 0
0 0 0 5125344 1101504 0 0 607 0 0 0 0 2 0 1 1 1239 1075 939 99 1 0
0 0 0 5125344 1101504 0 0 260 0 0 0 0 2 0 1 1 1263 846 920 99 1 0
0 0 0 5125280 1101440 0 0 380 0 0 0 0 2 0 1 1 1202 981 897 99 1 0
0 0 0 5125184 1101400 0 0 168 0 0 0 0 2 0 1 1 1243 2497 913 97 3 0
0 0 0 5125280 1101440 0 0 184 0 0 0 0 2 0 1 1 1237 1796 913 98 2 0
0 0 0 5125280 1101440 0 0 123 2 0 0 0 2 0 1 1 1339 1168 978 98 2 0
0 0 0 5125272 1101432 0 0 192 0 0 0 0 2 0 1 1 1178 1115 948 97 3 0
0 0 0 5125264 1101424 0 0 125 0 0 0 0 2 0 1 1 1189 776 899 99 1 0
0 0 0 5125264 1101424 0 0 101 0 0 0 0 2 0 1 1 1211 913 883 99 1 0
0 0 0 5125288 1101448 0 0 182 0 0 0 0 2 0 1 1 1226 830 859 97 3 0
kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m4 m7 in sy cs us sy id
0 0 0 5125328 1101488 0 0 120 0 0 0 0 2 0 1 1 1179 861 894 99 1 0
0 0 0 5125264 1101424 0 0 110 2 0 0 0 2 0 1 1 1410 905 885 99 1 0
0 0 0 5125256 1101416 0 0 93 0 0 0 0 2 0 1 1 1137 761 830 99 1 0
0 0 0 5125248 1101408 0 0 155 0 0 0 0 2 0 1 1 1288 1580 927 98 2 0
0 0 0 5125248 1101360 0 0 345 0 0 0 0 2 0 1 1 1327 1057 983 99 1 0
0 0 0 5125248 1101408 0 0 476 0 0 0 0 2 0 1 1 1304 2542 916 95 5 0
0 0 0 5125536 1101776 0 0 294 6 6 0 0 2 0 1 1 1530 2833 980 97 3 0
0 0 0 5125440 1101616 0 0 434 0 0 0 0 2 0 1 1 1474 1307 1154 98 2 0
0 0 0 5125408 1101536 0 0 1073 2 0 0 0 2 0 1 1 1611 1965 1571 98 2 0
0 0 0 5125440 1101616 0 0 639 2 2 0 0 2 0 1 1 1539 1719 1505 98 2 0
0 0 0 5125440 1101624 0 0 485 0 0 0 0 2 0 1 1 1531 1309 1433 98 2 0
0 0 0 5125440 1101624 0 0 672 0 0 0 0 2 0 1 1 1386 1014 1063 96 4 0
0 0 0 5125440 1101624 0 0 458 0 0 0 0 2 0 1 1 1493 973 988 98 2 0
0 0 0 5125440 1101624 0 0 315 0 0 0 0 2 0 1 1 1325 1165 986 98 2 0
0 0 0 5126000 1102696 0 0 361 0 0 0 0 2 0 1 1 1376 2498 1156 97 3 0
0 0 0 5126000 1103136 0 0 688 2 2 0 0 2 0 1 1 1356 4170 1196 96 4 0
*************** vmstat_S_cmd: Ended at Thu Feb 9 07:50:48 EST 2006 ***************

SP_SYSMON COMMAND:
----------------------------
*************** sysmon_cmd: Started at Thu Feb 9 07:20:01 EST 2006 ***************
Password:
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================

Server Version: Adaptive Server Enterprise/12.5.3/EBF 12330 ESD#1/P/Sun_
Server Name: sybprod
Run Date: Feb 09, 2006
Sampling Started at: Feb 09, 2006 07:20:02
Sampling Ended at: Feb 09, 2006 07:30:02
Sample Interval: 00:10:00
Sample Mode: Reset Counters

===============================================================================

Kernel Utilization
------------------

Your Runnable Process Search Count is set to 100
and I/O Polling Process Count is set to 35

Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 80.4 % 0.0 % 19.5 %
Engine 1 83.9 % 0.0 % 16.1 %
Engine 2 80.3 % 0.0 % 19.7 %
Engine 3 81.2 % 0.7 % 18.1 %
------------------------ -------- -------- --------
Summary Total 325.9 % 0.7 % 73.4 %
Average 81.5 % 0.2 % 18.3 %

CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 12.6 20.5 7545 30.7 %
Engine 1 8.2 13.3 4910 20.0 %
Engine 2 10.7 17.4 6399 26.1 %
Engine 3 9.5 15.4 5684 23.2 %
------------------------- ------------ ------------ ----------
Total CPU Yields 40.9 66.7 24538

Network Checks
Non-Blocking 1044.2 1702.5 626511 96.2 %
Blocking 40.9 66.7 24535 3.8 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 1085.1 1769.1 651046
Avg Net I/Os per Check n/a n/a 0.15283 n/a

Disk I/O Checks
Total Disk I/O Checks 1104.1 1800.2 662477 n/a
Checks Returning I/O 407.8 664.9 244673 36.9 %
Avg Disk I/Os Returned n/a n/a 0.01223 n/a

===============================================================================

Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process Requests
Requests Granted 0.0 0.0 5 100.0 %
Requests Denied 0.0 0.0 0 0.0 %
-------------------------- ------------ ------------ ----------
Total Requests 0.0 0.0 5

Requests Terminated 0.0 0.0 0 0.0 %

Worker Process Usage
Total Used 0.0 0.0 15 n/a
Max Ever Used During Sample 0.0 0.0 3 n/a

Memory Requests for Worker Processes
Succeeded 0.3 0.4 155 100.0 %
Failed 0.0 0.0 0 0.0 %
-------------------------- ------------ ------------ ----------
Total Requests 0.3 0.4 155

Avg Mem Ever Used by a WP (in bytes) n/a n/a 5018.7 n/a

Tuning Recommendations for Worker Processes
-------------------------------------------
- Consider decreasing the 'number of worker processes'
configuration parameter.

===============================================================================

Parallel Query Management
-------------------------

Parallel Query Usage per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Parallel Queries 0.0 0.0 5 n/a
WP Adjustments Made
Due to WP Limit 0.0 0.0 0 0.0 %
Due to No WPs 0.0 0.0 0 0.0 %

Merge Lock Requests per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Network Buffer Merge Locks
Granted with no wait 0.0 0.0 15 100.0 %
Granted after wait 0.0 0.0 0 0.0 %

Result Buffer Merge Locks
Granted with no wait 0.0 0.0 0 0.0 %
Granted after wait 0.0 0.0 0 0.0 %

Work Table Merge Locks
Granted with no wait 0.0 0.0 0 0.0 %
Granted after wait 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total # of Requests 0.0 0.0 15

Sort Buffer Waits per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total # of Waits 0.0 0.0 0 n/a

===============================================================================

Task Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------

Connections Opened 0.1 0.1 51 n/a

Task Context Switches by Engine
Engine 0 34.1 55.6 20475 25.8 %
Engine 1 29.3 47.8 17589 22.2 %
Engine 2 33.0 53.8 19788 24.9 %
Engine 3 35.9 58.5 21538 27.1 %
------------------------- ------------ ------------ ----------
Total Task Switches: 132.3 215.7 79390

Task Context Switches Due To:
Voluntary Yields 3.2 5.2 1909 2.4 %
Cache Search Misses 1.4 2.2 815 1.0 %
System Disk Writes 0.3 0.5 178 0.2 %
I/O Pacing 0.9 1.4 531 0.7 %
Logical Lock Contention 0.0 0.0 5 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 0 0.0 %
Log Semaphore Contention 0.0 0.0 2 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.1 0.1 46 0.1 %
Last Log Page Writes 0.8 1.3 468 0.6 %
Modify Conflicts 0.0 0.1 23 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 14.6 23.8 8773 11.1 %
Network Packet Sent 72.4 118.0 43410 54.7 %
Other Causes 38.7 63.1 23230 29.3 %

Tuning Recommendations for Task Management
------------------------------------------
- Consider tuning your Network I/O sub-system.

===============================================================================

Application Management
----------------------

Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.0 0.0 14 2.2 %
To Medium Priority 0.6 0.9 339 54.1 %
To Low Priority 0.5 0.7 274 43.7 %
------------------------- ------------ ------------ ----------
Total Priority Changes 1.0 1.7 627

Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.1 0.2 88 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.1 0.2 88

Skipped Tasks By Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Engine Skips 0.0 0.0 0 n/a

Engine Scope Changes 0.0 0.0 0 n/a

===============================================================================

ESP Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
ESP Requests 0.0 0.0 0 n/a
===============================================================================

Housekeeper Task Activity
-------------------------
per sec per xact count % of total
------------ ------------ ----------
Buffer Cache Washes
Clean 68.3 111.4 41008 96.7 %
Dirty 2.4 3.9 1418 3.3 %
------------ ------------ ----------
Total Washes 70.7 115.3 42426

Garbage Collections 0.7 1.2 424 n/a
Pages Processed in GC 0.0 0.0 0 n/a

Statistics Updates 0.5 0.8 309 n/a

===============================================================================

Monitor Access to Executing SQL
-------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Waits on Execution Plans 0.0 0.0 0 n/a
Number of SQL Text Overflows 0.0 0.0 10 n/a
Maximum SQL Text Requested n/a n/a 1829 n/a
(since beginning of sample)

Tuning Recommendations for Monitor Access to Executing SQL
----------------------------------------------------------
- Consider increasing the 'max SQL text monitored' parameter
to at least 1437 (i.e., half way from its current value
to Maximum SQL Text Requested).

===============================================================================

Transaction Profile
-------------------

Transaction Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Committed Xacts 0.6 n/a 368 n/a

Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 4.5 7.3 2678 94.1 %
APL Clustered Table 0.3 0.5 168 5.9 %
Data Only Lock Table 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 4.7 7.7 2846 99.4 %

Updates
APL Deferred 0.0 0.0 8 100.0 %
APL Direct In-place 0.0 0.0 0 0.0 %
APL Direct Cheap 0.0 0.0 0 0.0 %
APL Direct Expensive 0.0 0.0 0 0.0 %
DOL Deferred 0.0 0.0 0 0.0 %
DOL Direct 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.0 0.0 8 0.3 %

Data Only Locked Updates
Total Rows Updated 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 0.0 0.0 0 0.0 %

Deletes
APL Deferred 0.0 0.0 8 100.0 %
APL Direct 0.0 0.0 0 0.0 %
DOL 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 0.0 0.0 8 0.3 %
========================= ============ ============ ==========
Total Rows Affected 4.8 7.8 2862

===============================================================================

Transaction Management
----------------------

ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.1 0.2 80 10.1 %
by End Transaction 0.7 1.1 422 53.0 %
by Change of Database 0.0 0.0 15 1.9 %
by Single Log Record 0.3 0.5 193 24.2 %
by Unpin 0.0 0.1 20 2.5 %
by Other 0.1 0.2 66 8.3 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 1.3 2.2 796

ULC Log Records 7.6 12.4 4566 n/a
Max ULC Size During Sample n/a n/a 2048 n/a

ULC Semaphore Requests
Granted 16.0 26.1 9590 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 16.0 26.1 9590

Log Semaphore Requests
Granted 1.5 2.4 878 99.8 %
Waited 0.0 0.0 2 0.2 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 1.5 2.4 880

Transaction Log Writes 1.2 2.0 724 n/a
Transaction Log Alloc 0.4 0.7 241 n/a
Avg # Writes per Log Page n/a n/a 3.00415 n/a

Tuning Recommendations for Transaction Management
-------------------------------------------------
- Consider decreasing the 'user log cache size'
configuration parameter if it is greater than the
logical database page size.

===============================================================================

Index Management
----------------

Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 0.3 0.5 168 n/a
# of NC Ndx Maint 2.2 3.6 1326 n/a
Avg NC Ndx Maint / Op n/a n/a 7.89286 n/a

Deletes Requiring Maint 0.0 0.0 8 n/a
# of NC Ndx Maint 0.1 0.2 56 n/a
Avg NC Ndx Maint / Op n/a n/a 7.00000 n/a

RID Upd from Clust Split 0.0 0.0 17 n/a
# of NC Ndx Maint 1.3 2.0 752 n/a
Avg NC Ndx Maint / Op n/a n/a 44.23529 n/a

Upd/Del DOL Req Maint 0.0 0.0 0 n/a
# of DOL Ndx Maint 0.0 0.0 0 n/a

Page Splits 0.1 0.2 56 n/a
Retries 0.0 0.0 0 0.0 %
Deadlocks 0.0 0.0 0 0.0 %
Add Index Level 0.0 0.0 0 0.0 %

Page Shrinks 0.0 0.0 0 n/a

Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 939.3 1531.4 563563 92.5 %
DOL Ascending Scans 75.6 123.3 45388 7.5 %
Descending Scans 0.0 0.1 23 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 1015.0 1654.8 608974

===============================================================================

Metadata Cache Management
-------------------------

Metadata Cache Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------

Open Object Usage
Active n/a n/a 1090 n/a
Max Ever Used Since Boot n/a n/a 1091 n/a
Free n/a n/a 750 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a

Open Index Usage
Active n/a n/a 191 n/a
Max Ever Used Since Boot n/a n/a 207 n/a
Free n/a n/a 250 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a

Open Database Usage
Active n/a n/a 8 n/a
Max Ever Used Since Boot n/a n/a 8 n/a
Free n/a n/a 12 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a

Object Manager Spinlock Contention n/a n/a n/a 2.0 %

Object Spinlock Contention n/a n/a n/a 0.0 %

Index Spinlock Contention n/a n/a n/a 0.0 %

Hash Spinlock Contention n/a n/a n/a 0.0 %

===============================================================================

Lock Management
---------------

Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 32291.4 52649.0 19374829 n/a
Avg Lock Contention 0.0 0.0 5 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %

Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------

Table Lock Hashtable
Lookups 87.7 142.9 52593 n/a
Avg Chain Length n/a n/a 0.00715 n/a
Spinlock Contention n/a n/a n/a 0.0 %

Exclusive Table
Total EX-Table Requests 0.0 0.0 0 n/a

Shared Table
Granted 0.0 0.0 4 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 0.0 0.0 4 0.0 %

Exclusive Intent
Granted 0.7 1.1 403 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 0.7 1.1 403 0.0 %

Shared Intent
Granted 87.0 141.8 52182 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 87.0 141.8 52182 0.3 %

Page & Row Lock HashTable
Lookups 30880.9 50349.3 18528549 n/a
Avg Chain Length n/a n/a 0.01667 n/a
Spinlock Contention n/a n/a n/a 0.0 %

Exclusive Page
Granted 2.4 3.9 1429 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 2.4 3.9 1429 0.0 %

Update Page
Granted 0.1 0.1 55 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 0.1 0.1 55 0.0 %

Shared Page
Granted 29582.6 48232.4 17749533 100.0 %
Waited 0.0 0.0 5 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 29582.6 48232.4 17749538 91.6 %

Exclusive Row
Granted 0.3 0.5 201 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.3 0.5 201 0.0 %

Update Row
Total UP-Row Requests 0.0 0.0 0 n/a

Shared Row
Granted 1291.4 2105.6 774846 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 1291.4 2105.6 774846 4.0 %

Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a

Address Lock Hashtable
Lookups 1327.0 2163.5 796171 n/a
Avg Chain Length n/a n/a 0.00003 n/a
Spinlock Contention n/a n/a n/a 0.0 %

Exclusive Address
Granted 22.0 35.9 13207 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 22.0 35.9 13207 0.1 %

Shared Address
Granted 1304.9 2127.6 782964 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 1304.9 2127.6 782964 4.0 %

Last Page Locks on Heaps
Granted 4.5 7.3 2678 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 4.5 7.3 2678 100.0 %

Deadlocks by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Deadlocks 0.0 0.0 0 n/a

Deadlock Detection
Deadlock Searches 0.0 0.0 3 n/a
Searches Skipped 0.0 0.0 0 0.0 %
Avg Deadlocks per Search n/a n/a 0.00000 n/a

Lock Promotions
Total Lock Promotions 0.0 0.0 0 n/a

Lock Timeouts by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Timeouts 0.0 0.0 0 n/a

Tuning Recommendations for Lock Management
------------------------------------------
- Consider increasing the 'deadlock checking period' parameter
by 50 ms.

===============================================================================

Data Cache Management
---------------------

Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------

Cache Search Summary
Total Cache Hits 31627.4 51566.4 18976431 100.0 %
Total Cache Misses 1.4 2.3 843 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 31628.8 51568.7 18977274

Cache Turnover
Buffers Grabbed 1.4 2.3 856 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %

Cache Strategy Summary
Cached (LRU) Buffers 29983.8 48886.6 17990253 100.0 %
Discarded (MRU) Buffers 0.2 0.3 93 0.0 %

Large I/O Usage
0.0 0.0 0 n/a

Large I/O Effectiveness
Pages by Lrg I/O Cached 0.0 0.0 0 n/a

Asynchronous Prefetch Activity
0.0 0.0 0 n/a

Other Asynchronous Prefetch Statistics
APFs Used 0.0 0.0 0 n/a
APF Waits for I/O 0.0 0.0 0 n/a
APF Discards 0.0 0.0 0 n/a

Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a

-------------------------------------------------------------------------------
Cache: default data cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %

Utilization n/a n/a n/a 99.9 %

Cache Searches
Cache Hits 31600.6 51522.8 18960384 100.0 %
Found in Wash 71.5 116.7 42929 0.2 %
Cache Misses 0.1 0.2 67 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 31600.8 51523.0 18960451

Pool Turnover
2 Kb Pool
LRU Buffer Grab 0.1 0.2 80 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 0.1 0.2 80

Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet

Cache Strategy
Cached (LRU) Buffers 29955.3 48840.2 17973185 100.0 %
Discarded (MRU) Buffers 0.2 0.3 93 0.0 %

Large I/O Usage
Total Large I/O Requests 0.0 0.0 0 n/a

Large I/O Detail
No Large Pool(s) In This Cache

Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a

Tuning Recommendations for Data cache : default data cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.

- Consider adding a large I/O pool for this cache.

-------------------------------------------------------------------------------
Cache: index_map_cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %

Utilization n/a n/a n/a 0.1 %

Cache Searches
Cache Hits 26.7 43.6 16047 95.4 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 1.3 2.1 776 4.6 %
------------------------- ------------ ------------ ----------
Total Cache Searches 28.0 45.7 16823

Pool Turnover
2 Kb Pool
LRU Buffer Grab 1.3 2.1 776 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 1.3 2.1 776

Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet

Cache Strategy
Cached (LRU) Buffers 28.4 46.4 17068 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %

Large I/O Usage
Total Large I/O Requests 0.0 0.0 0 n/a

Large I/O Detail
16 Kb Pool
Pages Cached 0.0 0.0 0 n/a
Pages Used 0.0 0.0 0 n/a

Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a

===============================================================================

Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 0.8 1.3 465 n/a
Procedure Reads from Disk 0.0 0.0 4 0.9 %
Procedure Writes to Disk 0.0 0.0 0 0.0 %
Procedure Removals 0.0 0.0 8 n/a
Procedure Recompilations 0.0 0.0 0 n/a

SQL Statement Cache:
Statements Cached 0.0 0.0 0 n/a
Statements Found in Cache 0.0 0.0 0 n/a
Statements Not Found 0.0 0.0 0 n/a
Statements Dropped 0.0 0.0 0 n/a
Statements Restored 0.0 0.0 0 n/a
Statements Not Cached 0.0 0.0 0 n/a

===============================================================================

Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 0.2 0.3 99 n/a
Pages Released 0.2 0.3 97 n/a

===============================================================================

Recovery Management
-------------------

Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 15 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 15

Avg Time per Normal Chkpt 1.86667 seconds

===============================================================================

Disk I/O Management
-------------------

Max Outstanding I/Os per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Server n/a n/a 12 n/a
Engine 0 n/a n/a 8 n/a
Engine 1 n/a n/a 6 n/a
Engine 2 n/a n/a 7 n/a
Engine 3 n/a n/a 12 n/a

I/Os Delayed by
Disk I/O Structures n/a n/a 0 n/a
Server Config Limit n/a n/a 0 n/a
Engine Config Limit n/a n/a 0 n/a
Operating System Limit n/a n/a 0 n/a

Total Requested Disk I/Os 5.0 8.1 2993

Completed Disk I/O's
Engine 0 0.6 1.0 351 11.7 %
Engine 1 0.3 0.4 165 5.5 %
Engine 2 0.7 1.2 437 14.6 %
Engine 3 3.4 5.5 2040 68.2 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 5.0 8.1 2993

Device Activity Detail
----------------------

Device:
/tempdb/tempdb1
tempdb1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.2 0.3 127 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.2 0.3 127 4.2 %

-----------------------------------------------------------------------------

Device:
/u01/d_master
master per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.1 0.2 71 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.2 71 2.4 %

-----------------------------------------------------------------------------

Device:
/u01/fixed_info_CIdx_dev_01
fixed_info_CIdx_dev_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 15 31.9 %
Writes 0.1 0.1 32 68.1 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.1 47 1.6 %

-----------------------------------------------------------------------------

Device:
/u01/fixed_info_CIdx_dev_05
fixed_info_CIdx_dev_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/fixed_info_CIdx_dev_09
fixed_info_CIdx_dev_09 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/fixed_info_CIdx_dev_13
fixed_info_CIdx_dev_13 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/fixed_info_NCIdx_dev_01
fixed_info_NCIdx_dev_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.1 46 48.4 %
Writes 0.1 0.1 49 51.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.2 0.3 95 3.2 %

-----------------------------------------------------------------------------

Device:
/u01/fixed_info_NCIdx_dev_05
fixed_info_NCIdx_dev_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 2 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 2 0.1 %

-----------------------------------------------------------------------------

Device:
/u01/float_info_CIdx_dev_01
float_info_CIdx_dev_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.1 22 28.6 %
Writes 0.1 0.1 55 71.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.2 77 2.6 %

-----------------------------------------------------------------------------

Device:
/u01/float_info_CIdx_dev_05
float_info_CIdx_dev_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/float_info_CIdx_dev_09
float_info_CIdx_dev_09 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/float_info_CIdx_dev_13
float_info_CIdx_dev_13 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/float_info_NCIdx_dev_01
float_info_NCIdx_dev_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.1 52 43.0 %
Writes 0.1 0.2 69 57.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.2 0.3 121 4.0 %

-----------------------------------------------------------------------------

Device:
/u01/float_info_NCIdx_dev_05
float_info_NCIdx_dev_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/report_data_01
report_data_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/report_data_log_01
report_data_log_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/sybsystemdb
sybsystemdb per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/sysprocsdev
sysprocsdev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/trade_info_CIdx_dev_01
trade_info_CIdx_dev_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 2 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 2 0.1 %

-----------------------------------------------------------------------------

Device:
/u01/trade_info_CIdx_dev_05
trade_info_CIdx_dev_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/trade_info_CIdx_dev_09
trade_info_CIdx_dev_09 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/trade_info_CIdx_dev_13
trade_info_CIdx_dev_13 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u01/trade_info_NCIdx_dev_01
trade_info_NCIdx_dev_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 2 18.2 %
Writes 0.0 0.0 9 81.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 11 0.4 %

-----------------------------------------------------------------------------

Device:
/u01/trade_info_NCIdx_dev_05
trade_info_NCIdx_dev_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/fixed_info_CIdx_dev_02
fixed_info_CIdx_dev_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/fixed_info_CIdx_dev_06
fixed_info_CIdx_dev_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/fixed_info_CIdx_dev_10
fixed_info_CIdx_dev_10 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/fixed_info_CIdx_dev_14
fixed_info_CIdx_dev_14 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/fixed_info_NCIdx_dev_02
fixed_info_NCIdx_dev_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.2 83 47.7 %
Writes 0.2 0.2 91 52.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.3 0.5 174 5.8 %

-----------------------------------------------------------------------------

Device:
/u02/fixed_info_NCIdx_dev_06
fixed_info_NCIdx_dev_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/float_info_CIdx_dev_02
float_info_CIdx_dev_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/float_info_CIdx_dev_06
float_info_CIdx_dev_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/float_info_CIdx_dev_10
float_info_CIdx_dev_10 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/float_info_CIdx_dev_14
float_info_CIdx_dev_14 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/float_info_NCIdx_dev_02
float_info_NCIdx_dev_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.2 67 42.4 %
Writes 0.2 0.2 91 57.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.3 0.4 158 5.3 %

-----------------------------------------------------------------------------

Device:
/u02/float_info_NCIdx_dev_06
float_info_NCIdx_dev_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 4 66.7 %
Writes 0.0 0.0 2 33.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 6 0.2 %

-----------------------------------------------------------------------------

Device:
/u02/log1
log1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 1.2 1.9 701 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.2 1.9 701 23.4 %

-----------------------------------------------------------------------------

Device:
/u02/report_data_02
report_data_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/report_data_03
report_data_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/report_data_04
report_data_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/trade_info_CIdx_dev_02
trade_info_CIdx_dev_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/trade_info_CIdx_dev_06
trade_info_CIdx_dev_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/trade_info_CIdx_dev_10
trade_info_CIdx_dev_10 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/trade_info_CIdx_dev_14
trade_info_CIdx_dev_14 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/trade_info_NCIdx_dev_02
trade_info_NCIdx_dev_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u02/trade_info_NCIdx_dev_06
trade_info_NCIdx_dev_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 2 22.2 %
Writes 0.0 0.0 7 77.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 9 0.3 %

-----------------------------------------------------------------------------

Device:
/u03/data1
data1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.1 40 37.7 %
Writes 0.1 0.2 66 62.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.2 0.3 106 3.5 %

-----------------------------------------------------------------------------

Device:
/u03/data3
data3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/data5
data5 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.1 22 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.1 22 0.7 %

-----------------------------------------------------------------------------

Device:
/u03/data7
data7 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/fixed_info_CIdx_dev_03
fixed_info_CIdx_dev_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 4 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 4 0.1 %

-----------------------------------------------------------------------------

Device:
/u03/fixed_info_CIdx_dev_07
fixed_info_CIdx_dev_07 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/fixed_info_CIdx_dev_11
fixed_info_CIdx_dev_11 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/fixed_info_CIdx_dev_15
fixed_info_CIdx_dev_15 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 5 17.2 %
Writes 0.0 0.1 24 82.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.1 29 1.0 %

-----------------------------------------------------------------------------

Device:
/u03/fixed_info_NCIdx_dev_03
fixed_info_NCIdx_dev_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.3 113 33.8 %
Writes 0.4 0.6 221 66.2 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.6 0.9 334 11.2 %

-----------------------------------------------------------------------------

Device:
/u03/fixed_info_NCIdx_dev_07
fixed_info_NCIdx_dev_07 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 3 50.0 %
Writes 0.0 0.0 3 50.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 6 0.2 %

-----------------------------------------------------------------------------

Device:
/u03/float_info_CIdx_dev_03
float_info_CIdx_dev_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/float_info_CIdx_dev_07
float_info_CIdx_dev_07 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/float_info_CIdx_dev_11
float_info_CIdx_dev_11 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/float_info_CIdx_dev_15
float_info_CIdx_dev_15 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 4 28.6 %
Writes 0.0 0.0 10 71.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 14 0.5 %

-----------------------------------------------------------------------------

Device:
/u03/float_info_NCIdx_dev_03
float_info_NCIdx_dev_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.3 120 30.5 %
Writes 0.5 0.7 274 69.5 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.7 1.1 394 13.2 %

-----------------------------------------------------------------------------

Device:
/u03/float_info_NCIdx_dev_07
float_info_NCIdx_dev_07 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 7 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 7 0.2 %

-----------------------------------------------------------------------------

Device:
/u03/trade_info_CIdx_dev_03
trade_info_CIdx_dev_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/trade_info_CIdx_dev_07
trade_info_CIdx_dev_07 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/trade_info_CIdx_dev_11
trade_info_CIdx_dev_11 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u03/trade_info_CIdx_dev_15
trade_info_CIdx_dev_15 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 3 17.6 %
Writes 0.0 0.0 14 82.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 17 0.6 %

-----------------------------------------------------------------------------

Device:
/u03/trade_info_NCIdx_dev_03
trade_info_NCIdx_dev_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 12 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 12 0.4 %

-----------------------------------------------------------------------------

Device:
/u03/trade_info_NCIdx_dev_07
trade_info_NCIdx_dev_07 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 3 60.0 %
Writes 0.0 0.0 2 40.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 5 0.2 %

-----------------------------------------------------------------------------

Device:
/u04/data2
data2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.1 22 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.1 22 0.7 %

-----------------------------------------------------------------------------

Device:
/u04/data4
data4 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 5 100.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 5 0.2 %

-----------------------------------------------------------------------------

Device:
/u04/data6
data6 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/fixed_info_CIdx_dev_04
fixed_info_CIdx_dev_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/fixed_info_CIdx_dev_08
fixed_info_CIdx_dev_08 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/fixed_info_CIdx_dev_12
fixed_info_CIdx_dev_12 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/fixed_info_CIdx_dev_16
fixed_info_CIdx_dev_16 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/fixed_info_NCIdx_dev_04
fixed_info_NCIdx_dev_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 3 60.0 %
Writes 0.0 0.0 2 40.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 5 0.2 %

-----------------------------------------------------------------------------

Device:
/u04/fixed_info_NCIdx_dev_08
fixed_info_NCIdx_dev_08 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.3 114 64.4 %
Writes 0.1 0.2 63 35.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.3 0.5 177 5.9 %

-----------------------------------------------------------------------------

Device:
/u04/float_info_CIdx_dev_04
float_info_CIdx_dev_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/float_info_CIdx_dev_08
float_info_CIdx_dev_08 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/float_info_CIdx_dev_12
float_info_CIdx_dev_12 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/float_info_CIdx_dev_16
float_info_CIdx_dev_16 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 1 6.7 %
Writes 0.0 0.0 14 93.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 15 0.5 %

-----------------------------------------------------------------------------

Device:
/u04/float_info_NCIdx_dev_04
float_info_NCIdx_dev_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 2 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 2 0.1 %

-----------------------------------------------------------------------------

Device:
/u04/float_info_NCIdx_dev_08
float_info_NCIdx_dev_08 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.3 97 60.6 %
Writes 0.1 0.2 63 39.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.3 0.4 160 5.3 %

-----------------------------------------------------------------------------

Device:
/u04/trade_info_CIdx_dev_04
trade_info_CIdx_dev_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/trade_info_CIdx_dev_08
trade_info_CIdx_dev_08 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/trade_info_CIdx_dev_12
trade_info_CIdx_dev_12 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/trade_info_CIdx_dev_16
trade_info_CIdx_dev_16 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/trade_info_NCIdx_dev_04
trade_info_NCIdx_dev_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 1 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 1 0.0 %

-----------------------------------------------------------------------------

Device:
/u04/trade_info_NCIdx_dev_08
trade_info_NCIdx_dev_08 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 11 20.0 %
Writes 0.1 0.1 44 80.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.1 55 1.8 %

-----------------------------------------------------------------------------

===============================================================================

Network I/O Management
----------------------

Total Network I/O Requests 87.0 141.8 52183 n/a
Network I/Os Delayed 0.0 0.0 0 0.0 %

Total TDS Packets Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 3.7 6.0 2204 25.1 %
Engine 1 4.1 6.6 2447 27.9 %
Engine 2 4.1 6.7 2463 28.1 %
Engine 3 2.8 4.5 1658 18.9 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 14.6 23.8 8772

Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 682.6 1112.9 409535 19.6 %
Engine 1 1012.7 1651.2 607634 29.0 %
Engine 2 1078.0 1757.6 646811 30.9 %
Engine 3 717.4 1169.7 430439 20.6 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 3490.7 5691.4 2094419

Avg Bytes Rec'd per Packet n/a n/a 238 n/a

-----------------------------------------------------------------------------

Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 25.7 42.0 15439 17.0 %
Engine 1 51.7 84.3 31035 34.2 %
Engine 2 38.9 63.4 23320 25.7 %
Engine 3 34.9 56.9 20935 23.1 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 151.2 246.5 90729

Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 12026.3 19608.2 7215802 16.7 %
Engine 1 24959.2 40694.3 14975517 34.6 %
Engine 2 18312.3 29857.0 10987375 25.4 %
Engine 3 16838.7 27454.4 10103215 23.3 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 72136.5 117613.9 43281909

Avg Bytes Sent per Packet n/a n/a 477 n/a

=============================== End of Report =================================
(return status = 0)
*************** sysmon_cmd: Ended at Thu Feb 9 07:30:51 EST 2006 ***************

Joe Woodhouse

Ok, that looks like a busy server! 8->

Notice the difference in utilisation - "top" shows 98% user CPU, but sp_sysmon says average engine utilisation is 81.5%. This is the difference I was saying in an earlier comment.

What's causing this? In sp_sysmon, under the Task Management section, look at context switches. This says "why did I stop doing work?" The overwhelming cause is "Network Send", so this ASE thinks it's interrupting useful work to constant send results over the network.

At the bottom of sp_sysmon, in the Network section, we see the average bytes sent per packet is 477. The default Sybase packet size is 512 bytes, so these packets are full. Since we know from context switches that most of the interruption is in sending packets - packets that are almost full - the single best thing we could do here is to use a larger network packet size. ie. if you have to empty a bathtub, it's a lot faster to use a bucket than a spoon! Same amount of water to shuft either way, but fewer trips needed with a larger container.

To increase the packet size, you have to configure the server but the client must also explicitly request a larger size. Despite the name, "default network packet size" does *not* change the default size used by all client connections! So if you don't have the ability to get into the client and change the packet size, there's little point attempting this.

I will say, though, you should check the setting of

sp_configure "tcp no delay"

If this is set to 1, reset it to 0. Tcp no delay says send packets immediately rather than letting them fill a bit more. When packet sizes are this large, we definitely want that delay. You have to have SA permissions to change this, and it needs a reboot.

Some other items:

- increase "memory per worker process" (default is 1024, you're using 5018, suggest 4096)
- increase "max SQL text monitored" (default is 1024, you're using 1829, suggest 2048)
- increase "user log cache size" (default is 2048, you're filling that 10% of the time, suggest 4096)
- increase "deadlock checking period" (default is 500, suggest 750)
- convert default data cache from strict to relaxed (suitable when cache hit rate is > 99%)
- add large I/O (suits sequential I/O)
- increase database log I/O size (needs large I/O pools as above)

Can I get some more output from you?

exec sp_cacheconfig
exec sp_helpcache
go
exec sp_countmetadata "open databases"
exec sp_countmetadata "open objects"
exec sp_countmetadata "open indexes"
go
exec sp_monitorconfig "all"
go

Commands to implement all this:

exec sp_configure "default network packet size", 1024
exec sp_configure "memory per worker process", 4096
exec sp_configure "max SQL text monitored", 2048
exec sp_configure "user log cache size", 4096
exec sp_configure "deadlock tuning period", 750
go
exec sp_cacheconfig "default data cache", "relaxed"
exec sp_poolconfig "default data cache", "50M", "4K"
exec sp_poolconfig "default data cache", "<<<25% size of 2Kb pool as reported by sp_cacheconfig>>>", "16Kb"
go

Good luck!

gyans

ASKER

Sorry for being late:
The results of the the queries requested are as following:
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
tcp no delay 1 0 1 1 switch static

Cache Name Status Type Config Value Run Value
---------- ------ ---- ------------ ---------
default data cache Active Default 125.00 Mb 125.00 Mb
index_map_cache Active Mixed 740.00 Mb 740.00 Mb

IO Size Wash Size Config Size Run Size APF Percent
------- --------- ----------- -------- -----------
2 Kb 25600 Kb 0.00 Mb 125.00 Mb 50

IO Size Wash Size Config Size Run Size APF Percent
------- --------- ----------- -------- -----------
2 Kb 38912 Kb 0.00 Mb 190.00 Mb 50
16 Kb 61440 Kb 550.00 Mb 550.00 Mb 50

Name Num_free Num_active Pct_act Max_Used Num_Reuse
---- ----------- ----------- ------- ----------- -----------
additional network memory 0 394160 100.00 394160 0
audit queue size 100 0 0.00 0 0
disk i/o structures 256 0 0.00 0 0
heap memory per user 4096 0 0.00 1 0
max cis remote connection 520 0 0.00 1 0
max memory 0 768000 100.00 768000 0
max number network listen 4 1 20.00 1 0
max online engines 0 4 100.00 4 0
memory per worker process 864 160 15.63 455 0
number of alarms 29 11 27.50 15 0
number of aux scan descri 200 0 0.00 2 0
number of devices 11 89 89.00 89 0
number of dtx participant 500 0 0.00 0 0
number of java sockets 147 0 0.00 0 0
number of large i/o buffe 16 0 0.00 16 0
number of locks 54670 330 0.60 55346 0
number of mailboxes 0 93 100.00 129 0
number of messages 0 90459 100.00 90499 0
number of open databases 4 8 66.67 8 0
number of open indexes 65 185 74.00 207 0
number of open objects 0 1101 100.00 1106 0
number of remote connecti 20 0 0.00 4 0
number of remote logins 20 0 0.00 4 0
number of remote sites 10 0 0.00 1 0
number of sort buffers 32720 47 0.14 52925 0
number of user connection 101 29 22.31 91 0
number of worker processe 59 16 21.33 91 0
partition groups 1022 2 0.20 29 0
permission cache entries 0 57225 100.00 57225 885980
procedure cache size 194509 5491 2.75 126252 497658
size of global fixed heap 150 0 0.00 0 0
size of process object he 1500 0 0.00 0 0
size of shared class heap 1536 0 0.00 0 0
size of unilib cache 126452 4064 3.11 4064 0
txn to pss ratio 2080 0 0.00 0 0

thank you for your help again .

Joe Woodhouse

1) Still missing the output of:

exec sp_countmetadata "open databases"
exec sp_countmetadata "open objects"
exec sp_countmetadata "open indexes"
go

2) Tcp no delay is indeed at the dafault of 1. Try resetting to 0.

3) Your data caches look crazy!

> default data cache Active Default 125.00 Mb 125.00 Mb
> index_map_cache Active Mixed 740.00 Mb 740.00 Mb

Your default data cache has only 25% of all data cache memory!! This is way too small. Standard recommendations are that it should never be below 50%, and even that isn't a good idea.

Can we see what's currently bound to index_map_cache?

sp_helpcache index_map_cache
go

Also, that's only 1Gb of total data cache which may be too low depending on the size of your databases...

gyans

ASKER

Cache Name Config Size Run Size Overhead
------------------------ ------------- ---------- ----------
index_map_cache 740.00 Mb 740.00 Mb 49.01 Mb

------------------ Cache Binding Information: ------------------

Cache Name Entity Name Type Index Name Status
---------- ----------- ---- ---------- ------
Server Message: Number 5884, Severity 10
Server 'sybccgp', Procedure 'sp_helpcache', Line 191:
index_map_cache index_map database V
(1 row affected)
(return status = 0)

---------------

There are 8 databases, requiring 1442 Kbytes of memory. The 'open databases' configuration parameter is currently set to 12.
There are 608 user objects in all database(s), requiring 1069 Kbytes of memory. The 'open objects' configuration parameter is currently set to 750.
There are 182 user indexes in all database(s), requiring 300 Kbytes of memory. The 'open indexes' configuration parameter is currently set to 250.
(return status = 0)
(return status = 0)
(return status = 0)

thanks AGAIN.

gyans

ASKER

There are a process feeding into the database and from times to time gives the following error:
Procedure "INIT_TEST",
Server "sybp",
Msg 1205, Level 13, State 1

Can we fix both at the same time ,

thank you ,Vinai