SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


70-462: Can the Hyper-V environment be downloaded somewhere?


70-462: Can the Hyper-V environment be downloaded somewhere?

Author
Message
netmikem
netmikem
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1136 Visits: 363
Works great, many thanks again.



Steven.Howes
Steven.Howes
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1616 Visits: 2354
Glenn Berry had a great series on hardware last month, when/if I ever get some money I'm goin to follow his advice and build myself a new toy.


Turns out the article I was thinking of was older... it's here.
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3549 Visits: 2000
Questions for those of you building out the lab described in the 70-462 book:

Do you have several physical servers that you're building this on, or are you all invested in high-end workstations that ran run multiple VMs?

My situation: My current home computer (4-5 years old or so) has Windows 7 64-bit with the maximum 4GB RAM the motherboard will accomodate. I had been running a VM of Server 2008 (32-bit - my processor doesn't support 64-bit virtualization) with an instance of SQL Server interacting with an instance of SQL Server Developer Edition on my Host Windows 7 OS. The VM is set to 2GB of RAM as I felt it would be too slow with anything less. Well between the VM, Outlook, SSMS and anything else I was running, my computer occasionally ran out of RAM, started paging and everything slowed to a crawl.

My solution was to set up a VM on my wife's computer (6GB of RAM) running Server 2008 R2 and use a SQL instance running there. But she complains I make her computer run slow, even though the VM is set to 2GB, and I'm still limited to 2 SQL instances at one time.

I'm considering investing $1,000 or so in a new i7 12GB monster workstation, which I figure could run multiple Server 2008 R2 VMs simultaniously. This would also free up my present computer to be rebuilt as a physical 2008 R2 server for another instance.

Is this what I need to do? Or can I run my VMs with less RAM?

On a related note, does a 2008 Server Core installation run better with less RAM than the regular version due a lack of the Windows GUI and other features? I haven't done this install yet. Is it worth the time then? Can it be managed via RDP or do you need to be at the phuysical (or VM) console?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61989 Visits: 13297
4GB is not a lot of RAM, especially since Windows has to have a piece of it as well.
You know give a VM 1GB of RAM and it will still run somewhat acceptably. You're not doing high performance TSQL development, but rather some basic administration stuff.
Most of the time you only need to run 2 servers at the same time, so it's possible to over allocate your RAM.

I don't really have an idea of the RAM usage of Windows Core, but I can imagine it uses less because it is a stripped down version of the OS.
Not sure you can RDP into it. You basically have a cmd module and a powershell module. To manage SQL Server however you can just connect with SSMS from another computer, so there's no difference there.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
SQL_Cat
SQL_Cat
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 20
Hey

Would appreciate some advice please.

As per the original post, I would like to set up the training environment for the 70-462 training kit book I just purchased so I can do the exercises etc.

My system:
Dell Latitude E6530
Processor is i7
[/url]
4GB of RAM (I have ordered another 4GB yesterday)
500GB HDD
OS: Windows 7 Pro

Virtualisation Hardware requirements (from book):
"x64-based processor that includes both hardware-assisted virtualization (AMD-V or
Intel VT) and hardware data execution protection. (On AMD systems, the data execution
protection feature is called the No Execute or NX bit. On Intel systems, this feature
is called the Execute Disable or XD bit.) These features must also be enabled in the
BIOS. (Note: You can run Windows Virtual PC without Intel-VT or AMD-V.)"

My processor seems to have these attributes (see link above)

I would prefer as most people would to not go with the 6 physical computers option and opt for virtuals but I'm running into problems. Seems as though because I'm running Win7 then I can't use Hyper-V.

The book recommends that I use Windows Server 2008 R2 Enterprise. Hmmm. Sorry I don't have that. I could get a 180 day trial of it of course, but what then? Do I just format my laptop, install the 180 day trial server OS, have 180 days with the server environment then it's all over?

Some guidance here would be highly valued.

