Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2011-07-19 : 04:32:40
|
| I have a query that does use a lot of resources but is also not high priorityis there anyway to set a query as low priority and that it should use more then 30% of the cpu?as it's causing small high priority queries to fail |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-19 : 09:27:04
|
| Have a look at Resource Governor. |
 |
|
|
|
|
|
set query to use a maximum cpu