Process Throttling

A customer asked me at a recent TechNet Briefing:
"Are there “process throttling” capabilities? [Other database products]
have a way to watch for processes that run out-of-control…taking up too many
resource (CPU, Memory) from the rest of the system. I don’t see a way to do
it in 2000. If it's not there, will 2005 have a solution to this?"
Thanks
Kevin Remde
IT Pro Evangelist
Microsoft Corporation
Hi
sp_configure's 'query governor cost limit' can limit the time a quyery runs.
In terms of using other resources, they are ungoverned, even with SQL Server
2005.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kevin Remde" <KevinRemde@.discussions.microsoft.com> wrote in message
news:A31687BA-155C-47F1-A5CF-538364183408@.microsoft.com...
>A customer asked me at a recent TechNet Briefing:
> "Are there "process throttling" capabilities? [Other database products]
> have a way to watch for processes that run out-of-control.taking up too
> many
> resource (CPU, Memory) from the rest of the system. I don't see a way to
> do
> it in 2000. If it's not there, will 2005 have a solution to this?"
> Thanks
> Kevin Remde
> IT Pro Evangelist
> Microsoft Corporation