Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Using Hyper -V dynamic ram for Cube processing Server

Answered Using Hyper -V dynamic ram for Cube processing Server

  • Monday, January 14, 2013 5:56 AM
     
     
    Sign In to Vote
    0

    Hello Guys,

    Is it recommended to use dynamic ram setting on Hyper V for the analysis server that will be processing cube in a production environment? Considering the fact there will be resource contention amongst other VMs on the host.

    Thanks

     

All Replies

  • Tuesday, January 15, 2013 6:24 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi ghostme,

    Yes, I suggest using dynamic ram setting on Hyper V, in this way, we can use the memory more efficiently. By setting the Startup RAM, the virtual machine can always take up the minimal memory which it requires to run; by setting Maximum RAM, the virtual machine will not try to take more memory which will affect other virtual machines’ performance. There is a list of documents provide detail information about Hyper-V Dynamic Memory, you can refer to them.

    http://blogs.msdn.com/b/sqlosteam/archive/2011/01/31/sql-server-and-hyper-v-dynamic-memory-part-1.aspx

    Allen Li
    TechNet Community Support