Blog

It’s the feature with all the buzz – I’ve blogged about why AlwaysOn is so cool, Kendra’s showed you how to set up a lab, and I’ve given you a screenshot tour of the setup. You’re ready to get your feet wet, but…

You’re faced with a bewildering array of options and new terms. Should all the databases be in one availability group? What service accounts and IP addresses will you need? How will failover work? In this video, I’ll get you started with a simple checklist of things to consider before deploying your first SQL Server 2012 instance:

Want More AlwaysOn Info?

For more, check out our resources page at BrentOzar.com/go/alwayson. It includes the first version of our brand-spankin’ new AlwaysOn Availability Groups Setup Checklist PDF – a six-page doc to get you started with the details of planning, Windows configuration, and SQL Server setup required.  Enjoy!

↑ Back to top
  1. When using AlwaysOn Availability Groups, suppose the databases that are taking part in such a group have a number of SQL Agent jobs that run stored procedures, or even worse, SSIS packages.

    The jobs don’t move to another replica together with the database, so how would you manage these jobs? They should only run on the primary replica…

    This is, according to me, unless you can point me towards a solution, one of the big shortcomings of AlwaysOn Availability Groups.

    • Wim – the easiest way to do this is run jobs from a central job server with SSIS or SQLCMD, and point to the listener name. That way the queries always hit the live server. I’d rather not run SSIS on mission-critical SQL Servers anyway – SSIS wants to use memory, as does the SQL Server engine.

  2. Just wanted to thank you for the Planning for SQL Server 2012 AlwaysOn Availability Groups
    video. I am planning to use it as an initial orientation to our server management group with respect to availability groups and the need for the new clustering approach.
    This is really really helpfull especially if accomplanied by doughnuts.

  3. Pingback: T-SQL Tuesday: A Day in the Life | Bob Pusateri - The Outer Join

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

css.php