SQL Server alwayson - part 1

In this video, you will learn SQL Server 2012 AlwaysON availability groups.

[Niravgandhi]

I had been struggling with this concept, Now thanks to your explanation, I made a video about it in Azure. Glad I subscribed to you.

[ajiteshmalhotra]

I partially agree with you, mirroring is perfect for DR but mirroring need more bandwidth.so that is the reason not in all projects using mirroring for DR prospective.

[lidiagaravaglia]

Wonderfully explained, thanks a lot for sharing!

Thank you, I was looking for a high level explanation of the options in SQL Server for DR and HA, I am Oracle DBA, but I have been asked to look after a few SQL Server databases and offer some recommendations for HA and DR, excellent begiging.

We already migrated the databaes to SQL Server 2012, I think AlwaysOn will offer what we are looking for.

[David_Plane_Spotting]

This was awesome...well explained and very easy to understand

[hteka]

This is just wow. Very simple to understand. Thanks for the video.

[aminex]

Great stuff -- keep making these awesome videos

[tayyabshahzad]

Thank yo sir for your tutorials They are great help for Oracle DBA like me.

[priyankavadlamudi]

your videos all ways rock-out for every one

[yclem]

Thanks So much, Very Very helpful, Thanks for your time, appreciated so much

[thesonglover]

Hi, Thanks for the great tutorial. I have one doubt, in the always on setup you have configured VSQL and node1 in sql server failover clustering and kept node3 as standalone..any specific reason for that?

[eliasberhe]

You the best, you help me a lot, thank you so much sir.

[sridhar]

Really good explanation in simple terms

[nageshs]

Very nicely explained. Keep up your good work.

[priyankavadlamudi]

Dear ramu superb explication thanks a lot

[mohammadhoque]

easy, detailed  and easy to understand. thank  you

[sagaya]

Thank you so much for your wonderful explanation

[Deekudla]

Awesome explanation. Thanks a lot! I would like to know how SQL agent jobs will behave in always-on setup? Can you please explain or make video? It is real time requirement and will help the community. I have manually disabled few jobs in primary node, now do I have to manually disable jobs in node 2? how it will synch? Thanks in advance.

[inbedf]

SQL clustering / failover. I have query: 1) I need 4 SQL Server can access sing Data store and databases in replication mode. 4 SQL I can cluster togather (2 per site cross other 2 at other site under singe vcenter) but logically we define seperate site. I dont assigned luns but I have big 5TB Lun active/active mirroring and I am giving all VM 500GB each as D: drive partition volume from that 5TB Lun. All SQL VM have 500GB from same 5TB. so how I ensure that independent 500GB volumes each can be a part of SQL cluster and access same database if any of that server fails or crashed? any idea. If I can creat SQL_Lun1 2TB and that SQL_Lun1 give virtual RDM's volume to all SQL that will good idea but for that I have to make space and create lun, because I am asking question, I dont have more space to create luns, if I create luns I have to destroy lun and recreate space. But if any idea or technique to do volume partition to partition clustering than that helps. Any idea.

[rorymcmanus]

Well explained! Though funny how he pronounces the word 'Down' Scottish