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.