limit the cpu usage by query

  • Hi,

    we are using sql server 2005. We have some queries that will take long to complete. When the user is running these queries, we can see that the cpu usage almost reaches 100%. so in that time if another user is trying to run another query which would take less amount of time usually, now it will take longer to run. so we are wondering if there is a way to specify the percentage of cpu usage inside a stored procedure. In that way we can limit the long running queries' cpu usage.

    Please let me know.

    Thanks,

    sridhar.

  • Sridhar (4/9/2008)


    Hi,

    we are using sql server 2005. We have some queries that will take long to complete. When the user is running these queries, we can see that the cpu usage almost reaches 100%. so in that time if another user is trying to run another query which would take less amount of time usually, now it will take longer to run. so we are wondering if there is a way to specify the percentage of cpu usage inside a stored procedure. In that way we can limit the long running queries' cpu usage.

    Please let me know.

    Thanks,

    sridhar.

    You cannot limit the percentage of CPU use by a procedure or session in SQL 2005. SQL 2008 however, is supposed to have this ability.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Take a look this link. Maxdop may be an option. Test it first.

    http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/

  • Take a look your SQL server configuration. This recent KB may help:

    http://support.microsoft.com/kb/329204

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply