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 |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2009-09-01 : 11:09:08
|
| I have a nasty Stored Proc that takes 10+ min. It slows down the server when I run it i.e. CPU. I am in no BIG hurry to get the results and I'd rather not bother the other users by slowing down the server. Is there a way to run a query in a low priority mode, which even though would take longer, would put less stress on the Server? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-09-01 : 19:32:15
|
| If you place your query inside a SQL job, you can explicitly define when it runs (2:00AM) or configure it to run "when the CPU is not busy".=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
|
|
|
Low Priority Query