Questions tagged [virtualisation]
The virtualisation tag has no usage guidance.
12
questions with no upvoted or accepted answers
3
votes
0
answers
459
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
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 ...
- 137
2
votes
2
answers
225
views
Network connection from old application to SQL Server 2008 R2 lost once in a while
I have put this question on serverfault.com as well, but since the problem concerns connecting to SQL Server, I will also put it here.
We are trying to migrate an Axapta 2.5 database from SQL Server ...
- 111
1
vote
0
answers
104
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
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 ...
- 11
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 ...
1
vote
0
answers
545
views
Setting up multiple databases in Vagrant
Currently I am using Vagrant 1.4.3 in-conjunction with VirtualBox running Unix (Centos) for my development server (using MariaDB).
I didn't setup the box myself (so my knowledge of setting this up ...
- 111
0
votes
0
answers
40
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
1
answer
179
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?
- 150
0
votes
0
answers
61
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,
...
- 16.2k
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
-1
votes
1
answer
456
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