What are the AlwaysOn capabilities and options available SQL Server 2012 ?

Following are list of AlwaysOn capabilities and options are available.

AlwaysOn Availability Group with the following options

  • Failover a group of databases
  • Add a single secondary using the asynchronous availability mode
  • Force failover to the asynchronous secondary
  • Suspend and resume data movement
  • Enable the secondary for read and execute read query on the secondary
  • Create a virtual name for the availability group and have application connect using the virtual name
  • Configuring availability group using:
  • Transact-SQL statement
  • AlwaysOn wizard
  • Powershell cmdlets
  • Troubleshoot using DMVs, Performance Monitor Counters and Extended events

AlwaysOn Failover Cluster Instance Enhancements

  • Create a multi-site cluster across subnets
  • Enable flexible failover policy
  • Improved diagnostics

What is AlwaysOn Failover Cluster Instance ?

AlwaysOn failover cluster instance provides availability for the entire SQL Server instance by enabling failover of the instance rather than individual database(s).

AlwaysOn failover cluster instance enhances the existing SQL Server Failover Clustering with support for the following capabilities:

  • Multi-site clustering across subnets for improved site protection.
  • Flexible failover policy for better control over instance failover.
  • Improved diagnostics for faster troubleshooting.
  • tempdb on local drive allows better query performance.

Both AlwaysOn Availability Group and AlwaysOn Failover Cluster Instance rely on Windows Server Failover Clustering infrastructure which provides a robust and reliable high availability platform.

What is AlwaysOn Availability Group ?

What is AlwaysOn Availability Group ?

AlwaysOn Availability Group is the new capability that provides protection for application database(s). This capability not only provides all the functionality that current Database Mirroring capability provides but also comes with a rich set of options that improves database availability and also introduces capabilities that enable better resource utilization.

AlwaysOn Availability Group is the recommended HA capability for database availability.

The key availability options are:

  • Failover a group of databases.
  • Multiple secondaries for improved redundancy.
  • Two synchronous secondaries for better data protection.
  • Asynchronous active log synchronization for high latency networks.
  • Flexible Failover Policy for greater control over failover.
  • Automatic page repair for protection against page corruption.
  • Encryption and compression provides a secure, high performing transport.
  • Virtual name for fast application failover.

Active Secondary

Apart from the different availability options Availability Group introduces Active Secondary that enables improved utilization of secondary hardware. Active Secondary enables.

Offloading read workloads to a secondary instance.
Full and transaction log backup on a secondary instance.

These are options that can be set at the Availability Group for each of the secondaries.

Simplified Deployment and Management

Availability Group also comes with an integrated set of tools that simplifies high availability deployment and makes management of a complex topology very easy:

AlwaysOn Availability Group Wizard—Simplifies capturing high availability requirement and creation of availability group.
AlwaysOn Dashboard—Provides key system information that allow admins to make quick operational decisions and diagnose and troubleshoot problems.
AlwaysOn MOM pack for System Center—Enables using system center for monitoring SQL Server High Availability deployments.

AlwaysOn also provides full Powershell integration using new cmdlets that enables complete automation of Availability Group deployment.

In addition, AlwaysOn comes with a great set of troubleshooting tools that includes Dynamic Management Views (DMVs), performance monitor counters and extended events.

Troubleshooting: ATEN KVMP Switch CS-1734A

Troubleshooting: ATEN KVMP Switch CS-1734A

Being in Server management job, KVM switch is common for management of servers.One such switch i’m using is ATEN CS-1734A.

CS1734A is a 4 Port USB KVM Switch which has built-in USB on each of the front and rear panels and audio signal connectors. It allows users to control the computer and peripheral devices via a signal console at ease.

Following are the Major Features of CS1734A KVM Switch

  • One USB console controls 4 computers and two additional USB devices
  • 2 port USB Hub built in
  • With speaker and microphone support
  • Computer selection via front panel pushbuttons and hotkeys
  • Superior video quality – up to 2048 x 1536; DDC2B

As it is 4 port KVM switch it suddenly stopped switching between third and fourth computers. When i try to switch to third and fourth  computer it goes to first and second computer respectively. So thought of troubleshooting the KVM Switch by

What is SQL Server AlwaysOn in SQL Server 2012 ?

What is SQL Server AlwaysOn in SQL Server 2012 ?

SQL Server AlwaysOn is the new comprehensive high availability (HA) and disaster recovery solution for SQL Server 2012. Using AlwaysOn, businesses can now achieve increased application availability and get better return on their hardware investments through a simplified HA deployment and management experience.

AlwaysOn comes with new and enhanced capabilities that can provide availability for specific application database(s) and also the entire instance which provides the flexibility to support various high availability configurations:

• AlwaysOn Availability Group is the new capability that helps protect application databases from both planned and unplanned downtime.
• AlwaysOn Failover Cluster Instance provides protection for the entire instance and is an enhancement to the existing SQL Server Failover Cluster Instance.

