SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,058 questions
Thank You for assisting
SQL21/19 on VMWare
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Ismail Cassiem
226
Reputation points
DW Upgrade (VMWare with SSD or Physical box)?
Good day,
I am designing architecture for new DW that can handle paralism
3 tiers (Data storage, persentation, vizualizer)
External company has done an assessment on the environment, the feedback is that the 3 ties on VMWare would work
currently we only have 1 but i dont really like vm for dw as paralism and speed issues
I heard that sql19 fixes a lot of execution planning for indexing with columnar, please assist on how the VM configuration should be as best practise?
i wanted it on physical with ssd but with the data center migration in 3 years time buying physical hardware is maybe not a good idea
i thought of azure but its dependant on internet line/bandwidth but doing massive erp etracts will be mighty slow
my experience with current dw vm is that it sucks but i need to get performance badly as users will be connecting doing selfservice with 2 comapny bi instances on 1 dw vm
please help?
anyupdate perhaps on sql 21?
thank you
{count} votes
-
prmanhas-MSFT 17,901 Reputation points Microsoft Employee2021-02-12T10:14:56.72+00:00 @Ismail Cassiem Apologies for the delay in response and all the inconvenience caused because of the issue.
Can you please confirm if you are making use of vmware on azure or if there is some other requirement to your use case?
Thanks
-
Ismail Cassiem 226 Reputation points
2021-02-12T11:59:54.587+00:00 Hi,
No its its semi private, where the vm is based in an on-premesis data center
i have had bad experiece with vm but management wants to keep due to ease of migrations/managementwe have 3 hosts on sans, but i would like to add an ssd hardrive for the new dw 4th host only, any thoughts one infrastructure architecture/configurations for a sql19 vm for data strorgae/processing
any ideas when new sql21 might be available?
thank you
-
prmanhas-MSFT 17,901 Reputation points Microsoft Employee
2021-02-12T16:54:11.923+00:00 @Ismail Cassiem Thank you for the clarification!!!
The question you opened is with azure sql virtual machine tags and the mentioned issue is not related supported on this forum .
You can indeed try to post your query on forum below so you can get the required help:
https://communities.vmware.com/
Hope it helps :)
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,716 Reputation points2021-02-12T17:31:26.343+00:00 VMs in VMWare must be setup properly to support SQL Server. I suggest you ask your question on the VMWare site and also read this:
https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf
Sign in to comment