THE SQL Server Blog Spot on the Web

Welcome to - 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:

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



Abhay said:

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

Regards always


April 19, 2011 8:14 AM

jamiet said:


You need:

EXEC sp_configure 'show advanced options', 1


in there somewhere!!


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:

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.



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