Viewing 15 posts - 46 through 60 (of 1,080 total)
As with any stall value, you'd want it as low as possible, and by that, I mean under 5ms would be idea in most cases, in some cases that would...
October 6, 2017 at 8:29 am
SQL STD AG is a basic availability group, with no read only routing. Still sounds like your application is connecting to a node name and not a listener name.
October 6, 2017 at 6:19 am
If the 2 instances are on the same machine, did you allow for the 2016 instance to have sufficient memory, assuming you allocated everything to your 2012 instance previously?
set...
October 5, 2017 at 1:27 pm
Connect to your listener name and run SELECT @@SERVERNAME to confirm you are on your secondary node.
October 5, 2017 at 11:52 am
even I have my instance in preferred node, still i received an email stating "
September 29, 2017 at 7:56 am
September 29, 2017 at 7:29 am
You'll need to make use of Powershell on the Windows Cluster level, as that is where preferred nodes are set, and build you alerting around it.
https://technet.microsoft.com/en-us/library/ee460989.aspx - this...
September 28, 2017 at 9:50 am
You need traceflags, 1117 and 1118 - read up on each first before implementing.
1117 would keep your files growing equally - https://support.microsoft.com/en-us/help/2154845/recommendations-to-reduce-allocation-contention-in-sql-server-tempdb-d
September 20, 2017 at 12:13 pm
September 14, 2017 at 7:57 am
t.franz - Tuesday, September 12, 2017 6:34 AMTo be honest, I did not even understand the question and felt like a newbie...
We're...
September 12, 2017 at 6:50 am
You will need to provide a lot more for anyone to assist you, well, with any quality replies.
Post DDL, sample data, what you have tried so far.
September 11, 2017 at 10:30 am
That changes things, but you can do BAGs, Basic Availability Groups still, one DB per group, EDIT: in 2016 only again.
I know this might not be a solution for...
September 6, 2017 at 1:16 pm
If you can afford to carve off more storage, my vote would go to Availability Groups instead on 2 x standalone VMs.
No shared storage required, just use a file...
September 6, 2017 at 9:51 am
Viewing 15 posts - 46 through 60 (of 1,080 total)