We don't have any maintenance on DB. It is a virtual machine. I saw that a lot of indexes take a lot of space:

Everything works very slow.  The same...

Since there is no maintenance in place for the databases, I would encourage you to go to https://ola.hallengren.com/ and download the maintenance solution. Run the .sql file you get from...

I like what Lou is asking. What are you hoping to achieve, especially with putting nodes 1 and 2 that are in the same location on different subnets? What problem...

Hi Scott. The online index rebuild is, unfortunately, only available in Enterprise Edition based on what I see here. The OP has Standard Edition.

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-ver15

What data do you have that the SQL Server is experiencing poor performance? What issues are you seeing or are being reported by end users?

Is the Query Store enabled for...

First, rebuilding indexes online is only available in Enterprise Edition and I don't see that you have specified what edition you have - whether Standard or Enterprise. Second, rebuilding indexes...

What is the setting "RegisterAllProvidersIP" set to? Check out this link about AGs in a multi-subnet configuration.

https://techcommunity.microsoft.com/t5/sql-server-support/connection-timeouts-in-multi-subnet-availability-group/ba-p/318334

Sounds like a search on "multi-subnet Availability Group" would find most of  the information you need. You will want the node in DR to be set up for Asynchronous AG...

• This reply was modified 3 years, 11 months ago by  lmarkum.

This sound a bit like there was a state change in your AG, meaning that a failover occurred, and there was maybe a large redo queue on the secondary that...

Not much traffic on this old thread, but I'd be happy to review articles. I could review articles on HA and DR technologies, performance tuning, SQL Server installation and configuration.

Check out this link : https://www.sqlskills.com/help/waits/preemptive_xe_gettargetstate/and this one: https://app.spotlightcloud.io/waitopedia/waits/PREEMPTIVE_XE_GETTARGETSTATE

I'm not entirely sure why this wait is a point of focus for you.  I highly doubt this is actually causing a...

1. Our SQL servers have multiple versions from 2005 version to 2017 versions with different editions,  what are the good strategies to manage such diverse server environments?

You have said that...

what is the reason for using a Distributed AG?  Have you followed the guidance in this link?  Especially, do you have a listener in place?

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver15#understand-distributed-availability-groups

"A distributed availability group requires...

Can you verify that you have the correct file for SP2?  Can you put in here the filename and/or link where you're downloading SP2 file from?

Can you elaborate more?  What symptoms are you experiencing and how did you diagnose the scenario as a "worker thread issue"?