Application produces high CPU utilization

[pchan]

I am trying to troubleshoot a high CPU utilization problem when a job is send to a SQL server. It eats up 100 percent of the CPU when this job is running. What kind of utilities can I use to determine if this is a hardware or software issue.

Thanks,
Perry

 

[royjimenez]

what kind of computer u have like a server ? You have to see if u have enough memory and disk space.

the job is an application ?
'cause it's so, u can trace ( SQL TRACE ) the SQLs to see the performance every one.

Regards

 

[zhavic]

You can use 'Profiler' to determine what SQL server is doing.

Zhavic




---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.