![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-56.png\")
<\/p>\n
<\/p>\n\n
\u00d6nceki yaz\u0131daki gibi T\u00fcm a\u015famalar tamamland\u0131ktan sonra Object Explorer<\/strong> \u00fczerinden Availability Replicas<\/strong>, Availability Databases<\/strong> ve Availability Group Listeners<\/strong> \u0131 monitor etme ilgili availability group \u00fczerinde sa\u011f t\u0131klanarak Show Dashboard<\/strong> se\u00e7ilirek a\u015fa\u011f\u0131daki gibi yap\u0131l\u0131r.<\/p>\n Yukardaki Dashboarddan g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi SQLC1 adl\u0131 Instance Primary durumda, SQLC2 adl\u0131 Instance Secondary durumda ve FailoverModelar\u0131 Automatic olup senkronizasyon durumunda da s\u0131k\u0131nt\u0131 bulunmamaktad\u0131r.<\/p>\n AlwaysOn da bulunan TESTDB mize a\u015fa\u011f\u0131daki gibi s\u00fcrekli data insert edip secondary ye anl\u0131k geldi\u011fini ve Readable oldu\u011funu g\u00f6sterece\u011fiz.<\/p>\n <\/p>\n <\/p>\n Primary olan SQLC1 e veri giri\u015fi yap\u0131l\u0131rken a\u015fa\u011f\u0131daki gibi SQLC2 den sorgu \u00e7ekti\u011fimizde neredeyse anl\u0131k olarak veriler SQLC2 yede gelmektedir. Bu neredeyse anl\u0131k Senkronizasyonda en \u00f6nemli katk\u0131 Networksel olarak sunucular\u0131n ayn\u0131 blogda yanyana olmas\u0131ndand\u0131r ve networksel olarak hi\u00e7bir waitin ya\u015fanmamaktad\u0131r.<\/p>\n <\/p>\n <\/p>\n SQL Server AlwaysOn da verilerin anl\u0131k olarak Secondary e gitti\u011fini g\u00f6sterdik. \u015eimdi Manuel olarak Failover yapal\u0131m ve durumu g\u00f6relim. Primary sunucuda herhangi bir maintenance yap\u0131laca\u011f\u0131 zaman sunucu bak\u0131mlar\u0131 vs s\u0131ras\u0131nda bu y\u00f6ntemi kullanabilirsiniz.<\/p>\n AlwaysOn dashboard dan a\u015fa\u011f\u0131daki gibi Start Failover Wizard \u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz. \u00c7al\u0131\u015ft\u0131r\u0131lmadan \u00f6nce son kez kontrol ediyoruz SQLC1 Primary durumda, SQLC2 ise Secondary durumdad\u0131r.<\/p>\n Bizim senaryomuzda SQLC1 primary SQLC2 Secondary oldu\u011fu i\u00e7in bu ad\u0131mda secondary a\u015fa\u011f\u0131daki gibi se\u00e7ip ba\u011flan\u0131yoruz.<\/p>\n <\/p>\n Next dedi\u011fimizde Failover \u00d6ncesi son kez bize bilgilendirme yap\u0131yor.<\/p>\n Failover \u0131 ba\u015flat\u0131yoruz.<\/p>\n Ve Failover i\u015flemi tamamland\u0131.<\/p>\n tekrar gidip SQL Server AlwaysOn Dashboard u a\u00e7t\u0131\u011f\u0131m\u0131zda a\u015fa\u011f\u0131daki gibi SQLC1 art\u0131k Secondary durumda, SQLC2 ise Primary durumdad\u0131r.<\/p>\n <\/p>\n AlwaysOn listener name yada IP kullan\u0131ld\u0131\u011f\u0131 durumda bu Failover saniyeler i\u00e7inde ger\u00e7ekle\u015fti\u011fi i\u00e7in \u00e7okta hissedilmez ve uygulamadaki kesinti minimum d\u00fczeyde olacakt\u0131r.<\/p>\n B\u00f6ylece bu yaz\u0131n\u0131nda sonuna gelmi\u015f bulunmaktay\u0131m bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek dile\u011fiyle esen kal\u0131n…<\/p>\n\n <\/p>\n Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda a\u015fa\u011f\u0131daki konularda 7×24 Uzman Dan\u0131\u015fmanlara yada E\u011fitimlere mi\u00a0<\/span>\u0130htiyac\u0131n\u0131z var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n – Oracle Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span> <\/p>\n","protected":false},"excerpt":{"rendered":" Merhaba Arkada\u015flar, Bu yaz\u0131mda sizlere SQL Server AlwaysOn u anlatmaya devam edece\u011fim. Bu yaz\u0131 \u00f6nceki iki yaz\u0131n\u0131n devam\u0131 niteli\u011findedir.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,23],"tags":[108,460,508,614,1000,1031,1515,1577,1583,1594,1601,1618,1619,1632,1647,1653],"class_list":["post-5051","post","type-post","status-publish","format-standard","","category-sql-server","category-veritabani","tag-alwayson","tag-database-high-availability","tag-deveci","tag-failover","tag-log-shipping","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-server","tag-sql-server-2008","tag-sql-server-2008-log-shipping","tag-sql-server-2012-alwayson","tag-sql-server-alwayson","tag-sql-server-alwayson-kurulumu","tag-sql-server-disaster-recovery","tag-sql-server-high-availability","tag-sql-server-log-shipping"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=5051"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5051\/revisions"}],"predecessor-version":[{"id":5762,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/5051\/revisions\/5762"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=5051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=5051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=5051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-25.png\")
<\/p>\nuse TESTDB\r\ncreate table TestTable(\r\ncol1 int identity(1,1) not null,\r\ncol2 datetime null\r\n)\r\n\r\nuse TESTDB\r\nalter table TestTable add constraint DF_TestTable_col2 default (getdate()) for col2\r\ngo\r\n\r\n\r\nuse TESTDB\r\nset nocount on\r\ngo\r\n\r\nwhile 1=1\r\nbegin\r\ninsert TestTable values(default)\r\nwaitfor delay '00:00:05'\r\nend<\/pre>\n
![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-26.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-27.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-28.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-29.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-30.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-31.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-32.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-33.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-34.png\")
<\/p>\n![\"\"](\"https:\/\/salihdeveci.files.wordpress.com\/2019\/01\/sql-server-2012-alwayson-35.png\")
<\/p>\n
\n– Oracle Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Exadata Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Exadata Bak\u0131m ve Destek<\/span>
\n– SQL Server Veritaban\u0131 Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– SQL Server Veritaban\u0131 Bak\u0131m ve Destek<\/span>
\n– Goldengate Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Goldengate Bak\u0131m ve Destek<\/span>
\n– Linux Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Linux Bak\u0131m ve Destek<\/span>
\n– Oracle EBS Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EBS Bak\u0131m ve Destek<\/span>
\n– Weblogic Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Weblogic Bak\u0131m ve Destek<\/span>
\n– Oracle Veritaban\u0131 E\u011fitimleri<\/span>
\n– Oracle VM Server Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle VM Server Bak\u0131m ve Destek<\/span>
\n– Oracle EPPM Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle EPPM Bak\u0131m ve Destek<\/span>
\n– Oracle Primavera Dan\u0131\u015fmanl\u0131\u011f\u0131<\/span>
\n– Oracle Primavera Bak\u0131m ve Destek<\/span>
\n– Oracle E\u011fitimleri<\/span>
\n– SQL Server E\u011fitimleri<\/span>
\n– Goldengate E\u011fitimleri<\/span>
\n– Exadata E\u011fitimleri<\/span>
\n– Linux E\u011fitimleri<\/span>
\n– Oracle EBS E\u011fitimleri<\/span>
\n– Oracle VM Server E\u011fitimleri<\/span>
\n– Weblogic E\u011fitimleri<\/span>
\n– Oracle EPPM E\u011fitimleri<\/span>
\n– Oracle Primavera E\u011fitimleri<\/span><\/p>\n