Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Manage server memory via Resource Governor/WSRM vs SQL server Properties


Manage server memory via Resource Governor/WSRM vs SQL server Properties

Author
Message
c4ntaloop
c4ntaloop
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 81
Hi,

I am very new to dba and I have question about managing min/max server memory.

What would be the reason of configuring server memory via Resource Governor instead of via SQL properties page? What is the benefit over each other?

However, it does make sense though when configuring the CPU consumption via Resource Governor as Properties page does not offer the functionality.

Can anyone please shed a light, will be much appreciated.

Thanks.
MarkusB
MarkusB
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4457 Visits: 4208
What would be the reason of configuring server memory via Resource Governor instead of via SQL properties page? What is the benefit over each other?


Configuring the max\min server memory is for the whole instance, while resource governor is used to limit user connections. You may want to limit the max server memory when you have more than one instance or in case that other applications are running on the same machine.
Resource governor is useful when you want to limit the resource used by certain user connections g.e. a reporting system.

Also remember the percentages you assign through resource govenor are a percentage of the max memory, not the physical memory in the machine.

Markus Bohse
c4ntaloop
c4ntaloop
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 81
Thanks Markus, however I am still not clear.

When configuring max memory from Resource Governor, we specify the max percentage in resource pool. Definition of resource pool taken from msdn website is, it represents a subset of physical resources available to DB Engine instance. So, I think it's the opposite of your explanation that Resource Governor percentage is not from physical memory.

Can you please clarify further.

Thanks
MarkusB
MarkusB
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4457 Visits: 4208
Sorry If I wasn't clear enough but what I meant is this:
c4ntaloop (7/8/2013)
Definition of resource pool taken from msdn website is, it represents a subset of physical resources available to DB Engine instance.

That means it's a subset of the resources you defined by setting the max memory for the instance (plus some other settings like CPU affinity.)

When I wrote that's not the same as the physical memory, I actually meant the available RAM in the machine.
Let's say you have a server with 32Gb of RAM and you set the max memory for the instance to 25GB, a 20% RAM limit in Resource Governor would be 5 Gb

Markus Bohse
c4ntaloop
c4ntaloop
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 81
Ah its making sense now, thanks Markus for explaining. I misunderstood that part.

If I can put in different scenario, if we don't specify the max server memory (leave to default), max percentage in Resource Governor would be the percentage of whole server's physical resources. In the example, that will be 20% of 32Gb. Is that right?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search