Skip to Content
0
Former Member
Apr 09, 2014 at 02:49 AM

Sybase IQ Monitoring

255 Views

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