Questions tagged [vmware]
The vmware tag has no usage guidance.
97
questions
0
votes
1
answer
80
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'...
0
votes
0
answers
46
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.
...
- 149
0
votes
1
answer
463
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 "...
0
votes
1
answer
342
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 ...
fpSPQR
0
votes
0
answers
344
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 ...
- 1
0
votes
1
answer
569
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 ...
- 3
-2
votes
1
answer
566
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 ...
- 163
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 ...
- 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....
- 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 ...
- 1,088
0
votes
0
answers
35
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 ...
- 75
1
vote
2
answers
57
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 ?
- 11
0
votes
1
answer
32
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 ...
- 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 ...
0
votes
1
answer
558
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
0
votes
1
answer
65
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, ...
- 784
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 ...
- 355
1
vote
1
answer
228
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 ...
- 113
-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 ...
- 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)...
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 ...
- 784
0
votes
1
answer
138
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 ...
- 1
0
votes
1
answer
989
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 ...
- 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 ...
- 41
6
votes
3
answers
16k
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 ...
- 161
2
votes
2
answers
247
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 ...
- 503
3
votes
2
answers
137
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,931
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 ...
- 11
0
votes
1
answer
743
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 ...
- 103
0
votes
1
answer
446
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 73
0
votes
1
answer
475
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 ...
- 831
-1
votes
2
answers
281
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 ...
0
votes
1
answer
37
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 ...
- 507
0
votes
1
answer
25
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 (...
- 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 ...
- 50
6
votes
1
answer
7k
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 ...
- 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 ...
- 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 ...
- 185
15
votes
2
answers
7k
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. ...
- 459
3
votes
4
answers
239
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. ...
- 91
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
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. ...
- 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 ...
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 ...
- 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 ...
- 41
35
votes
4
answers
29k
views
CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?
We are beginning to provision a set of physical servers for a virtual cluster of SQL Server 2016 nodes within VMware. We will be utilizing Enterprise Edition licenses.
We plan on setting up 6 nodes, ...
- 1,564