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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

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

Leave a Comment

(required) 
(required) 
Submit
Privacy Statement