Post reply

Is it possible to limit the resource utilization for a particular process running on MSSQL database

  • January 19, 2010 at 3:18 pm

    #144366

    Hi All,

    Please provide your inputs whether we can limit resource utilization for a particular process running on MSSQL database.

    TIA

  • January 19, 2010 at 4:41 pm

    #1105777

    This cannot be done in SQL 2005 but can be done in SQL 2008 Enterprise Edition using the Resource Governor.

  • January 19, 2010 at 10:04 pm

    #1105824

    If the "process" is controlled by a stored procedure or set of stored procedures, you can do things like setting OPTION(MAXDOP 1) to help the situation a bit. Of course, that's a code change but not a serious one. Still may not help on memory or I/O if it's bad code (and it very likely is). Of course, properly identifying and fixing the bad code would alleviate the problem altogether. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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