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 with multiple cpu on server Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 12:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 23, 2014 7:58 AM
Points: 115, Visits: 210
is it possible to use resource governor when there more number of cpu or it is a multiprocessor environment and how it can be configured??
Post #1426392
Posted Monday, March 4, 2013 8:22 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,860, Visits: 7,130
Yes it is possible. But for the most part CPU percentages (Min/Max) is set up as a whole. Eg. If you set a particular resource pool up to use no more than 25%, it's not bound to 1 single CPU, it's across all CPUs. Not sure whether or not you can fine tune that down in your classifier function using processor affinity or something like that...

Have you checked BOL?


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426575
Posted Tuesday, March 5, 2013 2:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 23, 2014 7:58 AM
Points: 115, Visits: 210
I did check BOL for that did not get anything.
Post #1426656
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse