Is the best config to set the min and max memory with Hyper-V and then set a slightly lower upper limit within SQL Server? Ie

Hyper-V

Startup mem - 4096mb

min mem -...

Thanks for the reply.

Is granting the lock pages in memory considered best practice for Hyper-V SQL 2012?

Is there any documentation available on this?

Many Thanks

Hi,

Thanks for your reply.

With regards to the grant lock pages in memory privilege. Is this through the Server Local policy editor? Is this essential to do if using...