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.
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…
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
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…
Best way to tune production server is to find out what are the queries executed in a particular duration and how many times it got executed, thus to concentrate on tuning top hitting queries ASAP…check out the video and scripts
this series of videos will walk through how to detect worst performing sql queries which is slowing down microsoft sql server, after this session you should be able to achieve below objectives…
how to find out during production peak hour what are the exact queries taking most of the resources and will benefit most from fine-tuning…
how to use sql server dmo’s to gather what resources are the bottlenecks and which queries are causing those bottlenecks.
demo – how to find which exact queries are taxing production systems resources based on cpu/disk/memory/network.
please check videos for part 1 & part2 for previous videos of this series…
to save right click on links and choose “save target as”
Join SQL Server experts as they take an in-depth look at the hottest SQL Server topics over 24 consecutive (and free!) technical webcasts. The learning starts on March 21, 2012 beginning at 00:00 GMT (that’s a March 20 evening start for the Americas).
24 hours of pass watch from your home/office
join sql server experts as they take an in-depth look at the hottest sql server topics over 24 consecutive (and free!) technical webcasts. the learning starts on march 21, 2012 beginning at 00:00 gmt (that’s a march 20 evening start for the americas).