[Resolved] Is Stored Procedure using CPU?

[naruponk]

Hi, there

I'm using stored procedure that are used to calculate commission.
Task manager shown as PF usage is not increased
but CPU usage is increasing up.

How can I use other server or computer to share a CPU for thease stored procedure?

Any idea?

[mendhak]

Is your query really that enormous? Is the CPU usage really that high? Because that'd be one incredible query... since SQL Server, on a single instance, can handle a very large load by itself. However, you do have the option of SQL Server Load Balancing

[szlamany]

Do you have SQL installed locally - or is it on another server already?

Seems from your question that you could put it on another server - why not just do that.

If you are so concerned about CPU it should be on a dedicated machine.

[naruponk]

CPU usage is around 95-98% when run it.
Is load balancing able to get it faster?

Now, I have only one server that installed SQL Server on this server.

Do you have any suggestion?

[szlamany]

Do you have SQL installed locally - or is it on another server already?

You didn't really clearly answer this question.

If this SERVER you have SQL on a dedicated server? What else is running on this box at the same time?

[naruponk]

There is nothing to run at the same time,
I'm not sure that am I answer clear or not, if not please let me know.

Thanks for help

[szlamany]

Then why is the CPU usage bothering you?

I would want my hard-running queries that need lots of resources to get them - if the CPU hits 95% when a big query runs then that's a good thing.

What is it interfering with?

[naruponk]

Do you mean I'm good that create query which is using CPU nearly 100% ?
If so, how can I get it faster?

[szlamany]

A CPU only has so much horsepower...

Go into taskmgr (Task Manager) and go to the PROCESSES tab and click on the CPU column - to sort that column. Sort it so the highest CPU %-age job is at the top.

My PC shows "System Idle Process" usually at the top - unless of course I am running something intensive - like a virus scan, for instance.

When I run that virus scan I would like to see the "System Idle Process" disappear - so that as much available CPU is given to that task.

I also want other tasks that might want to run at the same time as the virus scan, for example, to get a fair share of CPU when they need it.

I would only be concerned if those other tasks were noticeably delayed by the virus scan. I would hope that the job scheduler would make sure to divide up resources appropriately.

Where do you expect to get more CPU out of?

If you want us to review your query to see if it can be made quicker - in other words - take less resources - we can do that.

[naruponk]

Thanks a lot for your reply,
You make me clear about this.