• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

Hyper V & SQL

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?

Cheers
Troy
0
P3admin
Asked:
P3admin
2 Solutions
 
p_nutsCommented:
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..
http://sqlcat.com/whitepapers/archive/2008/10/03/running-sql-server-2008-in-a-hyper-v-environment-best-practices-and-performance-recommendations.aspx
I can't find anything on storage limits.. but I think it's depending on what kind of disk connection..
 
0
 
Auric1983Commented:
Troy,

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.  
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now