Help choosing replacement Hyper-V host machines and connected storage
-
@JohnFromSTL said:
@scottalanmiller said:
@JohnFromSTL said:
@scottalanmiller said:
@dafyre said:
I currently have a Dell R720xd running Hyper-V 2012R2. It works really really well. Not sure on the price tag, but that is a nicely built system. Raid controller can do RAID 10, and RAID 6 in addition to the others... Add ram to meet your needs.
We have a monster R720xd with 128GB too. Sweet machine. R730xd has even bigger CPU options.
@scottalanmiller, @dafyre Which CPU and how much RAM is installed in your R720xd server?
Not sure on the CPU in ours. I know it is 128GB of RAM.
Does yours have the 2.5" or 3.5" drive option?
3.5". The 12 LFF plus 2 SFF option is really nice.
-
@scottalanmiller said:
@JohnFromSTL said:
@scottalanmiller said:
@JohnFromSTL said:
@scottalanmiller said:
@dafyre said:
I currently have a Dell R720xd running Hyper-V 2012R2. It works really really well. Not sure on the price tag, but that is a nicely built system. Raid controller can do RAID 10, and RAID 6 in addition to the others... Add ram to meet your needs.
We have a monster R720xd with 128GB too. Sweet machine. R730xd has even bigger CPU options.
@scottalanmiller, @dafyre Which CPU and how much RAM is installed in your R720xd server?
Not sure on the CPU in ours. I know it is 128GB of RAM.
Does yours have the 2.5" or 3.5" drive option?
3.5". The 12 LFF plus 2 SFF option is really nice.
The Dell Outlet has several nicely equipped machines for under $5,000, but I'm not sure about using nearline SAS.
Processor: Intel Xeon E5-2620 Processor (2.00GHz, 15M Cache, 7.2GT/s QPI, Turbo, 6C, 95W, Max Mem 1333MHz,OEM,XL)
Processor: Intel Xeon E5-2620 Processor (2.00GHz, 15M Cache, 7.2GT/s QPI, Turbo, 6C, 95W, Max Mem 1333MHz,OEM,XL)
2 TB 7.2K RPM Near-Line SAS 6Gbps 3.5in Hotplug Hard Drive [QTY : 12]
300GB 10K RPM SAS 6Gbps 2.5in Hot-plug Hard Drive [QTY : 2]
8GB RDIMM, 1600MT/s, Low Volt, Dual Rank, x8 Data Width [QTY : 4]
Intel Ethernet I350 QP 1Gb Network Daughter Card -
@JohnFromSTL said:
The Dell Outlet has several nicely equipped machines for under $5,000, but I'm not sure about using nearline SAS.
What is your concern with NL-SAS?
-
@scottalanmiller said:
@JohnFromSTL said:
The Dell Outlet has several nicely equipped machines for under $5,000, but I'm not sure about using nearline SAS.
What is your concern with NL-SAS?
Are they fast enough?
-
-
@JohnFromSTL said:
@scottalanmiller said:
@JohnFromSTL said:
The Dell Outlet has several nicely equipped machines for under $5,000, but I'm not sure about using nearline SAS.
What is your concern with NL-SAS?
Are they fast enough?
Do you know the IOPs load you need to support?
-
Figuring out the IOPS needs is key. Without that we are guessing quite a bit.
-
@Dashrender said:
@JohnFromSTL said:
@scottalanmiller said:
@JohnFromSTL said:
The Dell Outlet has several nicely equipped machines for under $5,000, but I'm not sure about using nearline SAS.
What is your concern with NL-SAS?
Are they fast enough?
Do you know the IOPs load you need to support?
I'll have to gather and calculate the info from our 3 SQL machines.
Does this page show the best way to determine current IO details?
http://www.sqltuners.net/blog/13-05-16/Measuring_Disk_IO_performance_for_SQL_Servers.aspxThe page suggested using the following select statement to obtain the required information.
SELECT
*
,wait_time_ms/waiting_tasks_count AS 'Avg Wait in ms'
FROM
sys.dm_os_wait_stats
WHERE
waiting_tasks_count > 0
ORDER BY
wait_time_ms DESC -
Thanks everyone!! I've got to leave for the day, I'll try and connect back to work later tonight.
-
@JohnFromSTL said:
Thanks everyone!! I've got to leave for the day, I'll try and connect back to work later tonight.
Have a good evening, "see" you later.
-
Hello John,
In you case i think StarWind Virtual SAN will fit perfectly. Thus we are glad to offer you our NFR license. You can get it by filling in this form and providing a link to this forum thread in it.
https://www.starwindsoftware.com/starwind-virtual-san-for-mvp-mctUnfortunately NFR license will be provided to OP only (at least for now).
-
@scottalanmiller said:
Figuring out the IOPS needs is key. Without that we are guessing quite a bit.
To be completely honest with all of you, we have not calculated the IOPS on our SQL machines.
This page has some tips (http://www.sqltuners.net/blog/13-05-16/Measuring_Disk_IO_performance_for_SQL_Servers.aspx) but is there a tool or PowerShell command which people normally use to collect the data?
-
If you're looking to buy Dell Equipment (even if you aren't) you can open the process with Dell, get their DPack and that will tell you your current usage.
-
@Dashrender said:
If you're looking to buy Dell Equipment (even if you aren't) you can open the process with Dell, get their DPack and that will tell you your current usage.
Sweet, I'm looking into that right now. BTW, I really do appreciate how helpful all of you have been.
-
@JohnFromSTL said:
Sweet, I'm looking into that right now. BTW, I really do appreciate how helpful all of you have been.
This is what most of us want from this community.
-
@JohnFromSTL said:
@scottalanmiller said:
Figuring out the IOPS needs is key. Without that we are guessing quite a bit.
To be completely honest with all of you, we have not calculated the IOPS on our SQL machines.
This page has some tips (http://www.sqltuners.net/blog/13-05-16/Measuring_Disk_IO_performance_for_SQL_Servers.aspx) but is there a tool or PowerShell command which people normally use to collect the data?
I think the majority of us use the Dell DPACK. If you want a DPACK read without needing to have Dell salespeople push you to install an Inverted Pyramid of Doom (which is what they do, every time, no exceptions) you can do this through NTG who are authorized to read DPACKs and have Dell's assurance that there is no sales push involved as NTG is allowed to block our customers from Dell's sales channel.
-
@scottalanmiller said:
@JohnFromSTL said:
@scottalanmiller said:
Figuring out the IOPS needs is key. Without that we are guessing quite a bit.
To be completely honest with all of you, we have not calculated the IOPS on our SQL machines.
This page has some tips (http://www.sqltuners.net/blog/13-05-16/Measuring_Disk_IO_performance_for_SQL_Servers.aspx) but is there a tool or PowerShell command which people normally use to collect the data?
I think the majority of us use the Dell DPACK. If you want a DPACK read without needing to have Dell salespeople push you to install an Inverted Pyramid of Doom (which is what they do, every time, no exceptions) you can do this through NTG who are authorized to read DPACKs and have Dell's assurance that there is no sales push involved as NTG is allowed to block our customers from Dell's sales channel.
Is DPACK the best tool to use? And would you happen to have a contact name for someone at NTG? I've spoken with someone from Dell but their lousy tool keeps dropping connections to the DPACK Web Service and this gentleman isn't very responsive at all.
-
@JohnFromSTL said:
Is DPACK the best tool to use? And would you happen to have a contact name for someone at NTG? I've spoken with someone from Dell but their lousy tool keeps dropping connections to the DPACK Web Service and this gentleman isn't very responsive at all.
Reach out to either @Minion-Queen or the new client liaison @art_of_shred
-
@Jhon.Smith said:
Hello John,
In you case i think StarWind Virtual SAN will fit perfectly. Thus we are glad to offer you our NFR license. You can get it by filling in this form and providing a link to this forum thread in it.
https://www.starwindsoftware.com/starwind-virtual-san-for-mvp-mctUnfortunately NFR license will be provided to OP only (at least for now).
Thank you very much. I've just completed the online form.
-
@Dashrender said:
@JohnFromSTL said:
Is DPACK the best tool to use? And would you happen to have a contact name for someone at NTG? I've spoken with someone from Dell but their lousy tool keeps dropping connections to the DPACK Web Service and this gentleman isn't very responsive at all.
Reach out to either @Minion-Queen or the new client liaison @art_of_shred
I'll do that. Should I contact @Minion-Queen and @art_of_shred via chat or is there another preferred method? Thank you very much.
