Keeping the CPU load to 50%

Hi,
I have a stored procedure which does intense calculations. It does
calculations against millions of records and when it is executed the CPU
performance goes up to 100%. Is there a way in SQL queries which specifies
that CPU performance should not go beyond 50% for that particular stored
procedure.
thanks in advance for your help.
Bhagwati
If it is so critical , consider buying a new processor ( if it keeps
getting 100% for 10-20 min)or optmize the query
"Bhagwati" <Bhagwati@.discussions.microsoft.com> wrote in message
news:2E9E6FA1-7CCC-459E-825A-55A162D6F9F7@.microsoft.com...
> Hi,
> I have a stored procedure which does intense calculations. It does
> calculations against millions of records and when it is executed the CPU
> performance goes up to 100%. Is there a way in SQL queries which specifies
> that CPU performance should not go beyond 50% for that particular stored
> procedure.
> thanks in advance for your help.
> Bhagwati
|||No you can not limit any thread to a certain percentage of the resources
without killing it altogether. You might want to consider upgrading to
SQL2005 and look at doing the calculations in a CLR sp or UDF. The CLR can
usually do complex calculations hundreds or even thousands of times faster
than SQL Server.
Andrew J. Kelly SQL MVP
"Bhagwati" <Bhagwati@.discussions.microsoft.com> wrote in message
news:2E9E6FA1-7CCC-459E-825A-55A162D6F9F7@.microsoft.com...
> Hi,
> I have a stored procedure which does intense calculations. It does
> calculations against millions of records and when it is executed the CPU
> performance goes up to 100%. Is there a way in SQL queries which specifies
> that CPU performance should not go beyond 50% for that particular stored
> procedure.
> thanks in advance for your help.
> Bhagwati