Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Looking for best practices in HyperV and SQL2k8

Author  Topic 

AllenCClark
Starting Member

1 Post

Posted - 2011-09-13 : 13:39:53
I am trying to get recommendations on how to best run SQL applications in a virtualized server. I am running Windows 2008 R2 Sp1 Enterprise and I need to run SQL on a virtualized server. What is recommended for best performance? I have six databases that need to be running. Is it better to create a single massive virtual server and run all databases in a single instance? Or create a massive virtual server and run each database in it's own instance? Or is it best to create a virtual server for each application and run each application in a single instance on each virtual server?

I would also like to know why the recommendation or how it makes it better for performance.

Thanks in advance,
Allen

Always looking for the better mousetrap.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-13 : 14:29:29
I would use one instance for just 6 databases.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -