SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Resource Governor in SQL Server 2008


Resource Governor in SQL Server 2008

Author
Message
Sai Viswanath
Sai Viswanath
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 124
Hi,
Am looking to implement Resource Governor functionality, and would like to know the links or any useful details which can help me in proceeding further along with sample code.

Regards,
Sai Viswanath
Orlando Colamatteo
Orlando Colamatteo
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14817 Visits: 14396
Since you're just starting out, SQL Server Books Online would be a great place for you to start. Post back with more specific questions after you have acquainted yourself with the features or want to share more specific details about what you are trying to learn.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Sai Viswanath
Sai Viswanath
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 124
Hi,
Well, I had gone through SQL BOL. It's informative, and the reason for posting this query is - am from Data Modelling background and currently been projected as Sr DBA to the client. And in the last meeting the guys were discussing about Resource Governor, and are expecting something from me. So, thought of gaining some knowledge asap (which is wrong), and prepare an approach document and submit to client. By doing so, I can buy some time and dig deep into the requirement and work out with a proper solution.

Regards,
Sai Viswanath
Jason-299789
Jason-299789
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2059 Visits: 3232
THeres also a very good White paper on the resource governor which can be found here http://msdn.microsoft.com/en-us/library/ee151608(v=sql.100).aspx

If you've read BoL then I would suggest reading this next as it goes into a lot more detail.


Edit : I've just seen that you are being touted by your company as a Sr. DBA, this really is wrong of the company, not least because its misrepresentation, and not good for you especially if you are in a room with someone from the client side who knows more than you do as i've been put in that awkward position before.

_________________________________________________________________________
SSC Guide to Posting and Best Practices
Sai Viswanath
Sai Viswanath
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 124
Hi,
Thanks for the concern, but as of now I don't have any option. The lucky part of mine is - client is not at my place and hence am able to do some work around with the things. Sure, will go through the link, and will try to publish my understanding in a short duration.

Regards,
Sai Viswanath
Jason-299789
Jason-299789
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2059 Visits: 3232
No problem, I empathise with how you must feel.

I was playing around with the resource guvenour about a year ago, hes my post on what I'd done with a few helpful responses from Gazreth here on SCC

http://www.sqlservercentral.com/Forums/Topic1367458-1550-1.aspx

It might help as a starting point.

_________________________________________________________________________
SSC Guide to Posting and Best Practices
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