Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [virtualisation]

76 questions
20
votes
2 answers

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 ssms 17.9.1 and it works ok It's really annoying…
opensas
  • 387
  • 1
  • 3
  • 10
12
votes
1 answer

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, similar to what is done here. There has been a…
JoseTeixeira
  • 1,113
  • 1
  • 8
  • 18
11
votes
1 answer

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/volume, and we've had great success (~8 years) using…
Steve R.
  • 111
  • 1
  • 4
8
votes
3 answers

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 CPUs each. The extra CPUs are "shared" between…
Kenneth Fisher
  • 24,307
  • 13
  • 63
  • 116
7
votes
5 answers

Improving SQL Server performance on VMware under Linux

I have a Linux server in a small company (3 users) acting as a domain server and running two VMs under VMware: one has SQL Server 2000 on it and one has SQL Server 2005, in each case running on Win2k. Each of the SQL Servers has a couple of…
Brad Richards
6
votes
1 answer

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 blocked at step 8 (section 25.3.4) of the official…
Peter Vandivier
  • 5,485
  • 1
  • 25
  • 49
6
votes
2 answers

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 machine, the VMware Tools core service. Is it safe…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
6
votes
1 answer

SQL Server 2005 Express in VMware causing very high CPU load

I'm having the problems described in KB937745 - very high CPU usage and the Application Log is reporting something like this: The client was unable to reuse a session with SPID SPID, which had been reset for connection pooling. I've downloaded…
ahill
  • 161
  • 4
6
votes
1 answer

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 me confirm that I do understand, that it's…
mrQQ
  • 81
  • 1
  • 4
5
votes
3 answers

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 drives for SQL Server's Database files (.mdf ,…
M.Ali
  • 1,970
  • 10
  • 27
  • 38
5
votes
4 answers

Is database partitioning for performance reasons meaningful in a virtualized environment?

When running SQL server on physical hardware, placing database data and log files on separate disks or RAID arrays can benefit performance, resilience, and maintenance. Partitioning the database over separate physical disks and RAID arrays is also…
Joe Schmoe
  • 401
  • 5
  • 13
5
votes
1 answer

Slow SQL Server query using a DB2 linked server in virtual environment

I have a problem with a slow query which uses a linked server. Let me list out my environment first and I'll get to the issue: Virtual Windows 2003 R2 server (fresh deployments on XenServer 6.1 & ESXi 5) SQL Server 2005 SP3 Linked Server created…
stanleykylee
  • 474
  • 1
  • 6
  • 21
5
votes
2 answers

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. By the help of volume manager, I converted those…
Rauf Asadov
  • 1,313
  • 14
  • 36
5
votes
2 answers

Pros and Cons of virtualisation technology for database-server and datastorage

Yesterday we had a chat about performance and restorability and I realized how many good things a virtualisation environment can bring to me - but as I'm a little sceptic concerning performance I'm asking here. It could be a little GIS specific, but…
Martin
  • 235
  • 2
  • 7
5
votes
1 answer

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 environments Potential benefits for DR and BI…
JohnLBevan
  • 459
  • 1
  • 4
  • 15
1
2 3 4 5 6