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 ««12

Resource Governor pools Expand / Collapse
Author
Message
Posted Tuesday, June 10, 2014 9:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:12 AM
Points: 2,180, Visits: 2,173
Tom,

Currently there are 148 incorrect and 147 correct answers. This leads me to believe that your interpretation of the question may be correct.

Enjoy!
Post #1579286
Posted Tuesday, June 10, 2014 11:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:18 AM
Points: 1,057, Visits: 2,359
Thank you for the question, SJ, nice one.

I was checking in the local help, installed both SQL 2012 and 2014, it has only this. When I synced the page to the TOC, it pointed to 2012 page... so I have to dig in to the 2014 manually to see what 2014 has to say... well in the resource pool page it is pointing to the 2012 page... :-(. so I checked for update and.. YES... there was update for both, and after updating.. no change... :-(

and have to check the online, finally.

I thought - MAX_IOPS_PER_DATABASE and MIN_IOPS_PER_VOLUME - these two must be wrong choice and for this I need to select two but answer was in single selection mode.. well the past 15 minutes of thought bursts...

CREATE RESOURCE POOL pool_name
[ WITH
( [ MIN_CPU_PERCENT = value ]
[ [ , ] MAX_CPU_PERCENT = value ]
[ [ , ] CAP_CPU_PERCENT = value ]
[ [ , ] AFFINITY {SCHEDULER = AUTO | (Scheduler_range_spec) | NUMANODE = (NUMA_node_range_spec)} ]
[ [ , ] MIN_MEMORY_PERCENT = value ]
[ [ , ] MAX_MEMORY_PERCENT = value ])
]



ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1579340
Posted Wednesday, June 11, 2014 12:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:46 AM
Points: 1,429, Visits: 685
Still working on 2012 & 2008 R2, didn't have the time or resources to start working on 2014
Post #1579470
Posted Friday, June 13, 2014 12:40 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 1,848, Visits: 590
easy one steve..
Post #1580708
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse