Pages

▼
Showing posts with label AlwaysOn AG. Show all posts
Showing posts with label AlwaysOn AG. Show all posts
Wednesday, 19 June 2024

Some common reasons why the transaction log cannot be reused automatically

›
Managing SQL Server databases may sometimes be challenging especially when it comes to dealing with transaction log file internal space usag...
Wednesday, 17 January 2024

Looking deeper into the physical & logical architecture - Transaction Log File

›
Beyond all doubt, it is essential to have a good understanding of the Transaction Log (T-Log) so that we can diagnose unforeseen performance...
Thursday, 5 January 2023

New Features in SQL Server 2022 for DBAs

›
SQL Server 2022 brings a wealth of new features that empower DBAs to enhance database performance, security, and usability. By leveraging th...
Tuesday, 20 March 2018

Configuring Read-Only Routing and load-balancing across Read-Only replicas

›
With the arrival of AlwaysOn Availability Group in SQL Server 2012, implementing HA+DR solutions have been an easier and not expensive task ...
Thursday, 21 December 2017

Always On: Trying out Read-Only intent connections to secondary replicas

›
SQL Server Always On Availability Group enables us to connect Read-Only workloads to secondary replicas automatically by using differents wa...
Monday, 14 November 2016

How to create new Logins and Users for an AlwaysOn Availability Group

›
(This tip also applies for Log Shipping and Database Mirroring) Surely, after setting up an AlwaysOn Availability Group (AG) we are going ...
3 comments:
Friday, 30 September 2016

Creating alerts for monitoring proactively SQL Server AlwaysOn Availability Groups

›
When it comes to monitoring databases we have to do it proactively by using alerts implemented natively or via T-SQL code inside SQL Jobs ru...
Friday, 3 June 2016

How to move the files of database which has Replication, Mirroring, Log Shipping or AlwaysOn Settings

›
One of the challenging tasks in the life of a DBA is definitely moving all or some of the files of a database from one physical location to ...
Wednesday, 1 June 2016

How to test Read-Only Intent Connection from SQL Management Studio

›
As part of some SQL Server AlwaysOn Availability implementations, we may need to test Read-Only Intent Connection in someway to make sure th...
Sunday, 1 May 2016

AlwaysOn AG Listener: The attempt to create the network name and IP address for the listener failed

›
While working on a heap of High Availability and Disaster Recovery solutions, I was challenged to deal with some complex errors that I had t...
Saturday, 16 January 2016

Error: “The local node is not able to communicate with the WSFC cluster” – AlwaysOn Availabiliy Group

›
At times, after having an AlwaysOn solution implemented, not only may the WSFC service run down, but also it may be corrupted for whatever r...