From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Configure read-only routing - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Configure read-only routing
- Since each node in an availability group contains a complete copy of the replica database, they could all be put to use. These are called Active Secondary Capabilities and they help take some of the load off the primary replica database. The first capability is called Readable Secondary Replicas. While technically the secondary databases aren't read-only, the secondary replica only allows users read-only access to them. These databases are still writable by the availability group in order to maintain parody with the primary database. Transactions are copied over and applied to the secondary database. So it's safe to say that they're still dynamic and up to date. By allowing users read-only access, loads can be spread out across all nodes in the failover cluster. This happens automatically when a feature called Read-Only Routing in enabled. Users connect to an availability group through a listener. This is what allows them to access the database through a static IP address when any…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.