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: Today @ 6:50 AM
Points: 2,071, Visits: 2,065
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


SSC Eights!

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

Group: General Forum Members
Last Login: Today @ 5:33 AM
Points: 962, Visits: 2,186
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: Today @ 3:38 AM
Points: 1,263, Visits: 601
Still working on 2012 & 2008 R2, didn't have the time or resources to start working on 2014
Post #1579470
Posted Wednesday, June 11, 2014 6:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:39 AM
Points: 2,935, Visits: 239
Thanks for the question.
Post #1579596
Posted Friday, June 13, 2014 12:40 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
easy one steve..
Post #1580708
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse