Resource Governor Limits?

Question

Post reply

Resource Governor Limits?

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
May 11, 2016 at 8:57 pm

#327063

Comments posted to this topic are about the item Resource Governor Limits?
May 12, 2016 at 5:34 am

This was removed by the editor as SPAM

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

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

HappyGeek SSCoach Points: 18726 More actions · Answer 1

Good question thanks, never used this feature so learned something new.

...

Carlo Romagnano SSC-Insane Points: 22597 More actions · Answer 2

Carlo Romagnano

SSC-Insane

Points: 22597

May 12, 2016 at 2:56 am

#1878464

Great!

😉

Rune Bivrin SSCrazy Eights Points: 8438 More actions · Answer 3

Wouldn't this depend on whether the limit is set with MAX_CPU_PERCENT or CAP_CPU_PERCENT?

Just because you're right doesn't mean everybody else is wrong.

Richard Hendrick Valued Member Points: 53 More actions · Answer 4

Indeed. The "limit" in this question is ambiguous. I would assume the limit on CPU using resource govenor would be the hard cap limit, not the maximum gauranteed CPU.

Terje Hermanseter SSCarpal Tunnel Points: 4765 More actions · Answer 5

Yet another feature in SQL Server that we haven't used on any of our production servers.

Are there anyone out there that uses this feature frequently? I would imagine that people would rather add more resources to their servers instead of restricting resources for certain groups or individuals.

sipas Hall of Fame Points: 3828 More actions · Answer 6

Richard Hendrick (5/12/2016)
Indeed. The "limit" in this question is ambiguous. I would assume the limit on CPU using resource govenor would be the hard cap limit, not the maximum gauranteed CPU.

+1

daniel.plocinik Hall of Fame Points: 3288 More actions · Answer 7

Thank you Steve. Something I needed to learn today so I very much appreciate the question.

George Vobr SSCrazy Eights Points: 9914 More actions · Answer 8

sipas (5/12/2016)
Richard Hendrick (5/12/2016)
Indeed. The "limit" in this question is ambiguous. I would assume the limit on CPU using resource govenor would be the hard cap limit, not the maximum gauranteed CPU.
+1

+1, but thanks Steve for an interesting question.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 9

Steve Jones - SSC Editor

SSC Guru

Points: 734418

May 12, 2016 at 8:05 am

#1878674

Good points, clarified the question.

webrunner SSC-Dedicated Points: 31713 More actions · Answer 10

Great question. Bob is always causing trouble with the SQL Server.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

Meaning limiting the CPU to 25% with MAX_CPU_PERCENT has no effect & was ignored somehow!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 12

Terje Hermanseter (5/12/2016)
Yet another feature in SQL Server that we haven't used on any of our production servers.

Me neither.