Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [vmware]

96 questions
36
votes
4 answers

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, but there is a bit of a debate on what the ideal…
PicoDeGallo
  • 1,554
  • 1
  • 20
  • 30
15
votes
2 answers

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. None of them are in production use yet. People…
Emptyslot
  • 459
  • 4
  • 11
12
votes
3 answers

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 was added to this SQL Server since my last post. …
Emptyslot
  • 459
  • 4
  • 11
12
votes
1 answer

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, similar to what is done here. There has been a…
JoseTeixeira
  • 1,113
  • 1
  • 8
  • 18
10
votes
3 answers

Bulk insert into SQL Server from VMWare guest using distributed switch

This is mostly likely not a SQL server issue but the setup seems to only be affecting BULK INSERTS to SQL Servers. We have recently moved VM Hardware and all the guests that were moved had their virtual switches changed from standard to…
Bob Klimes
  • 3,400
  • 1
  • 19
  • 31
9
votes
1 answer

Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?

My environment is the following: VMWare 5.5 vitalized server MS Windows Server 2008R2 Enterprise domain and SQL Server 2008 R2 Enterprise. Centralized storage with fibre-channel connection. I have partitions in my SQL Server DB. I have 2 file…
Bogdan Bogdanov
  • 1,163
  • 2
  • 18
  • 38
8
votes
1 answer

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 corresponds with the actual hardware beneath the…
Hans Vader
  • 185
  • 1
  • 9
8
votes
3 answers

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 CPUs each. The extra CPUs are "shared" between…
Kenneth Fisher
  • 24,307
  • 13
  • 63
  • 116
7
votes
4 answers

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 installation with a single core. I am attempting to explain…
Deb
  • 73
  • 5
6
votes
1 answer

SQL Server Buffer Pool Utilization under VMWare

I recently migrated a physical SQL Server box (2012) over to ESX (5.1) simply for ease of administration. It is and will be the only guest on the server. As expected there was a marginal performance hit that for the most part is only noticeable on…
bumble_bee_tuna
  • 977
  • 2
  • 11
  • 20
6
votes
3 answers

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 null, ip varchar(50), …
barteloma
  • 161
  • 1
  • 1
  • 3
6
votes
1 answer

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 troubleshoot? Connection Timeout Expired.  The…
Mitch
  • 2,688
  • 2
  • 19
  • 24
6
votes
3 answers

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 Server 2008r2, SQL Server 2012 1 vCPU with 6 cores…
pshore73
  • 427
  • 3
  • 9
5
votes
1 answer

Find out why SQL Server released memory

I have a SQL Server 2008 R2 used for sharepoint and ssrs. The SQL Server hosts two instances. For a few minutes both instances were timing out, not responding. CPU slowly rose to 100%, 30% from both instances, and 30% from the OS (and a few…
Reaces
  • 2,681
  • 4
  • 27
  • 38
5
votes
2 answers

Are there benefits to using more than 4 CPUs for MySQL?

We are running MySQL 5.5 on linux under VMWare, running on 2 CPUs. We are planning on increasing this to 4, but we have un-used CPUs available, and I'm wondering if there is any benefit to increasing the number to 8?
chris
  • 1,232
  • 5
  • 17
  • 29
1
2 3 4 5 6 7