Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Time of query execution much different between 3 servers
Operating Systems AIX Time of query execution much different between 3 servers Post 302964175 by bakunin on Monday 11th of January 2016 05:52:17 PM
Old 01-11-2016
Quote:
Originally Posted by omonoiatis9
I am trying to figure out what causes this extra delay during these hours but i cannot find anything. I tried to check the crons to see if there is something automatic that runs during these hours that is causing the delay but i dont think my answer is there.
What makes you think the answer is not in the crontabs? (The question is meant serious, what haveyou done to come to that conclusion?)

You might want to start with the basic tool for all things performance: vmstat. Use
Code:
vmstat -tw 1 | tee -a /some/log/file

and analyse the log. See if there is any significant difference between the first 5-6 minutes of an hour and the rest of the time. See if there is a difference between the first 5-6 minutes of the hour on server3 and the other two servers.

I hope this helps.

bakunin
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check query execution to go further

Can any one help with script (Korn) to do following ? :confused: I have 3 tasks to do in a shell. Task (1) is executing query which unloads the result into file XYZ. Before I start Task (2) which is java program and depends on file XYZ, I need to make sure that Task (1) is completed... (1 Reply)
Discussion started by: cub
1 Replies

2. Programming

execution time

hi , i ve coded a C program in that im using malloc dynamically , it is being called many times in the program The program is to simulate jobs in manufacturing system. the execution time is increasing drastically as the number of jobs are increased. could any body tel what may be the problem... (2 Replies)
Discussion started by: ramki_rk
2 Replies

3. UNIX for Dummies Questions & Answers

last execution time

is there a command in Solaris 8 that will show a particular scripts last execution time? (1 Reply)
Discussion started by: cubs0729
1 Replies

4. UNIX for Advanced & Expert Users

specifying an execution time

Hi all, do ny o u'll know how to set a particular execution time for a program??? for eg.: --> during the execution of a file, i call a certain other function. --> while calling this function, my comp hangs. now is there ny way in which i can go to the nxt line of code by aborting the call... (7 Replies)
Discussion started by: VGR
7 Replies

5. Shell Programming and Scripting

To reduce execution time

Hi All, The below script I run daily and it consumes 2 hours approx. In this I am calling another script and executing the same twice. Is the loop below the cause for the slow process?Is it possible to finetune the program so that it runs in a much faster way? The first script: #!/bin/ksh... (4 Replies)
Discussion started by: Sreejith_VK
4 Replies

6. HP-UX

Automatic execution of commands in multiple servers using single script.

Hi, I've to do a simple job many times whenever it has been asked, just i've to log in to all of fourtien HP servers and i've to execute ps -fu user > temp cat temp|sendmail "xyz@z.com" commands to send the statics of all of 14 servers over the mail to particular user id.. Though logging... (4 Replies)
Discussion started by: vickramshetty
4 Replies

7. UNIX for Dummies Questions & Answers

time taken for execution

how much time a particular command or shell script executed there is any command to know this thanks (5 Replies)
Discussion started by: tsurendra
5 Replies

8. Solaris

Remote execution of a local script on multiple servers

So I have a scriptlet called solaris_command: for i in \ server1 server2 server3 do echo $i ssh $i $1 echo "" done I then use that as a command in multiple scripts to allow for data gathering for all virtual hosts in the environment thusly: solaris_command "cat... (3 Replies)
Discussion started by: os2mac
3 Replies

9. Homework & Coursework Questions

Parallel execution on multiple servers in UNIX

I have a requirement (in a shell script) to connect to several servers at once and execute a series of commands. I am aware that ssh can be used for sequential execution. But since most of the commands that I need to execute take a long time, I have to go for the parallel option. Is there... (2 Replies)
Discussion started by: sneha1887
2 Replies

10. Shell Programming and Scripting

To take script execution time

Hello Guys, I would like to know is there a way to take the script execution time For e.g i am having a script.sh i need to write inside he script.sh like Start time : 10-Mar-2016 02:30:35 all code over here ... End time : 10-Mar-2016 03:30:32 Script start time - 02:30:35 ... (7 Replies)
Discussion started by: Master_Mind
7 Replies

LEARN ABOUT DEBIAN

pwrkap_aggregate

pwrkap_aggregate(8)						   User Manuals 					       pwrkap_aggregate(8)

NAME

       pwrkap_aggregate - Present a large number of pwrkap servers as if they were one

SYNOPSIS

       pwrkap_aggregate config_file

DESCRIPTION

       pwrkap_aggregate  is  a	daemon that connects to a multitude of pwrkap servers and power control domains, and presents them as if they were
       one server with a smaller number of domains.  By aggregating pwrkap server instances, it is possible to monitor many thousands  of  servers
       without	overworking the command console.  It is also possible to give identical class designations to a group of pwrkap servers and manage
       them as an aggregate.

OPTIONS

       config_file
	      Text file mapping pwrkap servers to aggregated domains.  See pwrkap_aggregate(5) for information about the config file format.

AUTHOR

       Darrick J. Wong <djwong at us dot ibm dot com>

SEE ALSO

       pwrkap_gtk(1), pwrkap_cli(1), pwrkap_aggregate(5), pwrkap_main(8)

Linux								   January 2009 					       pwrkap_aggregate(8)
All times are GMT -4. The time now is 01:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy