Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resource Governor in SQL Server 2008 Expand / Collapse
Author
Message
Posted Monday, June 10, 2013 7:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 21, 2014 6:54 AM
Points: 36, 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
Post #1461835
Posted Monday, June 10, 2013 8:55 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:06 PM
Points: 7,125, Visits: 12,720
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
Post #1461845
Posted Monday, June 10, 2013 10:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 21, 2014 6:54 AM
Points: 36, 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
Post #1461856
Posted Tuesday, June 11, 2013 2:09 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 3, 2014 9:25 AM
Points: 895, Visits: 2,432
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
Post #1461918
Posted Tuesday, June 11, 2013 3:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 21, 2014 6:54 AM
Points: 36, 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
Post #1461948
Posted Tuesday, June 11, 2013 3:32 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 3, 2014 9:25 AM
Points: 895, Visits: 2,432
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
Post #1461955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse