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)
19 Comments. Leave new
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.
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
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
select columns from table
order by case when id=4 then 0 else 1,id
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.
What order do you want to expect for the rest of the values?
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
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.
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?
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
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
Please, Is it a good idea to virtualize a SQL Server for Dynamics AX 2012? on a HP blade using VMware? Thanks a lot
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.