Rajeev
unread,Feb 29, 2012, 4:01:25 AM2/29/12You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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