sp_sysmon or sysmonitors -
07-28-2004
, 07:06 AM
Hi all,
I have been monitoring a sybase server using sp_sysmon from last
few weeks,
but as it is said that using sp_sysmon results into 5%-7% overload on
the sybase
server I have been facing some problems. I have studied that sp_sysmon
just resets all the counters and fetches all the data from sysmonitor
table.
Instead of firing sp_sysmon if I fetch the required data from
sysmonitors,will it result in any performance overloading.
I would also like to know that whether the values of
sysprocesses,sysusages etc get reseted after periodic interval.
Thanks in advance.
Regards,
Shweta |