09-15-2003
Hi Khalid,
Nope. I think (from what I have seen), that there is an SQL-statement runing on a table which has not been indexed and might therefor be eating more cpu-time. Looking at some scripts that just perform the same action over a thousand times in a script might be the cause of your problem now.
Our DBA and I have often seen users run awfull SQL statements which cause this problem.
It might be nice for you to find out the real bottleneck in her performing : sar 2 20 . You can now see if it's WIO/ USR or SYS. Most off all it will also be WIO. Still upgrading memory should not matter.
Aargh, will deep into it a bit more. Please perform a
"swapinfo -at"
and paste the output here. Also the output of "sar 5 20" would be nice. Please let me know the total amount of physical memory and created swap. Also let me know on what disk you configured swap. please give me a "sar -d 5 20" output of this disk.
Will continue tomorow.
Regs David
9 More Discussions You Might Find Interesting
1. Cybersecurity
Hi all
what are the ways by which we can know and generate a report of the space remaining, memory(ram) used and the load on the server over a period of time. (1 Reply)
Discussion started by: arlan
1 Replies
2. Linux
I need to download a script from Unix box to my PC. I don't have FTP installed on that machine and I am not able to connect to the server using ftp <Server Name>.
I am not supposed to install any software on the server but still need to download the file. Heard that we have a secured ftp option... (3 Replies)
Discussion started by: chandu_kalari
3 Replies
3. Linux
Hi
anyone know how to setup a setup a virtual IP to control 2 server load for linux? i only have 2 server, i don want to buy another just for the load balance... is there a way to do it?
Sumemr (0 Replies)
Discussion started by: summerpeh
0 Replies
4. Red Hat
we are using redhat linux,configured the postfix as mail server and outlook is used as mail client.whenever the user opens outlook it is start downloading all the mails from the server.
Example : If a user has 50 mails in the server,whenever he opens the outlook the outlook will start... (0 Replies)
Discussion started by: ramjimh2k3
0 Replies
5. Shell Programming and Scripting
Hi Folks,
I want to see the proper status of a low performance server. I tried using top command but it doesn't give all the details.
Any help in this regard would be appreciated.
Regards,
Sagar (1 Reply)
Discussion started by: sagarjani
1 Replies
6. UNIX for Advanced & Expert Users
how to enable cygwin in linux server (redHat).....
any idea? (1 Reply)
Discussion started by: crackthehit007
1 Replies
7. Shell Programming and Scripting
Hello,
I could use a little help with the command line part of this. I've got it to sorta work if I use this `gawk -F"/"'{ print $3 }'`
I've also tried `pwd|cut -d/ -f3` with no luck. Is this possible to do? I'm basically doing this to copy the users domain, then paste that into the... (5 Replies)
Discussion started by: biopulse
5 Replies
8. IP Networking
Can someone help with a detail step-by-step oh how to configure DNS server on Linux Server.
-
I need to have 3 IP addresses map to a single hostname.
for clients
I'm a Linux rookie.
Thanks
Oscar (1 Reply)
Discussion started by: FrankOscar
1 Replies
9. Programming
Here is a useful SSL (HTTPS) application for anyone with a remote Linux server they want to keep an eye on using Blynk and the NodeMCU ESP8266. This little app also works (have tested as well) on the WeMos D1 ESP8266 Arduino board.
The NodeMCU setup could not be easier, just find a... (8 Replies)
Discussion started by: Neo
8 Replies
LEARN ABOUT OPENSOLARIS
sa1
sar(1M) System Administration Commands sar(1M)
NAME
sar, sa1, sa2, sadc - system activity report package
SYNOPSIS
/usr/lib/sa/sadc [t n] [ofile]
/usr/lib/sa/sa1 [t n]
/usr/lib/sa/sa2 [-aAbcdgkmpqruvwy] [-e time] [-f filename]
[-i sec] [-s time]
DESCRIPTION
System activity data can be accessed at the special request of a user (see sar(1)) and automatically, on a routine basis, as described
here. The operating system contains several counters that are incremented as various system actions occur. These include counters for CPU
utilization, buffer usage, disk and tape I/O activity, TTY device activity, switching and system-call activity, file-access, queue activ-
ity, inter-process communications, and paging. For more general system statistics, use iostat(1M), sar(1), or vmstat(1M).
sadc and two shell procedures, sa1 and sa2, are used to sample, save, and process this data.
sadc, the data collector, samples system data n times, with an interval of t seconds between samples, and writes in binary format to ofile
or to standard output. The sampling interval t should be greater than 5 seconds; otherwise, the activity of sadc itself may affect the sam-
ple. If t and n are omitted, a special record is written. This facility can be used at system boot time, when booting to a multi-user
state, to mark the time at which the counters restart from zero. For example, when accounting is enabled, the svc:/system/sar:default ser-
vice writes the restart mark to the daily data file using the command entry:
su sys -c "/usr/lib/sa/sadc /var/adm/sa/sa'date +%d'"
The shell script sa1, a variant of sadc, is used to collect and store data in the binary file /var/adm/sa/sadd, where dd is the current
day. The arguments t and n cause records to be written n times at an interval of t seconds, or once if omitted. The following entries in
/var/spool/cron/crontabs/sys will produce records every 20 minutes during working hours and hourly otherwise:
0 * * * 0-6 /usr/lib/sa/sa1
20,40 8-17 * * 1-5 /usr/lib/sa/sa1
See crontab(1) for details.
The shell script sa2, a variant of sar, writes a daily report in the file /var/adm/sa/sardd. See the OPTIONS section in sar(1) for an
explanation of the various options. The following entry in /var/spool/cron/crontabs/sys will report important activities hourly during the
working day:
5 18 * * 1-5 /usr/lib/sa/sa2 -s 8:00 -e 18:01 -i 1200 -A
FILES
/tmp/sa.adrfl
address file
/var/adm/sa/sadd
Daily data file
/var/adm/sa/sardd
Daily report file
/var/spool/cron/crontabs/sys
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWaccu |
+-----------------------------+-----------------------------+
SEE ALSO
crontab(1), sag(1), sar(1), svcs(1), timex(1), iostat(1M), svcadm(1M), vmstat(1M), attributes(5), smf(5)
NOTES
The sar service is managed by the service management facility, smf(5), under the service identifier:
svc:/system/sar
Administrative actions on this service, such as enabling, disabling, or requesting restart, can be performed using svcadm(1M). The ser-
vice's status can be queried using the svcs(1) command.
SunOS 5.11 20 Aug 2004 sar(1M)