Viewing 15 posts - 16 through 30 (of 241 total)
Hi Scott. The online index rebuild is, unfortunately, only available in Enterprise Edition based on what I see here. The OP has Standard Edition.
December 30, 2020 at 4:38 pm
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...
December 30, 2020 at 4:33 pm
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...
December 30, 2020 at 3:59 pm
What is the setting "RegisterAllProvidersIP" set to? Check out this link about AGs in a multi-subnet configuration.
December 30, 2020 at 3:50 pm
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...
December 30, 2020 at 3:37 pm
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...
December 30, 2020 at 3:30 pm
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.
September 10, 2020 at 5:08 am
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...
July 19, 2020 at 1:10 am
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...
July 19, 2020 at 1:00 am
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?
"A distributed availability group requires...
July 19, 2020 at 12:34 am
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?
July 19, 2020 at 12:21 am
Can you elaborate more? What symptoms are you experiencing and how did you diagnose the scenario as a "worker thread issue"?
July 19, 2020 at 12:15 am
What vesion of SQL Server is involved? Is it 2012, 2014, 2016, etc. Also, why are you saying you need Enterprise Edition on your failover cluster? You can set up...
July 19, 2020 at 12:09 am
For AlwaysOn AGs, you can look at there is an extended Events Health Session that can be examined to find information about failovers. I would also be curious to know...
July 18, 2020 at 11:40 pm
My question would be, why do you want to mix replication and AlwaysOn Availability Groups? What problem are you trying to solve by doing that? Mixing them is going to...
July 18, 2020 at 11:30 pm
Viewing 15 posts - 16 through 30 (of 241 total)