Viewing 15 posts - 2,101 through 2,115 (of 9,244 total)
feersum_endjinn (5/19/2015)
But now I understand that this is supported and it's in fact desirable to have anyway.
Ideally, no it's not. You don't want shared replicated storage. It's expensive, requires maintenance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2015 at 10:56 am
feersum_endjinn (5/19/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2015 at 10:55 am
Martin Stephenson (3/14/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2015 at 9:54 am
feersum_endjinn (5/19/2015)
In my current setup – FCI instance 1 (let’s called SQL-CL-01)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2015 at 8:30 am
and you're using sql server 2014?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2015 at 8:25 am
feersum_endjinn (5/19/2015)
We have an existing SQL Server 2012 Enterprise cluster with 2 nodes (active-active) and uses Windows 2008 R2 OS. We are looking for a way to increase HA as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2015 at 7:51 am
so u have 2 different availability groups between the core and noncore instances, but they both use the same standalone instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2015 at 7:41 am
Perry Whittle (5/18/2015)
audiocool (5/17/2015)
Details Specification:------------------------
OS: Windows Server 2012
RAM: 32GB
Processor: 4 core with 2.0Ghz
SQL Server 2012
-------------------
Minimum Memory: 4GB
Maximum Memory: 24GB
I'm assuming that's the spec for the SQL VM, what are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2015 at 4:50 am
initiating an OS shutdown will still stop the sql instance cleanly. I've seen cases in the past where someone is rebooting a sql server and it takes its time to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2015 at 4:33 am
so from what I can understand you have 2 FCIs and both wont come online on the same node, correct?
Are you using any startup parameters for the instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2015 at 4:29 am
stuartw.evansuk (5/14/2015)
file g:\database\testfile.dat with 4 threads (0-3) using mask 0x0 (0)
Also, if G:\data is actually a VMware virtual disk then I\O could well be a bottleneck anyway especially for random...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 11:51 am
David Webb-CDS (5/18/2015)
exec xp_fixeddrives
Bear in mind this wont help if you use mounted volumes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 11:45 am
ramyours2003 (5/18/2015)
what are the dmv's which we used while trouble shooting mirroring in sql 2008 ?
Take a look at this link specific to monitoring database mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 11:11 am
audiocool (5/17/2015)
What I did is restart SQL Server Service. Then it solve for temporary.
That's to be expected. You've killed all the connections and cleared the buffer pool 😉
audiocool (5/17/2015)
------------------------
OS:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 10:12 am
briancampbellmcad (5/15/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 10:04 am
Viewing 15 posts - 2,101 through 2,115 (of 9,244 total)