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 |
|
cblatchford
Starting Member
40 Posts |
 Posted - 2005-11-04 : 05:07:10
|
Hello all, I'm a newb so I'm still working my through the wealth of information on here, so apologies if this has been covered already ! So here goes.. Is there any way of prioritising queries/sp's to dynamically start, pause and stop based on cpu usage? For example, if cpu usage falls below 10% then the query/sp starts, but if cpu usage exceeds 10% then it pauses, but does not stop/cancel, then carries on when the cpu usage is back below 10%, a sort of intelligent query.Thanks and look forward to feedback! Blatcho |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-11-04 : 09:57:20
|
| Have you looked a scheduled jobs? You can start one when the cpu is idle...Can you explain to us what you are trying to do..."pausing" a query or sproc doesn't make much sense...you need to think in terms of transactions...Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
|
|
|
Stored Procedure Priority