on 04-09-2014 3:49 AM
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
Raza,
Refer :- SyBooks Online
If you look at Parent topic 'Performance Statistics' it has all information.
Regards,
Abhi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.