Limit CPU utilization

Hot Topic

Msg 6573 - method in assembly is not static - how do I make it static ?
.NET Framework 2.0 question
How to run package with variables using dtexec?
SQL MSDE HELP!!
IIS Internet Info Services
Deploying database with .NET assemblies?
EDB record limits and EDB vs RAPI
Upsizing Access to SQL Server 2005
Possible to assign for each CPU a different process within one SQL Server 2005 (multicore system)?
Avoiding deadlock

SQL Server

SQL SERVER & Coldfusion connection problem - server newbie
Setting Report Data Source Credentials Programmatically?
How to check if row exists...
Watermark Generation is Invalid Error
SQL Express Reporting Services
How to insert a lookup table row aftre lookup fails
How To: Deploy Packages to a subfolder under MSDB using deployment wizard
SQL Server Reporting Services - data extension 'XML'
navigation question
Reporting Services in SQL Express?

Limit CPU utilization

HI,

Is there any parameter on SQLSERVER to limit the utilization of the CPU.

I made a storeprocedure that has several Loops and when i execute it the processor stay's on 100 % for several minutes and this is blocking the server to the other applications. I would like to set the server so that SQLSERVER could not make use of 100 % of the CPU. Is possible to set a parameter on the SERVER or in the storeprocedure so that the CPU utilization would never be greater than x%

Thanks a lot

Jose Rocco




Answer this question

Limit CPU utilization

  • myDisplayName

    No. There is no resource governing feature in SQL Server that will allow you to control allocation of resources to server-side processes or TSQL commands etc. So you will have to simplify the code or modify it in such a way that you reduce the CPU requirement. If you are doing lot of procedural code then try to change them to set-based operations. You can also move some of the computations to the client side if required.

  • Limit CPU utilization
Answer this question