info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance






October 21, 2024

Distributed Always On Group Scripts
by BF (Principal Consultant; Architecture; Engineering)
sys.availability_groups, sys.availability_replicas, sys.dm_hadr_availability_replica_states
Read More
Tags SQLServerAlwaysOn
November 4, 2023

Check Always On Availability Groups Health
by BF (Principal Consultant; Architecture; Engineering)
sys.dm_hadr_database_replica_states
Read More
Tags SQLServerAlwaysOn
April 23, 2023

Designing a Microsoft SQL Server Always On High Availability Stacked w/ Distributed Availability Groups
by BF (Principal Consultant; Architecture; Engineering)
AOAG
Read More
Tags SQLServerAlwaysOn
June 20, 2022

SQL Agent Jobs - Enable, Disable, Stop - Commands
by BF (Principal Consultant; Architecture; Engineering)
sysjobs, sysjobhistory, sysjobschedules, sysoperators
Read More
Tags SQLServerAlwaysOn
May 20, 2022

Always On Synch Lag
by BF (Principal Consultant; Architecture; Engineering)
sys.dm_hadr_database_replica_states, sys.availability_replicas, sys.dm_hadr_availability_replica_states
Read More
Tags SQLServerAlwaysOn
September 5, 2021

Microsoft SQL Server Always On Availability Groups Architecture Design
by BF (Principal Consultant; Architecture; Engineering)
High Availability & Disaster Recovery
Read More
Tags SQLServerAlwaysOn
April 4, 2021

Get all Ports configured in Always On Availability Groups Environment
by BF (Principal Consultant; Architecture; Engineering)
Enter Short Description Here
Read More
Tags SQLServerAlwaysOn
January 23, 2021

Always On Health Dashboard
by BF (Principal Consultant; Architecture; Engineering)
availability_replicas, dm_hadr_database_replica_cluster_states, dm_hadr_database_replica_states, dm_hadr_availability_replica_states
Read More
Tags SQLServerAlwaysOn
October 31, 2020

Automate Enable or Disable SQL Jobs in Always On Nodes
by BF (Principal Consultant; Architecture; Engineering)
sys.availability_groups_cluster, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.availability_group_listeners, sysjobs
Read More
Tags SQLServerAlwaysOn
June 20, 2020

Windows Failover Cluster - Using Paxos Tag to monitor cluster configuration synchronization across the system
by BF (Principal Consultant; Architecture; Engineering)
WSFC, Always On Availability Groups
Read More
Tags SQLServerAlwaysOn
May 12, 2020

Always On - Check if Primary Replica
by BF (Principal Consultant; Architecture; Engineering)
sys.availability_groups_cluster, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.availability_group_listeners
Read More
Tags SQLServerAlwaysOn
August 22, 2018

T-SQL - Check Always On Transactional Replication re-directed Publisher to Listener Name
by BF (Principal Consultant; Architecture; Engineering)
dbo.sp_validate_redirected_publisher, dbo.sp_Validate_Replica_Hosts_As_Publishers, dbo.MSRedirected_Publishers
Read More
Tags SQLServerAlwaysOn
July 5, 2018

File share witness resource failed to arbitrate for the file share. Please ensure that file share exists and is accessible by the cluster.
by BF (Principal Consultant; Architecture; Engineering)
Logon failed for user SQLCluster01
Read More
Tags SQLServerAlwaysOn
February 2, 2018

Always On: The availability replica manager is going offline because the local Windows Server Failover Clustering (WSFC) node has lost quorum.
by BF (Principal Consultant; Architecture; Engineering)
SQL Server Error Log, Failover Cluster Cluster Events, Cluster.log
Read More
Tags SQLServerAlwaysOn
January 9, 2018

SQL Always On Monitor
by BF (Principal Consultant; Architecture; Engineering)
Captures, Logs, Alerts & Reports for Microsoft SQL Server Always On Availability Groups Metrics.
Read More
Tags SQLServerAlwaysOn
December 12, 2017

