SQL Server 2012 Unattended Installation on Windows Server 8

in part 5 will install sql server 2012 on 3 windows server 8 vm’s using gui and unattended installation to complete sql server 2012 next gen hadr labs prequisites

installing new instance of sql server at the command prompt enables you to stadardized sql server installation, selective features to install and how they should be configured.

 

previous posts on this series…

 

installing sql server 2012 on windows server 8


 

unattended installation of sql server 2012 on windows server 8

 

 

Configure Windows Server 8 ISCSI Target

In part 4 will configure Windows Server 8 ISCSI Target to complete SQL Server 2012 Next Gen HADR labs prequisites, In this Video will use domain controller to also play role of iSCSI target and create ISCSI disk then connects to this disk over the network to VM which then be using for setting up SQL Server FCI cluster

in part 4 will configure windows server 8 iscsi target to complete sql server 2012 next gen hadr labs prequisites, iscsi is a technology which is part of windows server 8 which allows scsi commands to be shared over the network to enable cheap and simple network storage options. in this video will use domain controller to also play role of iscsi target and create a iscsi disk then connects to this disk over the network to vm will be using for setting up sql server fci cluster. using iscsi initiator creates a new disk on the vm, which will format and puts into action. this is very useful for creating clustering scenarios, reduces the complexity of managing shared nothing scsi id’s and can be a very cost effective storage scenario. while the simple setup shown in this video works fine in a lab environment, in real life you would connect to your iscsi disk using a dedicated high speed network cards on a private network to reduce latency.

 

previous posts on this series…

 

please watch this and comment…

 

 

Configure Windows Server 8 Hyper-V and Domain controller

In Part 3 video series to prepare SQL Server 2012 test lab using Windows Server 8 Beta Hyper-V, will configure Hyper-V, Parent disk for differential VHDs and a test domain controller using diff disk, for testing SQL Server 2012 Next Gen HADR test lab…

in part 3 video series to prepare sql server 2012 test lab using windows server 8 beta hyper-v, will configure hyper-v, parent disk for differential vhds  and a test domain controller using diff disk, for testing sql server 2012 next gen hadr test lab…

 

 

previous posts on this series…

 

configure windows server 8 hyper-v, parent and differential disks

 

 

configure windows server 8 domain controller

 

let me know how do you like it…

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Beta is out, check this video to use existing windows laptop/desktop to build VHD bootable Windows server 8 Hyper-v Test lab without formatting existing OS. You will learn how to boot to Windows Server 8 Virtual Hard Disk (VHD)…

windows server 8 beta is out, check this video to use existing windows laptop/desktop to build vhd bootable windows server 8 hyper-v test lab without formatting existing os. you will learn how to boot to windows server 8 virtual hard disk (vhd)…

check this post if you are looking to buy a desktop to see all components are compatible to hyperv and esxi5


download: install-windowsimage powershell script

steps: start powershell as administrator

execute: set-executionpolicy unrestricted

execute: cd c:sources

execute: .install-windowsimage.ps1 –wim c:sourcesinstall.wim -apply -index 4 -destination x:

download and install: easybcd 2.1

Low Power SQL Server Test Lab on Windows Server 8 Hyper-V / ESXi5

Windows Server 8 Beta is released, if you are looking to build a low cost, Low power PC which can server as 24×7 W7 HTPC as well as Windows Server 8 Hyper-V (Beta) or ESXi5 Hypervisor than this is what to start with…

windows server 8 beta is released, if you are looking to build a low cost, low power pc which can server as 24×7 w7 htpc as well as windows server 8 hyper-v (beta) or esxi5 hypervisor than this is what to start with…

i have got lots of questions about the test lab setup, where dba’s can try and test various scenarios to try out sql server 2012, i am sharing my setup which has been tested for windows server 8 & esxi5 hypervisor, low cost and lowest power 24×7 running….

key considerations & features:

  • all key components are highly power efficient
  • low power consumption in idle mode 20 watt
  • max 45 watt power consumption in full load
  • supports windows 7 htpc (play blu-ray/wmc/netflix with ease)
  • supports windows server 8 (beta)
  • supports esxi5 hypervisor
  • this desktop supports booting esxi5 from usb (no need for hard disk)
  • this desktop supports booting windows server 8 hyper-v server from vhd’s
  • supports 4 vm’s with low load (fine for test vm’s)
  • **this configuration does not support windows 2008/r2, network driver not supported (hack and made it work can do though hyper-v will not be stable)
  • **supports windows to go (new windows 8 feature booting windows from usb), though its very slow as this motherboard supports usb 2.0 only

in an ideal combination you can have this box running windows 7 htpc as default and boot to windows 8 hyper-v or esxi5 for testing as and when needed, or can be run exclusively for any of these systems…

