• 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.