Prioritize queries MS SQL Server

I was advised on this page:

of a couple ideas on how to "set" the priority of a query in MSSQL or throttle a query so that it doesn't consume all available CPU and hard drive bandwidth.

MAXDOP apparently locks the query to use a single CPU, leaving the other(s) for other queries. Better than nothing.
Related Scribbles:
  • SQL Server

  • ID: 624
    Date Updated:
    2006-04-25 12:05:56
    Date Created:
    2005-05-19 14:19:50


     >> Leonard Chan's Homepage  >> Scribble Web  >> Prioritize queries MS SQL Server is hosted by Perceptus Solutions Inc.