Both AlwaysOn Availability Group and AlwaysOn Failover Cluster Instance rely on Windows Server Failover Clustering infrastructure which provides a robust and reliable high availability platform.

AlwaysOn Availability Group

AlwaysOn Availability Group is the new capability that provides protection for application database(s). This capability not only provides all the functionality that current Database Mirroring capability provides but also comes with a rich set of options that improves database availability and also introduces capabilities that enable better resource utilization.

The key availability options are:
• Failover a group of databases.
• Multiple secondaries for improved redundancy.
• Two synchronous secondaries for better data protection.
• Asynchronous active log synchronization for high latency networks.
• Flexible Failover Policy for greater control over failover.
• Automatic page repair for protection against page corruption.
• Encryption and compression provides a secure, high performing transport.
• Virtual name for fast application failover.

Active Secondary

Apart from the different availability options Availability Group introduces Active Secondary that enables improved utilization of secondary hardware. Active Secondary enables.
• Offloading read workloads to a secondary instance.
• Full and transaction log backup on a secondary instance.
These are options that can be set at the Availability Group for each of the secondaries.
Simplified Deployment and Management
Availability Group also comes with an integrated set of tools that simplifies high availability deployment and makes management of a complex topology very easy:
• AlwaysOn Availability Group Wizard—Simplifies capturing high availability requirement and creation of availability group.
• AlwaysOn Dashboard—Provides key system information that allow admins to make quick operational decisions and diagnose and troubleshoot problems.
• AlwaysOn MOM pack for System Center—Enables using system center for monitoring SQL Server High Availability deployments.
AlwaysOn also provides full Powershell integration using new cmdlets that enables complete automation of Availability Group deployment.
In addition, AlwaysOn comes with a great set of troubleshooting tools that includes Dynamic Management Views (DMVs), performance monitor counters and extended events.

AlwaysOn Failover Cluster Instance

AlwaysOn failover cluster instance provides availability for the entire SQL Server instance by enabling failover of the instance rather than individual database(s).

AlwaysOn failover cluster instance enhances the existing SQL Server Failover Clustering with support for the following capabilities:
• Multi-site clustering across subnets for improved site protection.
• Flexible failover policy for better control over instance failover.
• Improved diagnostics for faster troubleshooting.
• tempdb on local drive allows better query performance.
Both AlwaysOn Availability Group and AlwaysOn Failover Cluster Instance rely on Windows Server Failover Clustering infrastructure which provides a robust and reliable high availability platform.

Apart from the new AlwaysOn solution, SQL Server 2012 provides support for Windows Server Core. This reduces OS patching and consequently system reboots which increases application availability by as much as 50-60%.

There are also enhancements to online operations and that now includes reindexing of LOB columns and addition of non-null columns which increases availability during application upgrade.

AlwaysOn Availability Group will be the primary high availability and disaster recovery feature for databases and will replace database mirroring technology over two releases. Database Mirroring will still be available as a feature in SQL Server 2012.

Peer-Peer replication will continue to be available in future releases and is the primary solution for scenarios requiring multi-site updates and multi-master replication. Log shipping will continue to be available in future releases.

How to create a database in SQL Server 2012 by using SQL Server Management Studio and Transact-SQL.

How to create a database in SQL Server 2012 by using SQL Server Management Studio and Transact-SQL. Read more of this post

Hardware and Software Requirements for Installing SQL Server 2012

Hardware and Software Requirements for Installing SQL Server 2012

The following list described below are the minimum hardware and software requirements to install and run SQL Server 2012.

Read more of this post

What’s New in SQL Server 2012 Installation

What’s New in SQL Server 2012 Installation

SQL Server 2012 introduces the following changes to SQL Server Setup:

Datacenter Edition: Datacenter edition which was introduced in SQL Server 2008 R2 is no longer available as a SQL Server 2012 edition. Read more of this post

Private cloud

Private cloud is cloud infrastructure operated solely for a single organization, whether managed internally or by a third-party and hosted internally or externally.

A private cloud is a new model for IT delivery. It turns a datacenter’s infrastructure resources into a single compute “cloud” and enables the key benefits of cloud computing:

Pooled Resources
In a private cloud, your key resources—compute, storage, and networking—are pooled and abstracted into units that enable you to dynamically provision and scale applications and resources.

Read more of this post

Download SQL Server 2012 Transact-SQL DML Reference Ebook free

Download SQL Server 2012 Transact-SQL DML Reference Ebook free

SQL Server 2012 Books Online

Download SQL Server 2012 Transact-SQL DML Reference Ebook free

Reference

Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2012. Use these statements to add, modify, query, or remove data from a SQL Server database.
Applies to: SQL Server 2012
Source: Microsoft SQL Server 2012 Books Online

E-book publication date: May 2012
263 pages

Download Links below
EPUB Ebook Download| MOBI Ebook Download| PDF Ebook Download|