Questions tagged [vmware]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
38 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
45 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
98 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
165 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
466 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 ...
8
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
172 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
75 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
21 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
22 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
596 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
3k 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
4k 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 ...
7
votes
1answer
1k 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 ...
13
votes
2answers
5k 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
105 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
819 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
1k 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
618 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
1k 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 ...
30
votes
4answers
14k 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
3k 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. There ...
2
votes
2answers
425 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
50 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
45 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
370 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
623 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
751 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
638 views

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

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 ...
0
votes
1answer
716 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
55 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
512 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
205 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
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, ...
3
votes
0answers
511 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 ...
0
votes
1answer
112 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 ...
0
votes
1answer
48 views

VMware vFabric Data Director [closed]

https://www.brentozar.com/archive/2013/04/cloud-alternatives-to-microsoft-sql-server/ I liked the idea of VMware vFabric Data Director so I can host data in own cloud / data centre. It seems this ...
1
vote
1answer
2k views

Install SQL Server 2014 SP1 on VMWare workstation 12 player

I am not able to install SQL 2014 SP1 on VMWare workstation 12 player. Please review my post and give me some feedback on how to resolve the issue. Your input is greatly appreciated! Hardware ...
2
votes
2answers
1k views

Running SQL Server on VMWare along with many other VM's

Excuse the long question, this is my first on the board. I have just joined an organisation that is running a mission critical SQL server 2012 on a VMWare host along with another 9 (at least) VM's (...
2
votes
1answer
2k views

VMWare VMotion causing performance to increase?

We've been experiencing strange issues for awhile now with our virtual environment running SQL Servers. We randomly get calls from users about very poor performance on the SQL boxes. Sure enough when ...
2
votes
1answer
444 views

SQL Server 2014 Minimum Memory configuration - VMware

I am taking over a SQL Server 2014 environment which has been built and configured by a consultant. They have set a minimum value for memory which I usually set to 0. According to the consultant ...
3
votes
2answers
930 views

SQL Server Trace Flag 834 on VMware

It's recomended to enable trace flag 834 to use large-page on buffer pool for SQL Server running on VMware? The tuning options kb of Microsoft (https://support.microsoft.com/en-us/kb/920093) don't ...
4
votes
1answer
637 views

Best Practices to reconfigure SQL Server for VMware

What I want to know is why would someone configure a server this way. 3 instances of SQL Server on the machine, 64GB RAM, no affinity mask settings and MAXDOP 0 with CostThreshold 5. I want to give ...
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 ...
1
vote
1answer
68 views

SQL server on VMWare restart loses five days of data

I am just now in the midst of a strange issue. A client moved their SQL database server from Hyper-V to VMWare on Saturday. Yesterday they called me complaining about performance. In the brief time ...
5
votes
1answer
109 views

Different Disk Drive Same Backend Storage

I have a database running on a VM which is getting hammered during a large load, in particular I can see waits of WRITELOG happening. My initial thought is to split the files out on to their own ...
5
votes
3answers
873 views

Virtualize SQL High CPU

This is a client environment which needs significant overhaul so all I am trying to do is slow the bleeding. Situation CPU is getting crushed, often 80% or higher utilization VMWARE 5.5, Windows ...
5
votes
2answers
174 views

Virtualized SQL Server Memory Oddity

I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager*, sqlserver.exe is ...