component price
antec mini itx case isk300-65 watt adaptor this is one of the smallest case for mini itx motherboards and have external power adaptor of 65 watts, supports one thin external drive as well $71.74
corsair vengeance low profile 8 gb cml8gx3m2a1600c9 low height ram 2 modules each 4 gb $49.99
foxconn intel h67 mini itx h67s-b3 lowest power consuming h67 itx motherboard (very stable for this setup) didn’t want more features as they consume additional power, no usb3 or data 6gb $59.99
core i3-2120t (low power 35 watts cpu) $128.00
hard disk (use any available) use notebook hard drive for low power consumption, i had one available thus used. not included
total cost $309.72

 

caution: don’t expect this box to run full power 3-4 vm’s, test low performing vm’s will do just fine

my usage:

  • i usually have 10+ vm’s configured with diff versions of windows and start only the ones i am testing to get best performance
  • runs esxi-5 hypervisor from usb stick
  • run windows server 8 beta from vhd
  • run 24×7 with 20watt idle power consumption

next article will talk about configuring windows server 8 hyper-v (beta) running from vhdx (new windows 8 hyper-v format) to test sql server 2012…

look forward to hear your thoughts/questions/suggestions….

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

This series of Videos will walk through how to prepare existing windows 7 machine to test and validate active/active node SQL server cluster configuration prior to production…not only will try how to build a Hyper-V test lab to validate SQL clusters, I will also cover overall knowledge of dependent technologies to build SQL cluster to attain better troubleshooting skills by DBA (domain controller, storage controller, windows cluster configuration)…

this series of videos will walk through how to prepare existing windows 7 machine to test and validate active/active node sql server cluster configuration prior to production…not only will try how to build a hyper-v test lab to validate sql clusters, i will also cover overall knowledge of dependent technologies to build sql cluster to attain better troubleshooting skills by dba (domain controller, storage controller, windows cluster configuration)…

this video series on same track as denali ctp1 though enhanced to have below points to make it more smooth and align with production configuration requirements…
• learn to create windows 2008 r2 sp1 hyper-v lab within windows 7 machine without affecting existing functionality (no need of a separate box to evaluate sql features as needed in denali video series)
• using parent and child disks feature of hyper-v to reduce space requirement and save installation time for new vhd’s
• configure hyper-v network configuration to work within 3 machines and accessible outside network
• configuring iscsi storage controller
• configuring cluster with regular domain user privileges
• slipstream service pack 1 and cu updates sql server binaries to have one installation
• configure mstsc and firewall settings for sql cluster
• configure required firewall ports on windows cluster

[adsenseyu5]

complete set of videos (sql 2008 r2 sp1 2 node active-active cluster)

part 11: prepare w2k8 r2 vhd hyper-v lab to boot from windows 7
part 12: prepare hyper-v configuration/networking
part 13: configure windows 2008 r2 domain controller
part 14: configure windows 2008 r2 iscsi controller
part 15: preparing nodes for failover cluster
part 16: configure 2 node windows 2008 r2 sp1 failover cluster
part 17: install sql server failover cluster on node 1
part 18: add sql server node 2 to cluster
part 19: configure second sql installation for active/active

download:
install-windowsimage powershell script
steps: start powershell as administrator
execute: set-executionpolicy unrestricted
execute: cd c:\sources
execute: .\install-windowsimage.ps1 –wim c:\sources\install.wim -apply -index 3 -destination x:

download and install:
easybcd 2.1

 

part 11: prepare w2k8 r2 vhd hyper-v lab to boot from windows 7

windows 7 to configure windows 2008 r2 sp1 vhd

 

part 12: prepare hyper-v configuration/networking

 

upcoming….part 13: configure windows 2008 r2 domain controller

let me know how do you like this series and any specific questions you have
my contact email: prakash@sqlfeatures.com

Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features

This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL Server Denali Always-ON HADR Features on Windows 2008 R2

this series of videos will walk through on how to prepare one box hyperv lab to understand, evaluate & validate sql server denali always-on hadr features

part 1: denali setup & network configuration
part 2: configure windows 2008 r2 domain controller
part 3: preparing nodes for failover cluster
part 4: configure 2 node failover cluster
part 5: install standalone denali on both nodes
part 6: denali availability groups explained (session 1)
part 6: denali availability groups explained (session 2)
part 6: enable availability groups (session 3)
part 7: configure availability groups with 2 db’s
part 8: readable replica & test force failover
part 9: implement & test virtual name

[adsenseyu5]

part 1: denali setup & network configuration

part 2: configure windows 2008 r2 domain controller

part 3: preparing nodes for failover cluster

part 4: configure 2 node failover cluster

part 5: install standalone denali on both nodes

part 6: denali availability groups explained (session 1)

part 6: denali availability groups explained (session 2)

part 6: enable availability groups (session 3)

part 7: configure availability groups with 2 db’s

part 8: readable replica & test force failover

part 9: implement & test virtual name

 

let me know how do you like this series and any specific questions you have
my contact email: prakash@sqlfeatures.com

let me know how do you like this series and any specific questions you have
my contact email: prakash@sqlfeatures.com