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 |
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
 Posted - 2010-04-15 : 02:57:09
|
| Hi,Is this possible to configure the execution of a Stored Procedure with low priority. I mean, this SP updates the info for a high volume data but it doesn't matter if takes long time...Thanks in advance.The Padrón peppers itch and other don't |
|
|
Asken
Starting Member
38 Posts |
Posted - 2010-04-15 : 03:08:44
|
The Resource Governor will do the trickhttp://msdn.microsoft.com/en-us/library/bb933866.aspxUnfortunately you'll need to have the Enterprise edition so if you don't, I'd think you're out of luck.
Reporting & Analysis SpecialistHelping others helps me get better... |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-04-15 : 03:25:08
|
It also depends on the type of procedure, what it does.You can probably do the things in smaller batches. For example if you want to update a column, you can do that for 1000 records at a time (repeat until all done), instead of updating all records at once.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
Posted - 2010-04-21 : 12:20:53
|
| Thank you!1.-Yes, that works only in enterprise edition.2.-I am doing this in small batches.The Padrón peppers itch and other don't |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-21 : 12:55:39
|
quote:
Originally posted by cidmi.dovic
2.-I am doing this in small batches.
Put a WAITFOR for a second, or so, between batches? |
|
|
|
|
|
|
SP Execution with low priority