性能升级op SQL VM [英] Performance upgrade op SQL VM
问题描述
我是b $ b我为SQL设置了一个新的VM。 软件供应商在其上安装了SQL2017及其应用程序。客户抱怨应用程序的性能和速度。
有没有办法可以批准虚拟机的性能或者说应用程序的性能。 通过添加更多VCPU?更多记忆?其他设置??¥b $ b欢迎任何帮助。
这是我使用的主机:
HP DL380 G10 - 2处理器XeonSilver 4110 - RAM 144Gb - SAS磁盘10K
RAID5 - >主机
RAID6 - > VM的
这些是(VM)SQL服务器的VM设置
1虚拟CPU
32Gb RAM(非动态)
Disksize为1Tb
委托,b
$
Jo
Hi,
I did setup a new VM for SQL. Software vendor installed SQL2017 on it and their application. Clients are complaining about performance and speed of the application.
Is there a way i can approve the performance of the virtual machine or with other words the performance of the application. by adding more VCPU ? more Memory ? other settings ??
Any help would be welcome.
This is the Host i use :
HP DL380 G10 - 2 processors XeonSilver 4110 - RAM 144Gb - SAS disks 10K
RAID5 -> Host
RAID6 -> VM's
These are the VM settings for the (VM) SQL-server
1 Virtual CPU
32Gb RAM (not dynamic)
Disksize is 1Tb
Regards,
Jo
推荐答案
添加更多资源肯定会有所帮助,但请注意您没有解决问题,只是让服务器更强大,这可能会掩盖性能问题。你需要找出导致问题的原因,下面应该让你开始
Adding more resources will definitely help but please note you are not curing the problem but only making server more powerful which may mask the performance problem. You need to find out what is causing issue and below should get you started
这篇关于性能升级op SQL VM的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!