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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-13 : 12:20:41
|
| Fred writes "Hi, I would like to know if there is a way to manage the processor activity and priority on either SQL 2000 or Windows NT4.0( my server ).What I would like to do is : when the processor is working under 20% for like 5 min or any time frame, launch a store procedure.My server is running on a transactionnal web site and need all of it's ressources, so when CPU load is low, I'd like to run heavy Store procedure that calculates and makes a lot of updates in the database.If it is not possible to trigger my store procedure on this kind of event- I dont want to make these operations live when each row is inserted- is there any recommendations?thanksFred" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-04-13 : 22:32:18
|
| I see a flaw with this idea man.....What happens when teh load gets heavy just after you kickoff your stored procs? Then both processes will run slow.Can you go into detail as to what this process is and what it does?Maybe we can help you make it run fast enough not to matter. There are a ton of realyl talented folks here. You'd really be surprised at some of the high performance solutions they come up with!Michael |
 |
|
|
|
|
|
Processor Time