Login or Register to Ask a Question and Join Our Community


Solaris

Need to know IO usage in Solaris

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Solaris Need to know IO usage in Solaris
# 1  
Old 08-06-2013
Need to know IO usage in Solaris
Morning,

i am in a bit situation where in i don't know what is causing the same run to hit different time to complete

Example:
1st run took about an hour to finish and the second took around 30 - 45 mins to complete.

by the way i am executing a stored procedure using sybase.

Code:
  r/s    w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
    0.0    1.6    0.0    7.2  0.0  0.0    0.0    4.7   0   1 sd0
    0.0    1.6    0.0    7.2  0.0  0.0    0.0    4.4   0   1 sd1
    0.4    0.0   12.8    0.0  0.0  0.0    0.0   10.3   0   0 ssd6
    0.8    0.0   25.6    0.0  0.0  0.1    0.0   91.2   0   7 ssd8
    0.4    0.0   12.8    0.0  0.0  0.0    0.0   10.4   0   0 2/md10
    0.4    0.0   12.8    0.0  0.0  0.0    0.0   10.4   0   0 2/md100
    0.8    0.0   25.6    0.0  0.0  0.1    0.0   91.2   0   7 3/md10
    0.8    0.0   25.6    0.0  0.0  0.1    0.0   91.2   0   7 3/md100
    0.8    1.0   38.4    4.8  0.0  0.0    0.0    4.3   0   0 9/md10
    0.0    7.6    0.0   60.8  0.0  0.1    0.0   12.6   0   4 11/md3
    0.0    7.6    0.0   60.8  0.0  0.1    0.0   12.6   0   4 11/md300
    2.4    1.2   38.4   19.2  0.0  0.0    0.0    1.1   0   0 11/md1
    0.8    1.0   38.4    4.8  0.0  0.0    0.0    4.3   0   0 9/md101
    0.8    0.4   12.8    6.4  0.0  0.0    0.0    4.0   0   0 13/md10
    0.8    0.4   12.8    6.4  0.0  0.0    0.0    4.0   0   0 13/md100
    0.8    1.0   38.4    4.8  0.0  0.0    0.0    4.3   0   0 ssd14
    0.2    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0 ssd15
    0.2    0.0    0.0    0.0  0.0  0.0    0.0    0.0   0   0 ssd19
    0.0    7.6    0.0   60.8  0.0  0.1    0.0   12.6   0   4 ssd20
    2.4    1.2   38.4   19.2  0.0  0.0    0.0    1.1   0   0 ssd23
    0.8    0.4   12.8    6.4  0.0  0.0    0.0    4.0   0   0 ssd39

Please help
# 2  
Old 08-06-2013
if the 1st and 2nd runs were done exactly the same way -- same userid, same command, same parameters, same database, etc. -- you could look at the server load at during the 1st run and also check what else was running at that time that was not running during the 2nd run ...

if there was a difference in the way the 2 runs were done, you could still follow the same process as described above but then you have to account for the differences in the runs themselves ... as an example, a manager that has access to a sales database would have access to his individual team members' database profiles while those team members would only have access to their own profiles ... this would naturally make the manager's report to run longer than each team members' reports ...
# 3  
Old 08-06-2013
I am running the same stored procedure multiple times, but i am getting different output when it comes to time completion. Below are the different elapse time:

Code:
FIRST RUN
TRD extract finished, time elapsed: 239 minutes

Code:
SECOND RUN
TRD extract finished, time elapsed: 4 minutes

Code:
SUCCEEDING RUN
2013-08-04 20:58:39.053	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 4 minutes
2013-08-02 03:27:00.233	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 65 minutes
2013-08-02 02:06:52.77	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 44 minutes
2013-08-01 23:36:43.293	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 62 minutes
2013-08-01 05:00:22.307	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 62 minutes
2013-08-01 02:44:22.15	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 48 minutes
2013-08-01 01:50:31.75	usp_art_odi_trade_extract	TRD extract finished, time elapsed: 35 minutes

