AlwaysOn

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups

01/08/2024 / By / AlwaysOn, Indexing, SQLServer / Leave a Comment

On January 25, 2024 and on February 22, 2024 I will run two SQLpassion Live Trainings about SQL Server Query Tuning Strategies and SQL Server Availability Groups. In the training about SQL Server Query Tuning Strategies I will cover the following areas: Index Tuning Strategies Search Arguments Bookmark Lookup Operations Tipping Point Index Intersection Filtered …

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups + read more

Exploring the Query Store on Secondary Replicas in SQL Server 2022

11/22/2023 / By / AlwaysOn, SQLServer / 1 Comment

SQL Server 2022 introduces an exciting feature: the ability to access the Query Store from a secondary replica in an Availability Group. This enhancement offers a significant advantage, allowing you to redirect troubleshooting tasks to a secondary replica without impacting the performance of the primary replica. It’s crucial to note that all replicas (primary and …

Exploring the Query Store on Secondary Replicas in SQL Server 2022 + read more

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups

04/17/2023 / By / AlwaysOn, Indexing, SQLServer / Leave a Comment

On May 16, 2023 and on June 15, 2023 I will run two SQLpassion Live Trainings about SQL Server Query Tuning Strategies and SQL Server Availability Groups. In the training about SQL Server Query Tuning Strategies I will cover the following areas: Index Tuning Strategies Search Arguments Bookmark Lookup Operations Tipping Point Index Intersection Filtered …

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups + read more

Adding a Replica back into a SQL Server Availability Group

09/25/2017 / By / AlwaysOn, SQLServer / Leave a Comment

In one of my last blog postings I have already described a common pitfall when you try to add a new Replica into an Availability Group. In today’s blog posting I want to talk a little bit more about how you can add a Replica back into an Availability Group – when you have removed …

Adding a Replica back into a SQL Server Availability Group + read more

Adding Replicas into existing Availability Groups

09/18/2017 / By / AlwaysOn, SQLServer / Leave a Comment

Last week I have blogged about how you can run the Availability Group traffic through a different network card. In today’s blog posting I want to talk about some side effects of this approach when you want to add a new Replica into an existing Availability Group. Add new Replicas SQL Server Management Studio is …

Adding Replicas into existing Availability Groups + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.