Show session speed real time TSM

I find with google search this query :

select char(client_name,10) as “Sess”,CAST(CAST(bytes_received/1024/1024 as decimal(15,0))/CAST((current_timestamp-start_time)seconds as decimal(15,0)) as decimal(10,2)) as “Receive [MB/s]”,CAST(CAST(bytes_sent/1024/1024 as decimal(15,0))/CAST((current_timestamp-start_time)seconds as decimal(15,0)) as decimal(10,2)) as “Sent [MB/s]” from sessions where session_type=’Node’

output:

Sess             Receive [MB/s]       Sent [MB/s]
———–     —————     ————-
KELLY                   4193.64              0.00
KELLY                      0.00              0.00

Show session speed real time TSM

How to mange controller raid with MegaCli over vmware esxi

xseries 2350 M4  + vmware esxi 5.1
Donwload megacli software from ibm site

How to install?

You need have active ssh connection to the esxi server 
Install to esxi server :

esxcli software vib install /tmp/vmware-esx-MegaCli-8.04.07.vib –no-sig-check

(The installation probably need put the host in manintenece mode and reboot server)

How to use?

Go to /opt/lsi/MegaCli/ and run ./MegaCli with option :

Check the status all of HD:

./MegaCli -PDList -aALL

or single HD

./MegaCli -PDInfo -PhysDrv [E:S] -aALL          (E is the enclosure and is the slot)

Download the log of controller:

./MegaCli -AdpEventLog -GetEvents -f events.log -aALL && cat event.log

Show info configuration:

./MegaCli -AdpAllInfo -aALL

Show controller configuration:

./MegaCli -CfgDsply -aALL

Battery status:

./MegaCli -AdpBbuCmd -aALL

Show rebuild status:

./MegaCli -PDRbld -ShowProg -PhysDrv [E:S] -aALL

And more info:

./MegaCli -h

 
How to mange controller raid with MegaCli over vmware esxi