I have a Server 2008 R2 server. Is it a good idea to make this a Hyper-V root partition, and install SQL Server 2008? What issues might I run in to?
I typically have almost nothing running in the root of my hyper-V servers. I like to make them as simple as possible.
I also have several SQL 2008 servers in child partitions. Have to admit that the SQL servers are NOT overloaded...at all. Would just be careful with how much you load up the SQL boxes. Check out brent ozar's blog for some overview kind of links to SQL on Hyper-V.