is there a way for me to trace the io usage for this particular process that i am using?
# 4  
Old 08-07-2013
use strace, lsof or truss -- depending on your os -- to track the application run ... if you have enough disk space, you can redirect the outputs of your strace/lsof/truss into files that you can analyze further ...
# 5  
Old 08-07-2013
I am using Sun Solaris 10. Is there any other command which could output IO used by SYBASE ASE?

Thanks,
# 6  
Old 08-07-2013
see man truss
# 7  
Old 08-07-2013
If your disk are in a external Storage, check if your server is sharing the Storage Port with another server.

May be the another server or servers run process that use intensive IO and affect the original server if use the same Storage Port
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

How to find out the memory usage in Solaris?

Hi All, In one of the solaris box aslert got triggered as ... (Used_Real_Mem_Pct=93.0 Used_Swap_Space_Pct=75.0 )] when i see the usage by vmstat and sar i am not able to relate the alert with the free memory and swap memory please help to understand the vmstat output as below.. kthr ... (4 Replies)
Discussion started by: Riverstone
4 Replies

2. Solaris

Solaris memory usage

One of my Solaris Unix server has total RAM 128G . top & vmstat command shows free memory is 86G and usage is 42G. ps -eo pid,rss,commshows memory usage by process. when i sum all the memory usage by the process, it shows 1.9TB as shown below. $ ps -eo pid,pmem,vsz,rss,comm | sort -rnk2 |... (5 Replies)
Discussion started by: baladelaware73
5 Replies

3. Solaris

Solaris Memory usage by oracle, java

Hello Gurus, In Office, I have unix Solaris Server. Oracle and Java is installed on Solaris Server. Oracle when starts then oracle loads SGA, PGA memory and graps solaris server memory. In the same manner java and other applications grabs memory for them. I want memory distribution of... (4 Replies)
Discussion started by: get_chandrakant
4 Replies

4. Solaris

Memory usage in a Solaris Container

Hi All, We have a server with Solaris 10 installed. The total memory of the server is 64GB. In order to check the memory info of the server I use "top" utility that gives me total and free memory in real-time. I have also installed a Sun container (non-global zone) on top of parent operating... (4 Replies)
Discussion started by: Slayer
4 Replies

5. Solaris

Oracle memory usage on Solaris box

I am working on Oracle 2 node RAC 10.2.0.4 on Solaris 10 T2000 kit. The box has around 32G of memory of which 24G is used by oracle user. There is 3G of free memory on the box. Sga max is set to 5G and while checking v$pgastat i see that maximum pga memory memory allocated was 6.5G. So oracle... (29 Replies)
Discussion started by: prabumohan
29 Replies

6. AIX

How to monitor the IBM AIX server for I/O usage,memory usage,CPU usage,network..?

How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies

7. HP-UX

how can I find cpu usage memory usage swap usage and logical volume usage

how can I find cpu usage memory usage swap usage and I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times my final destination is monitor process logical volume usage above X % and number of Logical voluage above can I not to... (3 Replies)
Discussion started by: alert0919
3 Replies

8. Solaris

pstack usage on Solaris 9

Hello everyone, I have a 12-thread application running on Solaris 9. When I use the pstack command after a typical core dump, it prints the stack output of all 12 threads/lwps. This is the standard procedure as it is described in the Solaris MAN pages. Is there a way to filter out the... (1 Reply)
Discussion started by: gregb32
1 Replies

9. Solaris

Solaris Disk Usage

Disk Usage : I need a script which can help me in Following ways: 1) Input the Path where you want to find Usage Stats Suppose I enter /var/tmp 2) It Should list the partition in which its mounted, Percentage Used and Available and Users who are using the Maximum Space(in MB) with the... (1 Reply)
Discussion started by: sriram003
1 Replies

10. Solaris

Process CPU usage in Solaris 10

Hi All, Please let me know the command (expect top) to view the cpu usage of every process in Solaris 10. Thanks in Advance, Arun (1 Reply)
Discussion started by: arun.viswanath
1 Replies
Login or Register to Ask a Question