Hyper V & SQL

Posted on 2009-12-20
Last Modified: 2013-11-06
Hi guys

We are looking at building a 2008 box with a Hyper V R2 virtual instance of SQL and SharePoint on one of the instances. Will this effect the amount of storage that we can have on SQL as I have heard its 130gb max? Also is it advisable to have the DC running on an instance or directly on the box?

Question by:P3admin
    LVL 13

    Accepted Solution

    I would sooner put a dc virtual then a sql.. but really both I wouldn't make virtual any day soon..
    the problem with virtual is that you are sharing IO and both sql and a writable DC are heavy on IO..
    I can't find anything on storage limits.. but I think it's depending on what kind of disk connection..
    LVL 16

    Assisted Solution


    SQL 2008 R2 is supported in hyper v ...

    I would consider setting up two seperate instances one for SQL the other for SharePoint.

    Are you going with MOSS or just WSS 3.0?  Reason I suggest two seperate boxes allows you to grow the MOSS Server farm if your needs change over time.  IE you want to add another front end sharepoint server.  

    WIth a standalone install (SharePoint + named instance of SQL) you are limited in that you cannot add additional servers.  

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    spx for moving values to new table 5 45
    Testing connection to sql 7 35
    report c# 9 57
    Date Differences SSRS 3 24
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now