February 2, 2012 at 3:55 am
I want to create Multiple SQL Servers using VMware. How to connect them? to create/test various scenario's on my Personal Computer.
Configuration
RAM : 4GB
O.S : Windows XP SP2
HDD : 250 GB
CPU : Dual Core
Sagar Sonawane
** Every DBA has his day!!:cool:
February 2, 2012 at 4:36 am
Please no one commented. 🙁
I want to create SQL Multiserver environment of atleast 4-5 Sql Servers .
Sagar Sonawane
** Every DBA has his day!!:cool:
February 2, 2012 at 4:48 am
Patience... You posted your question less than an hour ago.
You also haven't asked much of a question. Yes, it's possible to run SQL Server in a VM environment and yes it's possible to run more than one on a single machine, assuming it has the resources for it. What exactly was your question?
February 2, 2012 at 5:05 am
I have mentioned machine details that I am having.
I want to create 4 different SQL servers on 4 VMware clients(on single machine). Production, dev, QUA etc.
I want to test some scenario's on these sql server.
But I am only having Single machine at my place(Home) hence I am planning to use VMware for that.
I wanted to know how to connect SQL Server on Vm1 to SQL server on VM2 so on..
In short i wanted to test business environment for practice purpose only.
Sagar Sonawane
** Every DBA has his day!!:cool:
February 2, 2012 at 5:27 am
It's all possible, but performance would likely be pretty terrible running the host O/S, 4 VM's and 4 instances of SQL Server (including the production instance) all on the same desktop-spec machine.
Connecting them's all pretty straight forward. Just set the VM's to use bridged networking (the default), give them distinct machine names and IP's and away you go.
February 2, 2012 at 5:53 am
4gb of memory is really not enough to run that many VMs.
You have two options. 1) Make the VMs part of your existing network. You can add them to your AD network and then they can talk to each other, easily & quickly. 2) Create a virtual domain controller and then add all the virtuals to that domain.
I just finished setting up a system using option 2 for testing AlwaysOn with SQL Server 2012. It wasn't hard. VMWare supports it just fine. But, my system has 8gb of memory and it's barely enough (thinking about lobbying the boss for more today). You will need more.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 2, 2012 at 6:15 am
Thank you Howard & Grant. I will try to make memory availability at least 8Gb
Sagar Sonawane
** Every DBA has his day!!:cool:
February 2, 2012 at 7:11 am
Saga... (2/2/2012)
Thank you Howard & Grant. I will try to make memory availability at least 8Gb
Thats still pretty slim. I have more than that on my Windows 7 PC at home. You'd really be better off having a single windows VM hosting 4 named SQL instances.
February 3, 2012 at 5:16 am
MysteryJimbo (2/2/2012)
Saga... (2/2/2012)
Thank you Howard & Grant. I will try to make memory availability at least 8GbThats still pretty slim. I have more than that on my Windows 7 PC at home. You'd really be better off having a single windows VM hosting 4 named SQL instances.
I am running out of resources 🙁
Sagar Sonawane
** Every DBA has his day!!:cool:
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply