Resource Governor

Question

Resource Governor

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
July 17, 2008 at 8:30 pm

#63463

Comments posted to this topic are about the item Resource Governor

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Vivien Xing SSChampion Points: 12297 More actions · Answer 1

Is the answer right? or is this the answer for this question?

"Resource management is limited to the SQL Server Database Engine. Resource Governor can not be used for Analysis Services, Integration Services, and Reporting Services."

http://msdn.microsoft.com/en-us/library/bb895232(SQL.100).aspx

Vivien Xing SSChampion Points: 12297 More actions · Answer 2

I mean the explanation does not match the question & answer.

Iggy-SQL SSCarpal Tunnel Points: 4169 More actions · Answer 3

BOL says:

Resource management is limited to the SQL Server Database Engine. Resource Governor can not be used for Analysis Services, Integration Services, and Reporting Services.

So why is "Reporting Services, Integration Services, Analysis Services" answer correct? Am I missing something or misinterpret the BOL?

Urbis, an urban transformation company

Nick Beagley Ten Centuries Points: 1349 More actions · Answer 4

I wasn't suprised when I got it wrong, selecting only Database Engine, since I didn't know and couldn't envisage how it would work for those other services. I still can't.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 5

Sorry, wrong tick on the answers. This has been corrected and points awarded back.

Iggy-SQL SSCarpal Tunnel Points: 4169 More actions · Answer 6

Thanks Steve!

Urbis, an urban transformation company

Hari.Sharma SSCertifiable Points: 6904 More actions · Answer 7

Which components of SQL Server 2008 can the Resource Governor operate on? (select all that apply)

But there are radio button to select the answer. Then what does it mean by (select all that apply)

Cheers,
Hari
Tips & Tricks for SQL BI Developers

Anipaul SSC-Insane Points: 24681 More actions · Answer 8

Anipaul

SSC-Insane

Points: 24681

July 18, 2008 at 2:48 am

#844858

Good question....:)

Steven Cameron SSCrazy Points: 2903 More actions · Answer 9

Lighten up people. Being so stressed out will take years off your life. There's enought stress in our work lives. Is the answer to a QotD worth losing out on one more day of life?

Dariusz Czechowicz-474456 SSC Enthusiast Points: 128 More actions · Answer 10

"Select all that apply" means that it is a multiple choice question.

So there should be check boxes instead of radio buttons.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 11

Steve thanks for a good question. It introduced myself and I imagine many others to a new or little know facet of SQL Server 2008 and in that way the question met the basic objective of the QOD.

Of the tool itself it will further complicate the life of DBAs, database developers and designers. One more tool with a lot of complexity to using it correctly. I only wish that it would have been designed to work with Reporting Services so that when the "big boss" demanded a report NOW, he/she could be accommodated so as look fondly on those in IT when it came the time to passing out pay increases.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 12

you're welcome and we're trying to sprinkle in some 2008 ones for more information.

the "Select all" has been removed.