SQLAuthority News – Whitepaper – Running SQL Server with Hyper-V Dynamic Memory Best Practices and Considerations – Consolidating Databases Using Virtualization Planning Guide

I was recently looking for best practices for Hyper-V and SQL Server and I ended up whitepaper which was published in July earlier this year. I really wish I had come across this whitepaper earlier but any way still it is better to be late then never.

Download Running SQL Server with Hyper-V Dynamic Memory – Best Practices and Considerations

Memory is a critical resource to Microsoft SQL Server workloads, especially in a virtualized environment where resources are shared and contention for shared resources can lead to negative impact on the workload. Windows Server 2008 R2 SP1 introduced Hyper-V Dynamic Memory, which enables virtual machines to make more efficient use of physical memory resources. Hyper-V Dynamic Memory treats memory as a shared resource that can be reallocated automatically among running virtual machines. There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server 2008 R2 in Hyper-V Dynamic Memory configurations on Windows Server 2008 R2 SP1.

Download Consolidating Databases Using Virtualization Planning Guide

he purpose of this guide is to provide a description of the technologies and best practices utilized to design a database consolidation solution; guidance will be appropriately defined throughout to prescribe configurations and considerations to implement for best results. Documentation of specific tasks will be very limited.

This white paper consider the following three potential strategies:

  • Using a single physical machine to host multiple virtual machines running the Microsoft SQL Server database software
  • Using a single machine to host multiple SQL Server instances
  • Using a single instance of SQL Server to host multiple databases

Note: Above abstract is from Microsoft Official documentation.

Reference:  Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQL SERVER – Programming and Development – Book Available for SQL Server Certification
Next Post
SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide

Related Posts

19 Comments. Leave new

  • Gopalakrishnan Arthanarisamy
    September 5, 2011 7:44 am

    Hi Pinal,

    It is a good whitepaper on how to use implement SQL Server using Hyper-V and it covers the following strategies.

    Hyper-V Dynamic Memory treats memory as a shared resource that can be reallocated automatically among running virtual machines.

    Using a single physical machine to host multiple virtual machines running the Microsoft SQL Server database software

    Using a single machine to host multiple SQL Server instances

    Using a single instance of SQL Server to host multiple databases

    Gopalakrishnan Arthanarisamy
    Unisys, Bangalore, India.

    Reply
  • Dear sir i hve a problem in sql server 2005 .
    I wants to get all the record from the table in which user defined record/rows (one row) should be placed on the top of the record and rest should be below and condition is that we have only use one select statement.
    Exp: suppose i hve table name test(id,name,class) which contain 4 rows .when user pass id=1 then that record should be placed on top and resr are below of that bt we hve use only one select statement.pls reply me

    Reply
  • Exp: table_name test

    ID Name Class
    2 A MCa
    4 B MBA
    5 C MCa
    1 K MCA

    when user wants to get record of ID=4 at top position then
    results are like

    ID Name Class
    4 B MBA
    2 A MCa
    5 C MCa
    1 K MCA

    in such scenario we hve to use only one select statement

    Reply
  • Dear madhivanan
    thanks for reply ,bt that query in not working for above scenario.I think u hve not understood the problem.when user wants to get the record those id=4 that record should be at top position of results and rest r below of that record.

    Reply
  • Num1 num2 n um3
    3 1 2
    2 2 3
    1 3 1

    Please sir tell how the query that would display
    o/p
    Num1 num2 n um3
    1 1 1
    2 2 2
    3 3 3

    Reply
    • Dear madhivanan
      there is no need to change the order of the values,except the values which is selected by user should be at the top position other wise if rest values sequence change ,it does’t matter but user selected values should be at the top and we hve to use only one select statement.

      Reply
      • Dear Zubair khan
        execute this query ::
        select num1,num2,num3
        from uy_table_name
        order by num1,num2,num3 asc

      • Dear Ashish,
        I tried but this query is not working. please suggest me another query.
        thankx

      • The query that I posted should work. Did you try it?

      • Dear Zubair khan u hve to use self join for this out put

        try this query::
        select t1.num1,t2.num2,t3 .num3
        from table1 t1,table1 t2,table1 t3
        where t2.num2=t1.num1 and t2.num2=t3.num3 order by num1 asc

      • Dear Ashish,
        Special thankx to u….it works…thnkx again

    • What is the logic behind this output?

      Reply
      • Dear madhivanan
        the query which u hve posted is not working.I hve already told that there is no logic behind this output but i hve a requirement in my project that if the usere if passes their ID so the information/record associated with that ID should be at the top position and rest record should be below of that record.

  • Dear All,
    Please suggest if Sql Server installed in server and other systems are unable to acces the SQl Server. Then what could be the main problem in the connectivity.
    Thaxn

    Reply
  • Hi Sir,
    Sometimes I have noticed that sql server does not release memory it is using.For example i am running some heavy(but optimized) queries and the memory usages goes up.Now after execution of all process it should release those extry mbs of memory and set its position back to normal. But it is not the situation most of the time. Is it a problem either in sql server or server installed on my system. What should be the first step(steps) I have to take.

    Thanks

    Reply
  • Please, Is it a good idea to virtualize a SQL Server for Dynamics AX 2012? on a HP blade using VMware? Thanks a lot

    Reply
  • Had a question on MS SQL licenses and Virtualization. I tried to find the answers from MS SQL guide but it did not help.

    We have around 20 SQL Servers ( Standard edition/Per processor license Model) Most of them SQL 2005 and SQL 2000. We do not have SA and we are not planning to upgrade from existing version. My question is if I do a P2V and virtualize the servers to a 4 node ESXi 5.0 cluster and allocate the same number of processors , do i need to buy any additional licenses? Can I do vmotion for the SQL Servers between nodes? Please let me know.

    Reply

Leave a Reply

Menu