Help choosing replacement Hyper-V host machines and connected storage
-
@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.
-
@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.
Several @ntg people right here in the thread
-
@ryan-from-xbyte said:
It's good to see this thread with more legs over here on Mango than on SW.
Here is the interesting thing going on with the Dell generations now. We see the 11th gen still popular (R510s and R710s) if you only need 6-core CPUs. If you need 8-cores, then we see people skipping the 12th generation and going on to the 13th generation servers like the R730xd. The newer CPUs are so powerful at the low end and therefore so inexpensive, it is hard to justify other the 12th generation. There are some exceptions if you are okay with E5-2600 version 1 CPUs. That market is crashing and you can find some deals.
This is why we encourage people to call us so we can walk through the options in the secondary market. It is very different than buying directly through Dell.
Thank you @ryan-from-xbyte, can you send me your email so I can get in touch with you?
-
Paging @xByteSean and @BradfromxByte too.
-
@scottalanmiller 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.
Several @ntg people right here in the thread
I have several DPACK results uploaded, should I just post them here?
-
Sure
-
-
I suppose, this one time, we can accept that excuse. But only with a doctor's note.
