Tags » AlwaysOn

AlwaysOn – Monitoring and Alerting

–by Ginger Keys

AlwaysOn Availability Groups is a great new feature of SQL 2012 and 2014. This feature is a combination of database mirroring and failover clustering, and it provides a strong level of high availability and disaster recovery; however there is no straightforward monitoring/alerting processes to go along with this new functionality. 1,492 more words

SQL Server

Disrupting an Industry in Need of Disruption: Cloudwords Selected as an AlwaysOn Global 250 Winner

Cloudwords’ translation automation platform helps companies identify new revenue opportunities and grow global market share, and we’re proud to again be included among the leading global innovators—some of which are also our customers!—whose game-changing approaches and technologies are disrupting markets worldwide. 275 more words

Cloudwords

Alwayson Availability Group Replica is Not Synchronizing (Error: 976, Severity: 14, State: 1.)


For some reason you can lose communication between the primary and secondary replicas.

As known, there is a policy on SQL Server to check the data synchronization state of the database replica.  230 more words

AlwaysOn

Configuring SQL Server 2014 AlwaysOn Availability Group using PowerShell

Introduction

Earlier on I was trying to search for some scenarios to implement AlwaysOn Availability Groups using PowerShell, although I was able to find some interesting post however non of them represented a complete scenario starting from a fresh windows server installation (using… 731 more words

Powershell Script

Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas

Intro

AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like mirroring and log shipping. However, there is also additional complexity involved in implementing this technology, and one of the stickiest areas for database administrators is having to deal with non-contained objects, or objects that exist at the instance level, but not the database level (logins vs users, as an example). 1,126 more words

SQL Agent

Preparing for 70-462 Exam : Administering Microsoft SQL Server 2012 Databases | Certification

I’m from a Database development background and working mostly with T-SQL code only. I passed Exam 70-461 back in Nov-2012, and now I’m planing to give… 424 more words

SQL Server 2012

Steps for Installing SQL Server AlwaysOn Availability Groups

–by Ginger Keys

After you make sure you have everything in your environment ready to go and all the prerequisites that need to be done before deployment have been done, we are ready to install the AlwaysOn Availability Group! 1,419 more words

SQL Server