I got excited when I found this blog[url=http://www.sqlservercentral.com/articles/MCSA+70-462/103881/]
. But was disappointed when I discovered the host machine is assumed to be Windows 8 Sad

When I installed the RSAT as per [url=http://blogs.technet.com/b/schadinio/archive/2010/07/09/installing-hyper-v-manager-on-windows-7.aspx][/url] I get as far as the virtual switch section in the above walk-through then brick wall. There is no such setting in the Windows 7 Hyper-V manager.

Sorry for the lack of clarity, I am not in my field of expertise.

Helpful advice welcomed and appreciated.
Thank you
kind regards
Paul
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61989 Visits: 13297
If you can't use HyperV, then VirtualBox is a good alternative.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3549 Visits: 2000
If 8GB is the maximum your laptop can run, then I would create one VM and using Virtual Box or VMPlayer create a stand-alone Widnows Server 2008 VM and assign it 4GB of RAM. The Evaluation Edition will work for 180 days and when you get toward the end there is a command that will extend it out for another period of time. You can find more information in the Microsoft site. After that I'm afraid you will have to start over, but if you backup your databases and anything else critical off of the VM first, you can make a new VM and practice your disaster recovery strategy. ;-)

For the failover clusters and perhaps other high availability exercises, you'll need at least three servers. I would create a domain controller and give it 1GB since the authentication duties will be light in your practice environment. Create two member servers with 2GB each. Not a lighting fast setup but you can get mirroring, AlwaysOn and cluster failovers to work.

I am assuming this is the only computer in the house. If there is another, even an older one with only 4GB of RAM you can run a VM there and access it through your home network.
SQL_Cat
SQL_Cat
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 20
Hey

many thanks for the help people. I will likely post again with another question or let you know what I've done.

kind regards
Paul
jackson.fabros
jackson.fabros
SSC Veteran
SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)SSC Veteran (241 reputation)

Group: General Forum Members
Points: 241 Visits: 133
Hey guys, Thanks for sharing a lot of really good information here on how to set up the environment for the 70-462 training kit BUT i still feel like a deer in headlights since I've never worked with VMs, Hyper-Vs, etc.

I am planning on starting the training kit soon and wanted to know what my next steps are. So far have I have a Windows 7 laptop (which i believe does not support Hyper-V) running on Intel i7. Plenty of RAM (pretty sure I do) and 100+GB hard disk space. I have an instance of SQL Server 2012 running on the laptop and Windows Server 2008 R2 iso burnt to a disk.

Any help on my next steps is greatly appreciated =/
cppwiz
cppwiz
SSC Eights!
SSC Eights! (862 reputation)SSC Eights! (862 reputation)SSC Eights! (862 reputation)SSC Eights! (862 reputation)SSC Eights! (862 reputation)SSC Eights! (862 reputation)SSC Eights! (862 reputation)SSC Eights! (862 reputation)

Group: General Forum Members
Points: 862 Visits: 470
There are three virtual labs that you can use to practice without setting up your home lab:

Exploring AlwaysOn Availability Groups in SQL Server 2014
https://vlabs.holsystems.com/vlabs/technet?eng=VLabs&auth=none&src=vlabs&altadd=true&labid=12694

Exploring AlwaysOn Failover Cluster Instances in SQL Server 2014
https://vlabs.holsystems.com/vlabs/technet?eng=VLabs&auth=none&src=vlabs&altadd=true&labid=12693

SQL Server 2012: Working with the SQL Server 2012 Availability Groups
https://vlabs.holsystems.com/vlabs/technet?eng=VLabs&auth=none&src=microsoft.holsystems.com&altadd=true&labid=9919

You can also see more virtual labs here:
https://technet.microsoft.com/en-us/virtuallabs/bb467605.aspx

These are linked from the Microsoft Virtual Academy training that you should also review:
Administering Microsoft SQL Server 2012 Jump Start
http://www.microsoftvirtualacademy.com/training-courses/administering-microsoft-sql-server-2012-jump-start

Tips: review the Virtual Academy training at 1.4 or 2.0 speed because the default pace moves very slow. You can also take some of the assessment tests two times if you miss at least one answer, so I would intentionally miss at least one answer so I could be exposed to more questions during the retake.

Here is another resource I used:
Exam Prep: 70-462 - MCSA: Microsoft SQL Server 2012 from TechEd May 19,2014
https://www.youtube.com/watch?v=7c2FUqUySDE

I passed the 70-462 exam without setting up any of the Hyper-V environments, but I did practice on a single instance, took the SelfTest practice exams and researched everything throughly. I had about six questions to order the correct steps in a process. Good luck!



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search