All Questions
6 questions
0
votes
1
answer
629
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,210
0
votes
1
answer
72
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, ...
- 794
3
votes
2
answers
4k
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
242
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
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
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