Skip to main content

Questions tagged [vmware]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
14 views

Is Cassandra certified on KVM?

I run Cassandra 4.1.3 inside OpenNMS Horizon 30.0.4; we run the solution on vms virtualized with VMware ESXi on Ubuntu 20.0.4 LTS; we were asked by the customer to migrate the solution from VMware to ...
Daniele's user avatar
  • 11
0 votes
1 answer
97 views

Where should SQL Server Binaries be installed on windows server

Is there a best practice on where to install SQL Server binaries for a new windows server deployment. I've seen some people suggest that it's best to seperate this from the OS drive and place it on it'...
John-Rock Bilodeau's user avatar
0 votes
0 answers
62 views

Why, MariaDB user allowed host IP address also allows a virtual machine on the host with NAT network adapter

The MariaDB user specifies an allowed IP address in the Host column of the mysql.user table. So, it only allows logging in from the host with the specified IP address. And MySQL has the same design. ...
James's user avatar
  • 149
0 votes
1 answer
540 views

I can't connect MySQL (on Ubuntu 22.04 Host) connect to remote server (Ubuntu 22.04 on VMWare Guest)

I want to create new MySQL connection to remote Django server that is inside virtual machine on VMWare (located at address 127.0.0.1 on port 33061). The problem is that MySQL shows the message "...
Abstract _42's user avatar
0 votes
1 answer
484 views

Local vs Shared Storage for MS SQL Server's Always On Availability Groups: What's Required?

Is it a requirement for MS SQL Server's Always On Availability Groups to always utilize shared Storage SAN or a virtual shared storage like Storage Spaces Direct? Can I set up Always On Availability ...
user avatar
0 votes
0 answers
447 views

SQL Server and drive formatting (block size)

We are having major performance and latency issues with SQL Server 2019. We are running on a "quiet" VMware instance connected to a vSAN. According to MSFT documentation, best performance is ...
Gary P.'s user avatar
0 votes
1 answer
713 views

sqlplus: command not found Using SSH on Windows to VMware linux

I have oracle Database 12c in a virtual machine with the database working normally in a linux environment (Centos). Through windows, using ssh I was able to connect to the linux virtual machine. But ...
Tomas A's user avatar
-2 votes
1 answer
662 views

NUMAnodes and SQL Server performance

Pretty sure I understand this, but wanted to be sure I do. We have a SQL Server 2016, that is running with 2 NumaNodes, each with 8 vCPUs. The Max Degrees of Parallelism (MAXDOP) is set to 8. This ...
Traderhut Games's user avatar
0 votes
1 answer
57 views

MySQL Circular Replication does not throw error, but is not syncing. Any ideas?

We are using MySQL Circular replication (2 servers in a master-slave setting with each other) for an implementation with both servers is different regions. Previously, we had the entire setup running ...
M. Faraz's user avatar
  • 101
1 vote
1 answer
1k views

SQL Server 2017 AlwaysOn Failover Cluster issue

I have 2 Windows 2012R2 VM's running on Vmware ESXi 7 with VMDK's as the SQL disks. I have a SQL 2017 AlwaysOn Cluster running on Server 2012R2. there is no any running backup (SNAPSHOT) PROD : 10....
Cell-o's user avatar
  • 1,088
0 votes
1 answer
1k views

Intermittently failover of my SQL Server resources on Windows Server 2016

I have 2 Windows 2016 VM's running on Vmware ESXi VMware ESXi, 6.7.0, 17700523 with VMDK's as the SQL disks. I have a SQL 2017 AlwaysOn Cluster running on Server 2016. Basically everything is pointing ...
Cell-o's user avatar
  • 1,088
0 votes
0 answers
36 views

Changing SQL Server2000 settings after converting to VM?

We have migrated a SQL 2000 server to VM and I am wondering what changes will need to be made on the VM? After the VM migration an SSIS package that transferred data from the 2000Server to a ...
mcv110's user avatar
  • 75
1 vote
2 answers
59 views

What steps we need to perform from DB end in case of storage migration?

What are the impacts / steps from DB2 DB side before VMware SvMotion Storage migration ?
Ishita's user avatar
  • 11
0 votes
1 answer
34 views

VM'd a SQL server, having trouble with external HDDs

First I am not a SQL DB. I inherited an old system and am trying to keep the wheels from falling off. We have an MS SQL 2000 server (running server Win Server 2000) that we performed a P2V migration ...
mcv110's user avatar
  • 75
-1 votes
1 answer
67 views

RAID 0 for development [closed]

