THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Hyper-V   (RSS)
  • Using Hyper-V for SQL Server CTP and RC Versions

    Yesterday at SQL Saturday I was asked how to connect to SQL Server 2017 CTP 2.1 that was running in a virtual machine by using Remote Desktop Connection. If you want to learn how to use new software before it is released, running it in a virtual machine is a really good idea. It is wise to keep prerelease software off of your primary machine. ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 18, 2017
  • SQL Server with Hyper-V Dynamic Memory - Best Practices white paper

    A new Microsoft white paper has been published entitled Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations. This paper, based on performance testing in the SQL Cat teams labs, provides advice on best practices for SQL Server running with Hyper-V Dynamic Memory, and is recommended reading for anyone ...
    Posted to SQLOS Team (Weblog) by SQLOS Team on August 2, 2011
  • [OT] : Windows Activation, en masse

    This weekend I discovered a minor issue in one of my virtual environments. I had built out 100 VMs based on a Hyper-V template, but I forgot to activate the original source before creating the template, so all of the machines were suddenly out of compliance. While easy enough on a one- or two-machine basis to just log into the machine and activate ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 13, 2011
  • SQL Server and Hyper-V Dynamic Memory Part 3

    In parts 1 and 2 of this series we looked at the basics of Hyper-V Dynamic Memory and SQL Server memory management. In this part Serdar looks at configuration guidelines for SQL Server memory management. Update 8/2/11: please also refer to the recently published white paper: Running SQL Server with Hyper-V Dynamic Memory - ...
    Posted to SQLOS Team (Weblog) by SQLOS Team on March 9, 2011
  • SQL Server and Hyper-V Dynamic Memory Part 2

    Part 1 of this series was an introduction and overview of Hyper-V Dynamic Memory. This part looks at SQL Server memory management and how the SQL engine responds to changing OS memory conditions.   Part 2: SQL Server Memory Management As with any Windows process, sqlserver.exe has a virtual address space (VAS) of 4GB on 32-bit and 8TB in ...
    Posted to SQLOS Team (Weblog) by SQLOS Team on February 27, 2011
  • SQL Server and Hyper-V Dynamic Memory - Part 1

    SQL and Dynamic Memory Blog Post Series   Hyper-V Dynamic Memory is a new feature in Windows Server 2008 R2 SP1 that allows the memory assigned to guest virtual machines to vary according to demand. Using this feature with SQL Server is supported, but how well does it work in an environment where available memory can vary ...
    Posted to SQLOS Team (Weblog) by SQLOS Team on January 31, 2011
  • Using Wireless with Hyper-V

    For those of us who do demos on laptops, Hyper-V provides great performance but no wireless capability. You simply can't bind a Hyper-V virtual machine to a wireless adapter, but you can implement a workaround in just a few minutes. There are three options. One option is to use Internet Connection Sharing (ICS, see Ben Armstrong's blog ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 23, 2008
Privacy Statement