Questions tagged [vmware]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
52 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 ...
0
votes
0answers
39 views

64k disk cluster size and vSAN [duplicate]

It's time to ask again this popular question: "Is it still valuable for the I/O performance to manage disk cluster size?" But this time I'm interested in a case with vSAN as storage. I've ...
-2
votes
0answers
30 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 ...
0
votes
0answers
13 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
1answer
72 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 ...
0
votes
0answers
40 views

Is safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool?

I would like to know if it is advisable or safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool, my doubt is caused because I have several vm with Oracle ...
0
votes
1answer
58 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 ...
0
votes
1answer
155 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 ...
3
votes
0answers
77 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 ...
1
vote
2answers
735 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 ...
2
votes
2answers
112 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 ...
3
votes
2answers
112 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
vote
0answers
55 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 ...
0
votes
1answer
292 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 ...
0
votes
1answer
123 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 ...
1
vote
1answer
390 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 ...
1
vote
1answer
410 views

error connecting to master 'replica@192.168.57.10: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 ...
0
votes
0answers
711 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 ...
7
votes
4answers
1k 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 ...
0
votes
1answer
277 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 ...
-1
votes
2answers
107 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
1answer
28 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 ...
0
votes
1answer
24 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 (...
1
vote
3answers
795 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 ...
6
votes
1answer
5k 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 ...
11
votes
3answers
5k 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 ...
8
votes
1answer
2k 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 ...
14
votes
2answers
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. ...
3
votes
4answers
154 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. ...
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
2answers
1k 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. ...
1
vote
1answer
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
1answer
917 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 ...
3
votes
1answer
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 ...
32
votes
4answers
20k 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, ...
3
votes
1answer
4k views

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

A few times a day, it is not able to connect and the error mentions: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. ...
2
votes
2answers
493 views

VMWare Memory Sizing and SQL Server 2014

We have a production server that dumps it's Page Life Expectancy many times a day (climbs to 2500s and falls back to near 0s)... After watching some training videos about virtualization for SQL Server,...
0
votes
1answer
52 views

SQL 2008 R2 performance problems - mixed signals on disk performance

I'm having no end of trouble with one of our production SQL boxes - users are experiencing massive drop offs in performance and this is having severe impacts on the business. I've been investigating ...
0
votes
1answer
46 views

Deadlock issue on vCAC6 on SQL Server

We have a 2 node AAG setup with vCaC6 application running on it. Quite often, I get deadlock alerts from the server, and by the time I open the activity monitor, the deadlocks are no longer present. ...
3
votes
2answers
484 views

SQL Backup/Restore and Disaster Recovery solutions with VMware

Is vSphere Replication safe for SQL databases? We are a virtual environment (Cisco hardware + VMware hosts + HP san). We have a primary and disaster recovery datacenter, with SAN-level replication ...
1
vote
2answers
935 views

Oracle vs SQL Server, 4k vs 16k block sizes

I was reading over these 3 articles: At my last company we only used MS SQL Server and MySQL, and if a server was strictly a database server we would setup the HDD to use 16k block sizes. http://...
4
votes
2answers
864 views

4 CPUs of 20 (NUMA node 0) Pegged at 100%

The previous Senior DBA left the company and I was made aware of a server which suffers from multiple problems, largely slowness (all the way from SSMS taking a long time to open, long running queries,...
1
vote
1answer
867 views

Cannot connect to database hosted at CentOS VM through SQL Developer on Windows [closed]

I've installed Oracle 12c smoothly today and was able to start lsnrctl and database. SQL*Plus connection is okay inside VM. I've set the IP address to be static @ 192.168.0.20 (CentOS VM). I am able ...
1
vote
2answers
945 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 ...
1
vote
1answer
60 views

Precautions for moving a SQL cluster from an old to a new datastore

My storage team wants to move a SQL cluster (2 node VM) from an old data store to Storage vMotion . What are the precautions I can take before this exercise is performed? I am planning to take ...
1
vote
1answer
596 views

AlwaysOn Availability Groups - Proper Quorum across WAN

I am evaluating the usage of AlwaysOn Availability groups with one node located in one data center, and another node located in a DR site. Both nodes are running in vmware on the same domain. I've ...
2
votes
1answer
2k views

Intermittent “Login timeout expired” after migrating to VmWare SQL Server

We are experiencing intermittent Login timeout expired in our application after migration from a physical standalone SQL Server 2008 R2 / W2k8 R2 to a VMWare SQL Server 2014 / Win 2012 R2. It is ...
0
votes
1answer
263 views

Why is SQL Server 2012 memory usage limited to 4 GB

I have an SQL Server Installation which suffers very bad performance due to lack of memory (queries runnig very slow, RESOURCE_SEMAPHORE...). The memory usage never goes above ~4.1 GB, although the ...
12
votes
1answer
2k 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, ...
3
votes
0answers
695 views

Move SQL Server cluster from one location to other

I am looking for ideas on how to move SQL Server 2012(standard) two node cluster installed on Windows server 2012 standard to other location which is far away from current location. The two locations ...