in your experiences does of real world testing of RAID5 come "close" or "far" behind RAID0 in terms of performance as the underlying storage for a heavy write OLTP workload? Please ...
birchmeier's user avatar
0 votes
1 answer
590 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,180
0 votes
1 answer
68 views

Understanding the load running on my SQL server

We have a project this year to move lot of physical SQL Servers, starting with medium critical servers onto Virtual machines. Generally on physical boxes we have a large count of logical processors, ...
Newbie-DBA's user avatar
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
1 vote
1 answer
237 views

How can I provision more CPU from VMware when MAXDOP is set to 1?

We have a BizTalk Server group hosted over seven servers, all hosted in VMware. This group comprises four BizTalk application servers and three SQL Server instances. As per Microsoft's out of the box ...
Sir Crispalot's user avatar
-2 votes
0 answers
32 views

How to setup SQL Server on VMWare for best performance [duplicate]

We have Dell r940 server with 64 CPUs. Processor Type: Intel(R) Xeon(R) Platinum 8253 CPU @ 2.20GHz 4 Sockets + 16 Cores per Socket and 128 Logical processors Memory 767 GB We set the server up on a ...
paman's user avatar
  • 1
0 votes
0 answers
23 views

Import SQL between VM slow

We have database backups that we sometimes have to inject into the databases concerned. If we copy the backup to the VM hosting mysql, then we perform the import, it is very fast (3 minutes on average)...
DediHelpers's user avatar
2 votes
1 answer
254 views

Reason why SQL Max memory expansion seems slow when migrated to newer version of SQL server

We are trying to understand below behavior happening in SQL Server and need some guidance:- After migrating from older version SQL2012 (running on bare metal P Server) to newer SQL2017 running inside ...
Newbie-DBA's user avatar
0 votes
1 answer
141 views

Design Sql Server physical configuration from existing VM

We have 4 virtual machines that we used to test our BI platform (PoC), the final dimensions are: SSIS (16 vcpu), SSAS (8 vCPU), SSRS (4 VCPU) et Data Engine (24 vCPU) What are the recommendations ...
Benn's user avatar
  • 1
0 votes
1 answer
1k views

Unable to attach SQL Server database with shared folder in docker on Linux

The problem I'm having is that my SQL Server 2017 Linux container is not able to read my database files. I guess it has something to do with permissions and I'm sure I've overlooked something but I ...
SQLStad's user avatar
  • 366
4 votes
0 answers
89 views

SQL Server, what is the optimal Processor & Core configuration for VMs? [duplicate]

In my day job I deal with alot of SQL Servers...and lately I've had a rash of clients running 16 cores but configured as 1 core per processor and their SQL Standard edition runs like a dog, as ...
Jake Cohen's user avatar
6 votes
3 answers
17k views

Postgresql query is very slow for my big table

