cancel
Showing results for 
Search instead for 
Did you mean: 

How to get top 5 processes wich are eating max CPU usage in Sybase IQ

Former Member
0 Kudos

How to get top 5 processes which are eating  max CPU usage in Sybase IQ ...

Thanks

Ajay Pandey

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Any suggestion ...

markmumy
Advisor
Advisor
0 Kudos

IQ does track CPU utilization per connection at the server.  You can capture CPU usage from the HTML query plans.

One correlation, though not perfect, would be to look at the total number of threads that each connection is consuming.  Usually, more threads means more CPU usage.

Mark

Former Member
0 Kudos

Thanks Mark . I already tried umber of thread  from  sp_iqconnection . Thought there should some way to get  CPU usage like in ASE (sysprocesses.cpu) for from MDA tables ..