Sybase IQ Monitoring

[Former Member]

Hi Team,

I an doing a Sybase Monitoring setup now  in our new Landscape  , I am bit confused with Results from Stored Procedure ,

For Example I used below Query for Memory :

sp_iqsysmon '00:00:1', 'memory' ;

'STATS-NAME               ','VALUE                    ','','','','','','','','','','','','','','','','','','','','','','','','','',''

'MemAllocated             ','31697086712      (30954186 KB)','','','','','','','','','','','','','','','','','','','','','','','','','',''

'MemAllocatedMax          ','32079760856      (31327891 KB)','','','','','','','','','','','','','','','','','','','','','','','','','',''

'MemAllocatedEver         ','36008            (     35 KB)','','','','','','','','','','','','','','','','','','','','','','','','','',''

'MemNAllocated            ','535547          ','','','','','','','','','','','','','','','','','','','','','','','','','',''

'MemNAllocatedEver        ','61              ','','','','','','','','','','','','','','','','','','','','','','','','','',''

'MemNTimesLocked          ','0               ','','','','','','','','','','','','','','','','','','','','','','','','','',''

'MemNTimesWaited          ','0       (   0.0 %)','

What does this value means , Is there a place i can get current Memory and CPU usage of the System .
Is there a system view for this , Or one among the printed status is answer for My question

At OS level , I didn't see any matching value for the status here .

Is there some System views or SP's that can help in monitoring setup .

Thanks,

Raza

[Former Member · Accepted solution]

Raza,

Refer :- SyBooks Online

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00169.1520/html/iqperf/BA...

If you look at Parent topic 'Performance Statistics' it has all information.

Regards,

Abhi

[Former Member · Accepted solution]

Hi Abhi,

This really helped me

Thanks,

Razal