My database version is postgresql 9.5. create table if not exists request_log ( id bigserial not null constraint app_requests_pkey primary key, request_date timestamp not ...
barteloma's user avatar
  • 161
2 votes
2 answers
254 views

SQL Server on Windows Server (VMware) - online storage swap

I have a VM cluster designed to store multiple SQL Server instances. We use variety of storage providers (i.e. 3PAR, XIV) which have to be changed now (not relevant to what brand). On Oracle on Linux ...
Bartosz X's user avatar
  • 503
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,951
1 vote
0 answers
84 views

Query disk performance in VMware database

i need help to build a query to retrieve disks performance from VMware database. The query must bring the host LUN or the VM disk, and their respective IO and latency. I found the view ...
Caio Gabriel's user avatar
0 votes
1 answer
749 views

MongoDB - Does WiredTiger benefit from virtual cpus cores the same way it does with physical cores?

According to https://docs.mongodb.com/manual/administration/production-notes/#id5 The WiredTiger storage engine is multithreaded and can take advantage of additional CPU cores. We will be running ...
Dylan's user avatar
  • 103
0 votes
1 answer
466 views

Crash of VMWare Workstation when generating EER Diagram

I'm facing an issue when I'm generating an EER diagram with MySQL Workbench 8.0 I'm using MySQL Workbench on a local Windows 10 virtual machine. My VM is running with VMWare Workstation 12.5.0. I ...
Cid's user avatar
  • 101
1 vote
1 answer
1k views

Queue Depth and vSCSI controllers

We have a purestorage san, a couple of VMhosts each serving up several SQL Server VM's. Each VMhost is given a slice of the SAN and each SQL Server VM is presented a single data VMDK and a single log ...
Shawn's user avatar
  • 11
2 votes
1 answer
2k views

error connecting to master '[email protected]:3306' mac-ubuntu

Server info: Master server (Vmware): Ubuntu 18.04 IP: 192.168.57.10 Slave server1 (Vmware): Ubuntu 18.04 IP: 192.168.57.11 Slave server2 (mac): macOS High Sierra IP: 192.168.0.3 MySQL Server ...
vishnu's user avatar
  • 41
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
7 votes
4 answers
2k views

Single Core SQL Server on VM

Recently our school district has upgraded several servers from version 2005 to 2016 and from physical servers to VM servers. Our infrastructure team presented the VM servers for SQL Server ...
Deb's user avatar
  • 73
0 votes
1 answer
482 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
-1 votes
2 answers
289 views

All Queries are slow on Prod than Dev Server

All Queries are slow on Prod than Dev Server(SQL 2012). We have put the servers on the same host and changed the storage to the same SAN. All resources including core and memory are the same. All ...
user146892's user avatar
0 votes
1 answer
38 views

Always On reaction in specific scenario

I need to upgrade my Sharepoint2013 Farm, and the SQL2012 servers are in AlwaysOn mode. I was wondering if I could use Always On in the following catastrophic scenario: Take a VM snapshot of ...
Philippe's user avatar
  • 507
0 votes
1 answer
26 views

Can vmware (virtualisation) configuration impact the data integrity of the data file [closed]

I'm wondering how much can a VMWare configuration impacts the integrity of the data file. I mean, if the VMWare configuration is not optimal and the database writes a lot of complex operations (...
Ganbin's user avatar
  • 101
1 vote
3 answers
1k views

Migration of Always On Availability Group from old to new SAN within same data center

What are the steps required to move AAGs (version=SQL 2012 and OS=Windows 2012 R2 O) to new SAN within same data center? It is a virtualized environment. Instead of building new servers - can the ...
IMADBA's user avatar
  • 50
6 votes
1 answer
8k views

Connection Timeout Expired without apparent network issue

We have one particular SQL Server which is intermittently timing out when accepting connections. The issue is consistent throughout the day, but occurs at a very low incidence. How can I continue to ...
Mitch's user avatar
  • 2,638
12 votes
3 answers
6k views

Major performance problems on our production SQL Server, how would I troubleshoot this?

This question is basically the a follow up question to this question: Strange performance problem with SQL Server 2016 We now went productive with this system. Though another application database ...
Emptyslot's user avatar
  • 459
8 votes
1 answer
4k views

SQL Server detected 2 sockets with 4 cores per socket but only one NUMA node

We have a SQL Server 2012 SP 2 CU 8 instance in a VMWare host. The operating system is Windows Server 2012 R2. Windows Task Manager says that we have two sockets and 8 virtual cores. This number ...
Hans Vader's user avatar
15 votes
2 answers
8k views

Strange performance problem with SQL Server 2016

We have a single instance of SQL Server 2016 SP1 running in a VMware virtual machine. It contains 4 databases, each for a different application. Those applications are all on separate virtual servers. ...
Emptyslot's user avatar
  • 459
3 votes
4 answers
249 views

SQL Server on VMware why 3 vnics

We have VMWare ESXi hosts administered in VMware vSphere. I've sent my network admins this artice, http://www.sqlservercentral.com/articles/Virtualization/125226/ and asked what they think. ...
SurfRodeoDBA's user avatar
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
2 answers
2k views

SQL 2016 low TPM with HammerDB-Test

we have some trouble with a fresh installed MSSQL 2016 Server. The Server is a virtual VMware Machine using VMware's Best Practice. We have used the HammerDB-Tool to test TPM with TPC-C Standard. ...
PBS's user avatar
  • 31
1 vote
1 answer
2k views

Share the database between vmware guest and host

I wanna Access the MySQL Database founded in Windows 10 from VMware Workstation MAC OS X guest and give the guest ( MAC in VMware ) only permissions to just one database from the host (Windows 10), I ...
Ayman Ghandour's user avatar
2 votes
1 answer
1k views

Lock pages in memory and Virtual SQL Server

VmWare 2008R2 Enterprise SQL server with Lock Pages in Memory ENABLED.... I have read the Jonathan Kehayias blog post referenced from Brent Ozar's blog via sp_Blitz and still not sure if I should have ...
Greg's user avatar
  • 21
3 votes
1 answer
2k views

VMware Socket/Core allocation for SQL Server 2016

I am requesting a 16 vCPU 256GB RAM VM (Windows 2012|Host ESX 5.5) from our infrastructure team. However, my infrastructure team would like to know how the VM should be setup. What would be the ideal ...
Tho H. Le's user avatar