THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Restricting memory using Resource Governor

This blog has moved! You can find this content at the following new location:

http://sqlblog.karaszi.com/restricting-memory-using-resource-governor/

Published Tuesday, April 19, 2011 2:13 PM by TiborKaraszi

Comments

 

Abhay said:

I realized it a bit late ..... :) appreciate your time and efforts in explaining this ...

Regards always

Abhay

April 19, 2011 8:14 AM
 

jamiet said:

Tibor,

You need:

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

in there somewhere!!

JT

April 19, 2011 8:33 AM
 

TiborKaraszi said:

Correct, Jamie. I have show advanced options on already, so I tend to forget it in these situations...

April 19, 2011 8:43 AM
 

Feodor Georgiev said:

Hej Tibor,

awesome work and very well thought example. This is a great article.

I would also like to point to a blog post I recently wrote which summarizes the limitations and the benefits of the Resource Governor: http://www.sqlservice.se/sql-server-performance/my-most-un-favourite-things-about-resource-governor/

I am posting this, because I believe it is important for the readers to understand the limitations before engaging the RG. For example, I still think that the greatest flaw of the Resource Governor design is the lack of IO governing capabilities.

Regards,

Feodor

June 16, 2011 3:09 AM
New Comments to this post are disabled
Privacy Statement