SQL Server virtualisation improvements with SLAT in Intel and AMD


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 (2)

  1. aw says:

    http://www.lokerjobindo.com/search/label/Lowongan%20Perbankan%20dan%20Keuangan
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Aceh

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Bali

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Balikpapan

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Bandung
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Banjarmasin

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Banten

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Bekasi

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Bengkulu

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Bogor

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Cianjur

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Cikarang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Cilegon

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jakarta

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jambi

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Jember

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Karawang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Kupang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Lampung

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Madiun

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Makasar

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Malang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Maluku

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Manado

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Medan

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20NTT

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Padang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Palembang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Pontianak

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Samarinda
    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Semarang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Serang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Sidoarjo

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Surabaya

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Tangerang

    http://www.lokerjobindo.com/search/label/Loker%20Daerah%20Yogyakarta
    http://www.lokerjobindo.com/search