@scottalanmiller said:
Complexity. That only works for certain database styles.
Are you able to isolate what patterns in complexity prevent this type of transition? I've used MySQL dumps to migrate what I'd call extremely complex databases with hundreds of tables that if modeled in some kind of large-scale diagram might well resemble a spider web. Interested to know what patterns preclude the successful use of a dump and import.
@Nic said:
@creayt said:
@Nic I was kidding, read it again. P.S. help w/ what?
Oh, I thought you were asking for feedback on whether the deal was good or not, my bad. Don't mind me, I'm just cranky today
NP, sorry I temporarily offended you 
@scottalanmiller said:
It's not a service at all, its a hypervisor. How could it be a service?
I can confirm, was able to shut down the service and the VM stayed up, and the GUI puttered out w/ a message that the service was offline.
@MattSpeller said:
\o/
Civility on the internet!?!?! Why I never....
I'm one of the culprits and I'm upset by it myself.
@scottalanmiller said:
So you are saying that it is HyperV that you using? I'm unclear here.
HyperV is a type 1 hypervisor, it is all on or all off. There is no "virtual" and "non-virtual" concept. Only one thing can run on Intel or AMD bare metal. So if you disable HyperV, it's gone and you are 100% bare metal for the OS.
No, sorry, I'm saying I'm starting over from scratch and going to do a fresh install of 2012 R2 on an R620, and I'm just scanning the bios, in the processor settings specifically where you can toggle things enabled or disabled ( like "virtualization technology", "hardware prefetcher", "DCU IP prefetcher", etc. ) and wondering whether ticking virtualization technology ( support ) to disabled will somehow free up the processor to go at full throttle or offer any other advantages.
Thanks guys.
@MattSpeller said:
In all honesty I think you'll get more performance gains by tweaking the OS than you will in the BIOS of a server.
Totally agree. Don't worry, I'm going to tweak EVERRYYYYYTHINNNNNGGGGG.
Next big decision is whether to use the hardware raid controller or some sexy Storage Spaces strategy. Stay tuned for a separate thread.
@MattSpeller said:
Did you get the SSD RAID allocation stuff sorted? I think I missed the outcome of that thread
It turns out the datacenter configuring the original 6 SSDs into a Raid 10 demolished the over-provisioning ( you have to manually set the RAID to use less than the full capacity, neither they nor I knew that ) and so I'm at a point where I'm starting over w/ it. I now have to weigh
w/
Still in the research phase at this point, but yeah, the original strategy fell apart because overprovisioning works implicitly and the RAID controller destroys it, in other words when you configure the provisioning you do so by creating your main partition, and then leaving the rest unallocated, and the Samsung 840/850s just know to use any unallocated space for speed and durability.
@MattSpeller said:
That sounds terrible man. You should send it to me and get yourself something higher end. I can't believe you use that! I'll happily pay for postage, as a friend, so you don't have to pay to recycle it.
God you're right, it's in the mail.
Don't get too jealous, the procs are
http://ark.intel.com/products/64583/Intel-Xeon-Processor-E5-2680-20M-Cache-2_70-GHz-8_00-GTs-Intel-QPI
and max out at 3.5 Ghz( albeit w/ a 20 MB cache ).
The only thing I even play is Dota, but I 
it.
Does anyone use Spaces in production? I'm getting semi-close read speeds in a 4x 850 Pro SSD Raid 0 using Storage Spaces and far superior write speeds ( expected ) when compared to a 6x identical-drive Raid 10 using the Perc H710P ( 1GB cache ) on my recently deployed server, and trying to decide whether to do a big Raid 10 of all 10 SSDs or to do a 2-drive Raid 1 and an 8 drive Raid 10 using Storage Spaces after getting some disappointing performance w/ the current Raid 10 setup on it.
@scottalanmiller Hahahah, I don't even know. I can't remember when I stopped logging in. Just workin and stuff I suppose.
Was actually researching some server RAID stuff today which randomly re-led me to a post on Mango.
@scottalanmiller said:
Now if the only goal is speed, your priorities change. So if you really just care about how fast it can go, you look at things differently.
I see. I guess it makes sense at least w/ my limited knowledge of how it all works. If a single 850 Pro using system RAM as the write cache can pull off the numbers below on my home-made $1000 workstation ( over 4 GB/s read and write ), and my server has 256GB RAM for Storage Spaces to use, I imagine the hardware RAID wouldn't stand a chance. The risk of data loss is very scary though, and may end up being the deciding factor. Out of curiosity, were the data loss issues you saw pre Server 2012 era or post?
PXE-E05: The LAN adapter's NVM configuration is corrupted or has not been initialized.
Is this normal? It seems to boot fine, but booting takes a hot minute so I wonder if it's holding it up. I disabled the 4 network slots from the boot sequence hoping it'd bypass any kind of PXE check, but didn't help.
![2015-07-09_1656[1].png](https://i.imgur.com/OmNjaXr.png)
@MattSpeller said:
@creayt said:
What RAID level is giving you those numbers?
The 1:10 Sequential ratio seems really wrong.
That's literally a SINGLE 850 Pro 256 GB using the box's RAM as a write back cache ( Samsung's "rapid mode" ).
@MattSpeller said:
@creayt ohhhhhhhhhhhhh ok - that was messing with my brain. thank you for clarification.
NP.
I should note in case it matters that it's a quad 3.8 Ghz Xeon w/ HT and 32 GB DDR3 1600.
My dual-core i7-5500U w/ 8GB of RAM puts these up w/ a single 840 Evo though, notice the awkwardly spectacular 6GB write.
@MattSpeller said:
@creayt I'm going home to benchmark my (comparitively) budget build 8320 / 840pro
I don't think I have the software installed for the RAM drive boost thingy whatever - I should investigate that.
What you want is Samsung Magician:
http://www.samsung.com/global/business/semiconductor/minisite/SSD/global/html/support/downloads.html
It also lets you overprovision the drive while booted into Windows in a few clicks.
To get these ridic numbers I overprovision really hard, above 25%, FYI. Because it uses the system RAM as the cache ( I think you need at least 8 to even enable "rapid mode", but the more you have the better ).
The IOs/sec seems terrible with both options, I think these drives are supposed to do 100,000 EACH and both benchmarks pull less than 50,000. That said, I don't fully grasp IOPS yet or how to correctly test it so this may just be my being ignorant at the moment.
