Viewing 15 posts - 1 through 15 (of 289 total)
I also suspect index maintenance. If so, associated LDF growth can be minimized by temporarily changing tlog backup frequency to something very frequent (e.g. 30sec) while index maintenance is running,...
October 25, 2019 at 9:07 pm
I think suspending would not help anyway, just would defer all that work until later (and I think it piles up in the LDF?).
Another way to possibly improve things would...
October 25, 2019 at 9:02 pm
I am not good at this stuff, really not a fan of XML, but here's an example of approach I use. Crude example, but maybe enough to get you started. ...
October 21, 2019 at 3:23 pm
All good replies above. I have never heard of subqueries referred to as dynamic queries.
October 11, 2019 at 2:04 pm
Thoughtful posts like this make me love this site. Thanks, Steve.
September 30, 2019 at 3:08 pm
You're right...changing connection strings is another story. But you should be able to have the AG ready for that during business hrs, whenever you want, with no impact. I can't...
September 26, 2019 at 7:26 pm
JimKern - thanks for posting all the follow-up after answering your own question. good stuff.
September 26, 2019 at 3:57 pm
Are we able to add this database to an AG during business hours? YES. Definitely.
Is there a performance difference between Synchronous and Async? YES. Many people claim it is not...
September 26, 2019 at 3:50 pm
We get these msgs on an AG where the sector sizes ("Bytes Per Physical Sector") are indeed different between datacenters. No easy solution, so we live with it. I have...
August 13, 2019 at 4:15 pm
August 8, 2019 at 1:22 pm
The listener is just a name/address, has nothing to do with voting. Otherwise I think you're on the right track.
I'm not sure if this is best practice, but when we...
August 8, 2019 at 12:59 pm
What Michael L John said. We've been doing this since 2012, works well.
July 9, 2019 at 2:52 pm
We have implemented AGs between two 2-node FCIs, as well as between a 2-node FCI and a standalone instance. No real problems. We generally like it.
I don't think there is...
May 7, 2019 at 7:41 pm
I see. Maybe I'll grow into it, will give it a few weeks. Probably should have waited before posting. Maybe just put off by the white space? It feels mobile-ish. ...
April 4, 2019 at 3:38 pm
In failover cluster mgr right click on the AG resource, properties, dependencies, and ensure AG resource is dependent on your listener. If not you can add that dependency here. If...
January 8, 2019 at 7:55 am