Skip to Content
0
Oct 14, 2019 at 02:07 PM

sybase database cpu User Busy 100% poor performance in productive system

271 Views Last edit Nov 22, 2019 at 03:57 PM 2 rev

When the system is less visited ,my sysmon like :

Engine Utilization (Tick %) User Busy System Busy I/O Busy Idle

Engine 34 75.4 % 0.3 % 19.6 % 4.7 %

When the system is heavily visited,my sysmon like:

Engine Utilization (Tick %) User Busy System Busy I/O Busy Idle

ThreadPool : syb_default_pool Engine 0 100.0 % 0.0 % 0.0 % 0.0 %

This server has 64 CPU, 256 GB RAM .

Can anybody sujects what can be the problem?.

Attached I send you a txt about sp_sysmon "00:01:00"20191011.txt

Attachments

20191011.txt (83.9 kB)