Questions tagged [virtualisation]

The tag has no usage guidance.

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

Will VPS servers work 24/7? What will happen if they crash?

I like to know if I buy a VPS service and install my MongoDB server/database on it, what will happen if this server crashes? I also like to know the answer about the dedicated servers. It's hard for ...
0
votes
0answers
53 views

SQL Server on Virtual Machine or not? [closed]

According to sqlserver new upgrades do you know any useful information about compatibility of sqlserver with virtual machines? I want deploy sqlserver instance for a large system (about 15 terabyte ...
-2
votes
1answer
22 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 ...
-2
votes
3answers
180 views

How to maintain a Database with stored procedure that runs forever?

I have an interesting question and I cannot find a reply. I would like to create a database of prime numbers. On this page Prime numbers in a given range , I can find various examples of SQL code ...
3
votes
1answer
64 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 ...
3
votes
2answers
106 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 ...
5
votes
1answer
225 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
votes
1answer
2k 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 ...
-1
votes
1answer
171 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 ...
1
vote
0answers
22 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 ...
0
votes
1answer
68 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 ...
4
votes
2answers
2k 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 ...
0
votes
0answers
38 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, ...
0
votes
0answers
573 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 ...
0
votes
1answer
228 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 ...
0
votes
1answer
91 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
vote
1answer
193 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 ...
0
votes
2answers
160 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 ...
1
vote
2answers
856 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 ...
2
votes
1answer
1k 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 ...
3
votes
0answers
158 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 ...
1
vote
1answer
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 ...
1
vote
1answer
521 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
0answers
303 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
2answers
805 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 ...
0
votes
0answers
268 views

How do you import an exported dump file into a pre-built oracle 11g virtual machine?

I have successfully downloaded and installed this pre-built virtual machine with Oracle 11g. I am able to access the scott/tiger database and view table contents successfully. I am currently trying ...
12
votes
1answer
1k 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, ...
0
votes
1answer
113 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 ...
2
votes
2answers
2k 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, ...
5
votes
1answer
2k 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 ...
2
votes
0answers
88 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 ...
4
votes
1answer
159 views

What is Data Virtualisation?

I've just been asked whether our company should consider Data Virtualisation for our test environments. The benefits are given as: Screening of sensitive data Fast data refreshes in our test ...
0
votes
2answers
1k 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 ....
8
votes
3answers
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 ...
2
votes
2answers
209 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 ...
1
vote
1answer
36 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 ...
3
votes
1answer
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 ...
3
votes
3answers
21k views

SSIS package hits “login failed for user” when simultaneous operations occur against the same target database

Quick summary We have been working on migrating our library of SSIS packages from SQL Server 2008 hosted on physical Windows Server 2003 to SQL Server 2012 hosted on virtual Windows Server 2012. The ...
0
votes
1answer
521 views

LDF files vs. TRN files vs. Tempdb.MDF+LDF files.:

We have a dilemma… We have all of our MDF and LDF files in the same…\192.168.6.22\d$\Program Files\Microsoft SQL Server\DATA\Production...folder. We have all of our TRN and BAK files on the…\192.168.6....
1
vote
1answer
276 views

Install Developer Edition ASE in Vagrant/Virtual Box

It is possible to deploy a development version of Sybase in a Vagrant/Virtualbox instance? I was planning on using a CentOS vagrant box to create a development environment but am not sure if it's ...
1
vote
0answers
380 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 ...
3
votes
2answers
2k views

Hyper-V Dynamic Memory and SQL Server

I will probably get voted down for this, but does anyone have a good place to start other than the Best Practices Documentation for using Dynamic memory with SQL server. We are experiencing issues ...
11
votes
1answer
2k views

Storage snapshots for consistent backup of postgresql - different data and log volumes

We are running many Linux VM's in a vmware/shared storage environment, each running its own instance of postgreSQL (a mix of 9.0 and 9.3). Currently, the entire VM sits on a single root partition/...
1
vote
1answer
863 views

MongoDB fails with SymInitialize error unless there is a very large Page File in Windows

I'm wondering if someone can help with a MongoDB/page-file issue we seem to experience as our database increases in size over time. Every now and then MongoDB will crash on a particular node in our ...
1
vote
2answers
175 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 ...
6
votes
3answers
9k views

Physical Server or a Virtual Machine SQL Server?

Is there a anyway to figure out via a SQL Script to know whether SQL Server is running on a Physical Server or Virtual Server ?
4
votes
3answers
2k views

Single Virtual Drive Vs Multiple Virtual Drives for SQL Server files

Hi guys I have question about how two different Hard disk setups can possibly affect performance of my database. I have two Options. Option 1: One Physical Harddisk and then Multiple Virtual hard ...
1
vote
1answer
184 views

Cluster Size Configurations for SQL Server at RAID Level

I was reading the below two articles (one of which I posted) and one recommends to use a RAID cluster stripe size of 256k while the other recommends to use 64k. There is a big difference between the ...
1
vote
1answer
346 views

Is this a good case for multiple SQL Server instances on a VM?

We have a suite of applications utilizing SQL Server have the following characteristics: Users create/destroy DBs via a UI, so DBs appear/disappear without DBA assistance. DBs of the same name can be ...
4
votes
1answer
403 views

Storing Tlogs and data files on the same drive

I'm looking for some clarification of various things I've read. I understand it to be best practice to store your transaction logs on a separate drive (spindle) than where you MDFs and NDFs are ...