Viewing 15 posts - 46 through 60 (of 1,079 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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 5, 2017 at 1:27 pm
Connect to your listener name and run SELECT @@SERVERNAME to confirm you are on your secondary node.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 5, 2017 at 11:52 am
even I have my instance in preferred node, still i received an email stating "
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 29, 2017 at 7:56 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 28, 2017 at 9:50 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 28, 2017 at 8:13 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
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 20, 2017 at 12:13 pm
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 14, 2017 at 7:57 am
Had to check, thanks for the question.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 12, 2017 at 6:59 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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 6, 2017 at 9:51 am
Viewing 15 posts - 46 through 60 (of 1,079 total)