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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2010-08-01 : 04:38:31
|
| It looks like a very simple way to set the cost limit by way of seconds for the time taken to run a query or by rowcount?This has been a problem for me in the past when I run something overnight taking many hours and running out of resources completely, and causing ridiculous trouble preventing several scheduled processes...Maybe it's subjective do decide on a server policy on which query to limit, but this seems to just not work, at all? If I do something simple like a table scan which takes about 3 minutes, and a good test because it doesn't get indexes to kick in and run from a cache, taking less than a second, this repeatedly takes 3 minutes, each time. Also 10,xxx,xxx rows in 5:52However, if I set the query governor on the server properties --> Connections OR the Tools menu --> Options... query execution area to 10 seconds in ..COST_LIMIT, it all just keeps running the usual time. So that makes this completely useless!What can you tell me about that?ThanksMike |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-08-01 : 04:44:54
|
| OKI see it's about Resource Pool in Management... I was barking up the wrong tree googling this stuff from 2000 old stuff? |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-08-01 : 04:50:20
|
| Still doing exactly the same thing, though! Lovely window, but simply change CPU time from 0 to 5 sec, and off it goes... 5 minute execution until it's finished!There must be subtle bits to setting this, so I'm waiting on your expert advice... |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-08-01 : 05:17:39
|
| My reconfiguration is pending.... great. That would be wonderful, waiting for that to achieved, while queries run crazy, crashing the system... |
|
|
|
|
|
|
|
|
Query Governor