Viewing 15 posts - 2,101 through 2,115 (of 9,253 total)
I was hoping to see a discussion on the impact to the host server of adding too many vNICs, vDisks and virtual disk controllers to VMs. Is this something you...
May 20, 2015 at 11:30 am
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...
May 20, 2015 at 10:56 am
feersum_endjinn (5/19/2015)
May 20, 2015 at 10:55 am
Martin Stephenson (3/14/2011)
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)...
May 19, 2015 at 8:30 am
and you're using sql server 2014?
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...
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?
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...
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...
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?
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...
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
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
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:...
May 18, 2015 at 10:12 am
Viewing 15 posts - 2,101 through 2,115 (of 9,253 total)