Question

SQL placed on a VM?

Administration Installation and Upgrades

Updated March 23, 2017

asked on March 23, 2017 • Show version history

Hello everyone,

On the Laserfiche website, in the solution exchange, it recommends that SQL is not installed on a Virtual Server. However, it does not state the reason for this.

Can someone explain why this is? I have a client that would like to know.

Thank you!

-Jon

0 0

Replies

replied on March 23, 2017

In many cases, the RDBMS is going to be the limiting factor of your solution's performance. The thinking is that it needs to get as much hardware resources as possible, and that you are better off giving it a dedicated physical machine rather than having it share resources with the host OS and any other virtual machines that are also on that host.

Like most recommendations, it's not a hard-and-fast rule and should be weighed against the benefits of virtualization. Further, it seems that virtualization technology is improving and there is less power "lost" to the host OS now than in the past.

Some related reading:

http://stackoverflow.com/questions/149318/virtualized-sql-server-why-not

http://support.cyriouswiki.com/Can+I+use+a+VM+(Virtual+Machine)+to+host+SQL+Server%3F

http://searchsqlserver.techtarget.com/essentialguide/Guide-to-SQL-Server-virtualization-best-practices

2 0

replied on March 23, 2017

From my understanding, for whatever reason, SQL performs better on a physical machine than it does on a virtual box.

1 0

replied on March 23, 2017

We use SQL in a virtualized environment in most of our deployments. It's simply a matter of following the virtualization platform's recommendations for database type loads in a VM.

1 0

replied on March 23, 2017

Thank you for the responses! I will pass this information along to the client asking as well as any other future replies!

0 0

You are not allowed to follow up in this post.

Question

Question

SQL placed on a VM?

Replies

Sign in to reply to this post.