Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Units for Sybase Monitoring

14 views
Skip to first unread message

Rajeev

unread,
Feb 29, 2012, 4:01:25 AM2/29/12
to
Hi Guys,
Could any one help me on the following:
1) sp_monitorconfig "max memory" gives values for the following
Num_free
Num_active
What is the units used here? Are thes in bytes/kilobytes.
2) In Sybase MDA tables,
monDeviceIO table has the following columns:
-Reads
-Writes
-APFReads
Are these values bytes per second?
Total DiskIO = Reads+Writes+APFReads
Total Disk Reads = Reads
Total Disk Writes = Writes from this table, is this calculation
correct?
3) Is the following formula correct for calculating Cache Miss Ratio
select "Miss_Ratio (%)" = convert(numeric(10,1),
((m.PhysicalReads*1.0/m.CacheSearches*1.0))*100.0) from monDataCache m

4)Is the following formula correct for calculating total db size?
select sum(((d.high - d.low) + 1) * @@maxpagesize/1048576) as
totalsize from sysusages u, sysdevices d where u.vstart between
d.low and d.high

Appreciate your help. I have tried various options and couldn't find
any reliable source to clarify my queries.

Thanks,
Rajeev









Thanks,
Rajeev
0 new messages