Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Experiment in High Availability Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 4:52 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 11:47 PM
Points: 198, Visits: 679
Hi All,

Would like to get some hands-on with the high availability options (Log-shipping, Replication, Database-Mirroring and Server Clustering).

Can I do experiment on these in my personal computer?



_____________________________________________
One ounce of practice is more important than tonnes of dreams
Post #1496800
Posted Friday, September 20, 2013 11:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:45 AM
Points: 127, Visits: 307
Yes, Why not. Create 2-3 instances of SQL Server and get started... or the other way is install Virtual machine on uor box and get started.
Post #1496969
Posted Saturday, September 21, 2013 2:35 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 11:47 PM
Points: 198, Visits: 679
Yes, Why not. Create 2-3 instances of SQL Server and get started... or the other way is install Virtual machine on uor box and get started.


Thanks, have read that clustering and mirroring required new addition of hardware and software, also those are costly. As I am more into development did not get chance to install and do anything in hardware and software installation unless sql installed at home.

That's why the topic posted. BTW, Thanks.

If you had already come through any good links, Please share.


_____________________________________________
One ounce of practice is more important than tonnes of dreams
Post #1497121
Posted Saturday, September 21, 2013 2:51 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
C.K.Shaiju (9/21/2013)
[quote]Thanks, have read that clustering and mirroring required new addition of hardware and software


Virtual machines. No additional hardware necessary.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1497124
Posted Tuesday, September 24, 2013 8:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 11:47 PM
Points: 198, Visits: 679
Virtual machines. No additional hardware necessary.


Thanks Gail


_____________________________________________
One ounce of practice is more important than tonnes of dreams
Post #1497878
Posted Tuesday, September 24, 2013 11:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:45 AM
Points: 127, Visits: 307
Even for clustering you can do some hands on but you need to search on goole for available VM.. Without any investment..
Post #1497991
Posted Wednesday, October 2, 2013 11:19 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 11:47 PM
Points: 198, Visits: 679
Dhananjay-440114 (9/24/2013)
Even for clustering you can do some hands on but you need to search on goole for available VM.. Without any investment..


Thanks Dhananjay. Let me search. :)


_____________________________________________
One ounce of practice is more important than tonnes of dreams
Post #1500861
Posted Wednesday, October 2, 2013 12:07 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 10:51 AM
Points: 558, Visits: 1,652
I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed, but performance was frustrating at times, especialy if IE was open. If you have more than 4GB or a second machine you can install SQL on, you'll be in better shape.

For a failover cluster, you'll need at least 3 VMs, a domain controller and 2 nodes, and a tutorial on how to set up shared drives in this kind of envronment (if anyone has a favorite link for this, please post it as I'd like to do this). For 3 VMs you'll want a PC with at least 8GB of RAM , or a second PC (you can put the DC there).

Another option might be to use Wondows 2003 SP2 VMs, which can probably run satisfactorly on less RAM.
Post #1500874
Posted Friday, October 4, 2013 1:52 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 11:47 PM
Points: 198, Visits: 679
dan-572483 (10/2/2013)
I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed, but performance was frustrating at times, especialy if IE was open. If you have more than 4GB or a second machine you can install SQL on, you'll be in better shape.

For a failover cluster, you'll need at least 3 VMs, a domain controller and 2 nodes, and a tutorial on how to set up shared drives in this kind of envronment (if anyone has a favorite link for this, please post it as I'd like to do this). For 3 VMs you'll want a PC with at least 8GB of RAM , or a second PC (you can put the DC there).

Another option might be to use Wondows 2003 SP2 VMs, which can probably run satisfactorly on less RAM.


Thanks for sharing.
I didn't get any white papers, but got a youtube link (http://www.youtube.com/watch?v=1ZCCOcWUuOg). This link is the 1st part of a series of 27 videos.


_____________________________________________
One ounce of practice is more important than tonnes of dreams
Post #1501451
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse