Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Resource Governor question

12 views
Skip to first unread message

Richard

unread,
Jul 19, 2011, 4:42:59 PM7/19/11
to
It was suggested that I enable the Resource Governor to prevent any of
our adhoc power users from bringing the server to it's knees. If I'm
reading the documentation right you can use it to limit I/O, rows
returned, elapsed time, or tempdb pages, but not CPU. It also forces
you to name either the user OR the application that you want to
limit. I was hoping to set upper limits for any user from any
application. Is something like that possible. My concern is that a
power user could start using some new client application that the
Governor won't be configured for, so they won't be limited, or a new
power user gets added that isn't configured.

Thanks.

0 new messages