Questions tagged [virtualisation]
The virtualisation tag has no usage guidance.
76
questions
0
votes
1
answer
32
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?
- 3,430
0
votes
2
answers
52
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 ...
- 3
0
votes
0
answers
28
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....
- 47
0
votes
2
answers
56
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 ...
- 11
0
votes
1
answer
38
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 ...
1
vote
0
answers
97
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 ...
- 182
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 ...
[...
- 643
-1
votes
1
answer
72
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:...
- 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
...
- 602
0
votes
1
answer
498
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:...
- 2,169
3
votes
2
answers
2k
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 ...
- 345
0
votes
2
answers
157
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 ...
- 41
0
votes
1
answer
165
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?
- 151
5
votes
2
answers
821
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....
- 1,253
-1
votes
1
answer
483
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 ...
1
vote
1
answer
122
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 ...
- 11
-1
votes
1
answer
330
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 ...
- 11
-1
votes
3
answers
374
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 ...
- 1,504
3
votes
1
answer
81
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 ...
- 545
3
votes
2
answers
136
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 ...
- 1,921
6
votes
1
answer
840
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 ...
- 4,586
15
votes
1
answer
22k
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 ...
- 327
-1
votes
1
answer
449
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 ...
- 129
1
vote
0
answers
67
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 ...
- 11
0
votes
1
answer
397
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 ...
- 15.8k
5
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 ...
- 15.8k
0
votes
0
answers
60
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,
...
- 15.8k
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 ...
- 326
0
votes
1
answer
463
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 ...
- 821
0
votes
1
answer
126
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 ...
- 1,477
1
vote
1
answer
274
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 ...
- 31
0
votes
2
answers
315
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 ...
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 ...
- 714
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 ...
- 1,994
3
votes
0
answers
408
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 ...
- 31
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 ...
- 625
1
vote
1
answer
588
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 ...
1
vote
0
answers
336
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 ...
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 ...
- 1,144
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, ...
- 1,123
0
votes
1
answer
119
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 ...
- 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, ...
- 76.9k
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 ...
- 81
2
votes
0
answers
101
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 ...
- 137
5
votes
1
answer
617
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 ...
- 449
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 ....
- 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 ...
- 24.1k
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 ...
- 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 ...
- 15
3
votes
1
answer
1k
views
PostgreSQL vagrant VM cannot create extension
I had some problems during installation of PostgreSQL and I eventually decided to go for a VM solution managed with vagrant, as explained in postgresql wiki.
(At the beginning my motivation was just ...
- 133