All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

SQL Server virtualisation improvements with SLAT in Intel and AMD

SQL Server virtualisation improvements with SLAT in Intel and AMD

  • Comments 1
  • Likes

Recently I had query around documentation that discusses the benefits of running SQL Server in a virtualised environment on modern hardware with SLAT or second level address translation. The below graph shows that (see the solid red line) the relative throughput for hardware with SLAT & Windows Server 2008 R2 (required for SLAT support) degrades very slightly as workload increases. However without SLAT hardware and with Windows Server 2008 the dotted red line shows immediate degradation even without over commit of CPUs.

The below links have further information on the impact of SLAT. So if you are looking at virtualising SQL Server ensure it is on SLAT enabled hardware.

image

High Performance SQL Server Workload on Hyper-V

http://download.microsoft.com/download/D/F/8/DF89D22D-39C8-4728-A990-3BD4467891B7/HighPerformanceSQLServerWorkloadsOnHyper-V_Final.docx

SQL Server Consolidation Guidance

http://msdn.microsoft.com/en-us/library/ee819082(SQL.100).aspx

 

TechNet Webcast: Microsoft Virtualization Best Practices for SQL Server (Level 300)

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032428764&EventCategory=5&culture=en-US&CountryCode=US

Comments
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment