Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [virtualisation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
92 views

Performance degradation in SQL Server without increase of wait stats- what metric am I missing? [closed]

I had a strange issue which is kind of solved now, but I wasted a lot of time on this and I wonder what have I missed this time. I have SQL Server 2019 hosted on premise on VMware vSphere. On that ...
Radek Gąska's user avatar
0 votes
1 answer
141 views

What is the benefit of multiple subnet (FCI/AG) in a virtualized setup?

In a virtualized setup, for example on-prem VMware based virtualized setup or Azure based VMs, what exactly is the benefit of placing the SQL FCI or AG nodes in separate subnet?
variable's user avatar
  • 3,636
0 votes
2 answers
114 views

Where to store DB files for SQL Failover Cluster Instance on Hyper-V

I am upgrading old off-lease hardware to brand new / full warranty enterprise-class host servers and 10gb iSCSI SAN. In the old environment, it was made up of a bunch of old Dell servers with lots of ...
Lando_'s user avatar
  • 3
0 votes
0 answers
44 views

Azure Hybrid Benefit-Self-Installed SQL Server on Azure VM

The Microsoft documentation says if you self-install SQL Server on Azure VM, you need to manually register with the SQL IaaS Agent Extension and activate Azure Hybrid Benefit. https://learn.microsoft....
steve's user avatar
  • 47
0 votes
2 answers
66 views

SQL 2016 Server OS Memory - when the total physical memory is 1.5TB

We are looking into virtualizing a large SQL server. The virtualization would not support 1.5TB and the current server is well overspeced in relation to memory, so we are looking at reducing the ...
Mike Fleming's user avatar
0 votes
1 answer
45 views

Can I run a second server on a Virtual Machine on my original physical server, or do I need to run 2 Virtual Machines to have 2 servers?

The company I work for has a File Share server running on an server that is running Windows Server 2022. Its a simple setup that just uses Workgroups rather than a domain controller. They use a CAD ...
Austin Daniel's user avatar
1 vote
0 answers
105 views

Can DST transitions cause "random" query timeouts?

I have encountered a query timeout ("Execution Timeout Expired") on a sub-second query on a connection set to 30 seconds timeouts. Client side logging indicated that 4 days elapsed between ...
Jirka Hanika's user avatar
3 votes
3 answers
2k views

Can connect to virtual MySql instance using 127.0.0.1, but not localhost

Running MySql 5.7.33 on a local VirtualBox instance. I have forwarded port 3306 from the virtual server to be accessible locally. On my virtual host, I have this in my /etc/mysql/my.cnf file ... [...
Dave's user avatar
  • 703
-1 votes
1 answer
74 views

What are my limits and pre req's for my Sql Server 2014 VM?

I have the following Virtual SQL Server (running in Windows Server 2016 Hypver-V environment): The VM is on one specific host shared with other vm's and can be moved around on other hosts. SQL Version:...
Kahn Kah's user avatar
  • 115
1 vote
2 answers
1k views

Multiple disks vs single disk on virtualized environment

We're planning to install a SQL Server on this physical architecture: A hyper-v cluster based on windows server 2019 A cluster shared volume where all VMs live A full-flash SAN that contains the CSV ...
Mattia Nocerino's user avatar
0 votes
1 answer
573 views

High CPU for SQL server running on VmWare

I am trying to understand the below behavior for one of our SQL server running on VM. SQL Server version 2017 has 64vCores and Host has 96 cores with base speed 2.1 GHZ Based on the article from https:...
BeginnerDBA's user avatar
  • 2,170
3 votes
2 answers
3k views

SQL Server Socket/CPU Configuration [closed]

In your opinion what is the best configuration for optimal SQL Server performance in regards to virtual guest Socket/CPU configuration? I've read numerous articles stating wide socket configuration (1 ...
SQLDBAND's user avatar
  • 355
0 votes
2 answers
169 views

What situation RDBMS need to vm or docker virtualization?

Usually RDBMS just have only one primary server for writing, so what's the point of virtualization? It cannot make multi-DB, and one additional layer of encapsulation does not mean that the speed ...
kdm.J's user avatar
  • 41
0 votes
1 answer
182 views

Cloning a SQL Server Virtual Machine with TDE

When a virtual machine with a SQL Server database that uses TDE is copied or cloned, will the database be readable on the new instance?
cdonner's user avatar
  • 150
5 votes
2 answers
965 views

is there any point of moving tempdb files into different disk drive if all LUNs are from the same RAID pool?

According to best practices, it is recommended to move all tempdb (not just tempdb) files into different physical disk. I have a virtual server which had originally 4 LUNs from the same RAID 10 pool....
Rauf Asadov's user avatar
  • 1,273
-1 votes
1 answer
534 views

What value to set for MAX and MIN memory of SQL Server hosted on Bare Metal [duplicate]

Within AWS, Many of our Database servers are being migrated from EC2 Instance to Bare Metal. (Correct me, If I am wrong) In Bare metal, there are two memory limits available for the VM hosted on Bare ...
sachin-SQLServernewbiee's user avatar
1 vote
1 answer
149 views

Sql Server Backup - Log shipping vs VM snapshot

Setup I have Sql Server Standard running on an AWS VM For one of my DBs on this server, I perform:  1x daily backup And ship logs every 15mins to another DB Server VM, dedicated to log shipping ...
mel's user avatar
  • 11
-1 votes
1 answer
378 views

mysqldump very slow [closed]

We have an application running on mysql 5.1.73. We recently converted the server from physical to virtual and from that date the mysqldump is running for a very long time. We have a big database of ...
ajith's user avatar
  • 11
-1 votes
3 answers
392 views

How to maintain a query that runs forever?

I would like to run a query that finds prime numbers, and I would like to run it forever. @Solomon Rutzky on this page Prime numbers in a given range , give us a good example of the Sieve of ...
Francesco Mantovani's user avatar
3 votes
1 answer
82 views

Skipping VM backups for high workload SQL Server?

For those who have virtualized SQL Servers with very high volume transaction workload (very high rate of data change), I am curious how you handle VM backups, or if you even do them. Of course, I ...
sqlbattsman's user avatar
3 votes
2 answers
138 views

Is it normal to share CPUs on a VM of SQL Server?

Our IT set up a SQL Server as a VM on a big VMWare box that contains other VMs. The CPUs are setup as shared. As a result, any queries that might need multiple CPUs take 30x longer than if I limited ...
AngryHacker's user avatar
  • 1,931
6 votes
1 answer
909 views

pg_ctl hangs over ssh

I am designing a process to test my postgresql 10.8 backups by restoring them to a random point in time in a throwaway virtual machine. I have been unable to fully automate the process though. I am ...
Peter Vandivier's user avatar
17 votes
1 answer
25k views

best way to run sql server management studio on linux

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker. I want to use sql server management studio to manage the server. SO far now, I have a windows 7 enterprise with with ...
opensas's user avatar
  • 347
-1 votes
1 answer
457 views

Running Mariadb on LXD (using proxmox) vs baremetal

I have benchmarked lxd and the difference has not been more than 2-3% of the bare metal performance. I am using fusion sx300 1.6tb to store a 450gb database with 20b rows in a single table. We have ...
Vish's user avatar
  • 129
1 vote
0 answers
69 views

virtual MySql server with mounted RAID array

I have a Ubuntu 16.04 server with an 18TB RAID array. I am running virtual servers on the server using Wok/Kimchi and am wondering if it is reasonable to run a MySQL virtual server and set the data ...
cuxcrider's user avatar
0 votes
1 answer
425 views

what is a safe way to stop the logreader?

Applying cumulative updates and service packs on sql server 2016 - The server is involved in transactional replication, being a publisher, The server is also a virtual machine. I need to stop the ...
Marcello Miorelli's user avatar
6 votes
2 answers
6k views

when applying a sql server cumulative update or service pack on a virtual machine - what could be a safe way of stopping VMWaretools?

While applying cumulative updates to sql server 2016 SP1, there are a bunch of services and applications that need to be stopped for the update to go on. Among those is the very core of the virtual ...
Marcello Miorelli's user avatar
0 votes
0 answers
63 views

how to find out if it is safe to uninstall an application from a production sql server?

I noticed Microsoft Office components installed in a production SQL Server Box (which is part of an availability group - currently the principal) OS is microsoft windows server 2012 r2 datacentre, ...
Marcello Miorelli's user avatar
0 votes
0 answers
1k views

SQL Server MAXDOP and TempDB Recommendations for VMs

When configuring SQL Server on a VM does the recommendation around tempDb and MAXDOP still stand true? TempDB - As a general rule, if the number of logical processors is less than or equal to 8, use ...
Adrian S's user avatar
  • 326
0 votes
1 answer
479 views

Methods for right-sizing SQL Server virtualization?

I am starting to plan a migration of SQL Server 2008 R2 Enterprise Ed. to 2017 (edition TBD). One of the more important tasks assigned to me is to determine the specs for the new VMWare hardware my ...
SQL_Deadwood's user avatar
0 votes
1 answer
129 views

SQL Server Availability Groups between virtual server and a bare metal sql server

I currently have Mirroring set up between two production SQL Servers. One of these servers is a hardware SQL server (principal) and the mirror is a VM (on different server). I need to migrate these ...
Dina's user avatar
  • 1,497
1 vote
1 answer
278 views

Drive Configuration In Virtual Environment

My company is getting some new VM (VMWare) servers provisioned for purposes of installing SQL 2014 or 2016 (version to be determined) with AlwaysOn Availability Groups. The server and storage ...
KMT's user avatar
  • 31
0 votes
2 answers
323 views

NTFS Filesystem Fragmentation issue occur after migrating mysql 5.6 database to mariadb 10.2

I am currently experience a novel issue with a previously fine running database server. For a second time within 8 weeks, the current running MariaDB 10.2.7 has been corrupted due to Operating System ...
user_26092017's user avatar
3 votes
2 answers
1k views

Running MySQL in virtualbox with data dir on shared folder sometimes results in data corruption

I'm trying to move our development environment onto a vagrant box (virtual machine using Oracle virtualbox). Currently I'm stuck on one problem: The environment needs a MySQL server and some ...
Vilx-'s user avatar
  • 724
2 votes
1 answer
2k views

Processor affinity for SQL Server on vmware

A while ago a consultant said that I should set processor affinity when I'm running SQL Server on VMWare. The advice was to disable CPU0 so it was free for the OS. When I read the "Architecting ...
Frederik Vanderhaegen's user avatar
3 votes
0 answers
477 views

How do I change a processor count on a stopped SQL Server instance?

I have restored an image of a production SQL Server 2008 R2 to a Virtual Machine to test out some changes. When I try to start SQL Server to recreate tempdb (in partition that was not restored), it ...
Torsten S.'s user avatar
2 votes
1 answer
1k views

Protecting Virtualized SSIS and SSRS servers

I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them ...
buddinggeek's user avatar
1 vote
1 answer
603 views

HAProxy - Load-Balancing in 2 Node setup - Performance Gain possible?

I was speaking with my boss about Load-Balancing a 2 node Galera Cluster and we weren't sure if there was any reason. For writes, his argument was, even if we balance the writes, it has to write to ...
FreeSoftwareServers's user avatar
1 vote
0 answers
339 views

Setting drive Allocation unit size in virtual envionrment

Environment details: One physical host disk (RAID 10) Multiple virtual servers of varying types (app, web, SQL, file) all using same host disk using Hyper-V Questions: Is it still beneficial to ...
SQLcyclopedia's user avatar
1 vote
2 answers
1k views

SQL Server Virtualization best practices - NUMA, HT, Cores vs Speed

We run on Cisco UCS + VMware ESX + HP 3PAR. Host blade config : UCSB-B200-M4 , Xeon E5-2667 v3 3.1GHz , 2 sockets , 8 cores each, Hyper-Threading Active So total 16 physical cores, or 32 logical ...
d-_-b's user avatar
  • 1,154
12 votes
1 answer
3k views

Multiple PVSCSI with SQL Server

Regarding SQL Server virtualization, been trying to find info if there is a positive performance impact on separating Data devices from Log devices into different Paravirtual SCSI (PVSCSI) Adapters, ...
JoseTeixeira's user avatar
  • 1,123
0 votes
1 answer
122 views

Hardware Cluster to VMware, is vMotion an alternative for clustering?

We are migrating DB servers from "real" clusters to VMware. The question is with VMware how do you get similar functionality in VMware? Things like failover etc? Is vMotion the answer? I wonder what ...
krisj's user avatar
  • 79
2 votes
2 answers
4k views

Run multiple MySQL instances in Windows

Which is a better way to install multiple instances of MySQL / MariaDB / etc on a single Windows box? Manually setting different ports? Docker? Virtual Box? Something else? (Sandbox, mysql_multi, ...
Rick James's user avatar
  • 78.4k
6 votes
1 answer
4k views

SQL Server on SAN, same LUN: one logical drive vs multiple

First, let me start by saying that I did notice there are multiple similar questions to this, but neither of them is exactly what I want to ask, and not one of them has a definite answer. Second, let ...
mrQQ's user avatar
  • 81
2 votes
0 answers
103 views

Why does my differencing virtual disk grow so much after restoring a differential SQL Server backup?

Inspired by RedGate's upcoming SQL Instant Clone, I'm using virtual disks to store my test database and gain fast clones via differencing disks. I created a 30 GB VHD and restored a 18 GB database ...
Bruno Martinez's user avatar
5 votes
1 answer
635 views

What is Data Virtualization?

I've just been asked whether our company should consider Data Virtualization for our test environments. The benefits are given as: Screening of sensitive data Fast data refreshes in our test ...
JohnLBevan's user avatar
0 votes
2 answers
2k views

unable to connect to oracle in linux terminal in oracle VM ,TNS listner not connected

i installed oracle VM , new to oracle vm. Can some help me in connecting to oracle in Linux termial and TNS listner is not responding with IO failure on sql developer when pressing test button ....
arya's user avatar
  • 109
8 votes
3 answers
1k views

Dedicated Resources on VMs hosting SQL Server

My understanding is that one of the big benefits of using a VM is that you can share resources between the virtual machines on a host. So you can have a host with 120 CPUs and put 5 VMs on it with 32 ...
Kenneth Fisher's user avatar
2 votes
2 answers
1k views

MariaDB server with 80K-100K DataBases

BACKGROUND : We have an environment where there is a new DB created almost every minute and it will be Dropped after few days or weeks (maximum 1 month) such that the space used is about 300GB~400GB ...
Prem's user avatar
  • 133
1 vote
1 answer
46 views

Move database from windows server 2003 to windows 7/8?

I am working with this company currently running their SQL Express database in a virtualized Windows Server 2003. What would you experts say about replacing that for a virtualized slimmed-down ...
MadOp's user avatar
  • 15