Questions tagged [vmware]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 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 ...
1
vote
2answers
20 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 ?
0
votes
1answer
29 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 ...
-1
votes
1answer
57 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
1answer
69 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:...
0
votes
1answer
48 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, ...
3
votes
2answers
267 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 ...
1
vote
1answer
77 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
40 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
31 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
14 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
110 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
69 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
67 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
339 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 ...
4
votes
0answers
80 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 ...
2
votes
2answers
4k 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
150 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
118 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
62 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
455 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
128 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
564 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 ...
2
votes
1answer
623 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
779 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
323 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
141 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
29 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
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 (...
1
vote
3answers
897 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
6k 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
179 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
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. ...
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
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 ...
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 ...
33
votes
4answers
22k 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
5k 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
503 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
48 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
546 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
1k 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
917 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
913 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 ...