Unanswered: Very high CPU utilisation and processes are sleeping
I am using ASE 12.0 on Solaris 10 after the OS patch application (Jan 2008 patch) sybase ASE performance has become very poor. sp_monitor shows CPU utilisation is going very high ~ 98% continuously and sp_who gives most of the process are in sleep, sync sleep , recv sleep.
Before applying the OS patch the cpu utilisation use to be only 15% - 20% only.
Any pointers / help to resolve the issue are highly appreciated.