SQL Server 2022 running slow

dcarvalho

New Member
Nov 5, 2024
1
0
1
Hey,

I've installed Proxmox VE on a Dell PowerEdge R630 with 2xCPU E5-2620 v3/128GB RAM/ 5 SSD's Samsung PM893 960GB.
Created in the dell raid controller a RAID10 with 4 SSD's and 1 as a Global hot spare.

Created 2 Windows servers 2022 on that raid and on one of them installed SQL Server 2022, but the performance on SQL for querys is too slow. Used SCSI controller, ssd emulation, write back and discard. (SQL machine has host cpu, 10 cores and 64gb of ram)

Show i do anything different to speed up things?
 

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!