I was advised on this page: http://tek-tips.com/viewthread.cfm?qid=1063611&page=1

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
Author:
leonard
Date Updated:
2006-04-25 12:05:56
Date Created:
2005-05-19 14:19:50

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> Prioritize queries MS SQL Server

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.