Connecting to SQL server on a virtual machine is more computationally expensive than a dedicated SQL instance?

jamheadart

10/13/23, 4:14 PM

I have two options:

I can connect my web app to a SQL server hosted on a virtual machine, or I can connect it to a dedicated SQL server instance. All will be hosted in the same zones in Azure / AWS e.g.

Now I want to write to this SQL server ten million times in a row in a foreach loop.

Will the dedicated SQL server instance perform better than the virtual machine or will it not make a difference?

1 + 0

sql-server

azure

amazon-web-services

Score:0

Server

Tim

10/13/23, 6:31 PM

One great thing about cloud is you can try things out yourself. You haven't described your scenario particularly well - do you mean a database instance on the same virtual machine as the application server?

The answer is - it depends on many factors. Network latency, query complexity, etc.

+ 2

jamheadart

10/14/23, 7:09 AM

Before going to that effort I thought someone might already know. I thought a five minute question and answer might beat spending half a day setting up a VM, installing SQL server on the VM, setting up a SQL instance, setting up a web app, creating connections to both which is often more painful than it should be and then trial running everything. But no, the application would not be on the same instance as the VM.

Tim

10/14/23, 6:57 PM

I assumed you were asking about something you had already set up. It really will depend on many factors such as latency and query complexity.

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Connecting to SQL server on a virtual machine is more computationally expensive than a dedicated SQL instance?

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.