Replacement of Remote Transactional Replication Distributor in an Always On Setup
by BF (Principal Consultant; Architecture; Engineering)
Enter Short Description Here
Read More
Tags SQLServerAlwaysOn
December 11, 2017

Huge Transaction Log File with Always-ON Availability Group Database in SQL Server 2016 STD
by BF (Principal Consultant; Architecture; Engineering)
log_reuse_wait_desc, DBCC sqlperf(logspace), DBCC LogInfo
Read More
Tags SQLServerAlwaysOn
December 9, 2017

"The specified network name is no longer available" error while connecting On Premise Applications to Azure Always On Listener.
by BF (Principal Consultant; Architecture; Engineering)
MTU Setting
Read More
Tags SQLServerAlwaysOn
May 12, 2017

Log Reader Agent not starting after AlwaysON Availability Groups Failover
by BF (Principal Consultant; Architecture; Engineering)
During recent testing of a new Microsoft Azure Cloud setup of SQL Server 2016 Standard running Always On Availability Groups Basic...
Read More
Tags SQLServerAlwaysOn
February 27, 2017

SQL Server High Availability - Monitor AlwaysON Availability Groups using Powershell, DMVs and TSQL
by BF (Principal Consultant; Architecture; Engineering)
Enter Short Description Here
Read More
Tags SQLServerAlwaysOn
February 17, 2017

Azure Virtual Machines running SQL Server 2016 STD AlwaysON Availability Groups w/ Transactional Replication
by BF (Principal Consultant; Architecture; Engineering)
A High Availability & Disaster Recovery Solution
Read More
Tags SQLServerAlwaysOn
January 18, 2017

Calculate RTO(Recovery Time Objective) in AlwaysON Availability Groups
by BF (Principal Consultant; Architecture; Engineering)
sys.dm_hadr_availability_replica_cluster_nodes, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.dm_hadr_database_replica_states, sys.availability_replicas
Read More
Tags SQLServerAlwaysOn
December 1, 2016

Find out when an AlwaysOn Availability Group Failover occurred
by BF (Principal Consultant; Architecture; Engineering)
sys.dm_xe_sessions, sys.dm_xe_session_targets, sys.messages
Read More
Tags SQLServerAlwaysOn
November 19, 2016

Using Extended Events to Monitor Microsoft SQL Server AlwaysOn Availability Groups
by BF (Principal Consultant; Architecture; Engineering)
Capture DDL, Capture Availability Replica State Changes, Capture Total Events Captured
Read More
Tags SQLServerAlwaysOn
Future Events
DevIntersection
Microsoft Ignite
PASS Summitt
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerPerformance
SQLServerHealthCheck
Powershell
AzureSQLDatabase
SQLServerAlwaysOn
DataMigration
SQLServerReplicationMonitor
AzureVirtualMachine
SQLServer2016
ExtendedEvents
Metrics
QueryTuning
ReportingServices
SQLServerAgent
WindowsFailoverCluster
SQLServerManagementStudio
SQLServerTransactionLog
SQLServerArchitecture
DMVs
AzureStorage
Pinned Posts
Microsoft SQL Server Always On Availability Groups Architecture Design
Create a Microsoft SQL Server Audit Report using Powershell
SQL Space Monitor - Version 2
T-SQL - Constants vs Parameters vs Local Variables - Execution Plans, Statistics, Assumptions
SQL Server - File IO - Sizes, Usage, Stats - Write(Insert) vs Read(Select)
Azure Virtual Machines running SQL Server 2016 STD AlwaysON Availability Groups w/ Transactional Replication
T-SQL Transform Row Data into Columns using PIVOT
List all SQL Server Reporting Services Subscriptions
Calculate RTO(Recovery Time Objective) in AlwaysON Availability Groups
T-SQL Get Maximum Value from a list of Columns Values
SQL Server 2016 Compress() & Decompress()
JSON in SQL Server 2016
Temporal Tables in SQL Server 2016
T-SQL Merge
T-SQL Pivot Data


©2015 www.TechDevOps.com