Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

b) Also, Max_Memory_Percent is the percentage of "Max Server Memory"? So my max server memory is 28 GB on a server with 32 GB RAM. Does that mean setting Max_MEMORY_PERCENT to 10 percent mean I set 2.8 GB for that particular resource pool.