Archives
SQL Server 2012 – Always On
SQL Server has always focused on high availability solutions. In SQL Server 2008 R2 – the common options included clustering, mirroring, log shipping and replication. These solutions offer different options for different scenarios. If you want “service level” high availability – clustering is the right choice. Mirroring offered 1 to 1 database copy with automatic failover. Log shipping offered primary to multiple secondary database copies, without automatic failover. Replication allows us to select “parts of a database” to replicate to other servers. All of these ideas warrant much more detailed conversation – unrelated to the title of this blog.
SQL Server 2012 (Currently SQL Denali CTP3) introduces a new feature – Always On Availability Groups. Initial observations (from reading TechNet and working through hands-on labs) – Microsoft has taken the strong points from clustering and the strong points from Mirroring and combined them into one solution. Most notable consideration is the requirement for Windows Clustering.
Administrators build these Availability Groups which are comprised of Application Databases which work and fail(over) together – refered to as Availability Databases (give them a zero on creative naming ideas). The read/write availability group is called the primary replica and up to 4 secondary replicas which can be read only.
Additionally – there are options you can configure related to the transaction commit – asynchronous & synchronous (obvious) and several forms of failover.
From the looks of it – this will be widely accepted in the community. As always the case with CTP, Beta and everything else – the information stated above is subject to (and probably will) change prior to RTM versions of the product.
CertificationCamps.com is modifying our Microsoft training content to bring these new features into our SQL Administrator Bootcamp. We have added labs which explain the new SQL Server 2012 Availability Groups into our existing Cluster Hands On Instructor Led Demonstration.
Chester Flake
CertificationCamps.com
SQL 2008 R2 – New Feature – Utility Control Point (UCP)
Microsoft SQL Server 2008 R2 addresses some of the most “real world” administrative issues surrounding enterprise level multi-server administration with a new tool called the SQL Server Utility. This tool is in addition to the Policy Based Management (PBM) – Central Management Server and Data Collector introduced in the earlier 2008 release. The service used in the server utility is called Utility Control Point. The UCP collects information (every 15 minutes) to monitor multiple managed SQL instances. Data collected from the UCP is stored in the Utility Management Data Warehouse (UMDW) which is automatically created when you create the UPC. The primary administrative interface tool – Utility Explorer is used to create the UCP, add instances and view reports of data collected. Of course – all of this would be meaningless without some really cool, colorful chart driven report – which is where we get the Utility Explorer Dashboard. Do you think Microsoft is trying to push the “utility” point in the choice of naming conventions?
Getting started with the SQL Server Utilities is quite intuitive. From the SSMS Interface, simply click View and Utility Explorer. You’ll see a link for “Create a Utility Control Point” and you’re off to the races.
Microsoft has recently updated the 70-432 exam with questions related to the new features of SQL 2008r2. We demonstrate this and other new SQL 2008 R2 features in our 7 day SQL 2008 R2 Admin bootcamp at CertificationCamps.com
Chester Flake, MCT, MCLC, MCITP, MCTS, MCPD, MCAD, MCDTS, MCSE, MCSA
chester@certificationcamps.com