22110 (Single; AHCI Not Supported) by Latoya Luckett

Name: DMLIANKE M.2 NVME PCIe Adapter with Low Profile Bracket - M Key SSD to PCI-e 3.0 x4 Host Controller Expansion Card for 2230/2242/2260/2280/22110 (Single; AHCI Not Supported)
Item: DMLIANKE M.2 NVME PCIe Adapter with Low Profile Bracket - M Key SSD to PCI-e 3.0 x4 Host Controller Expansion Card for 2230/2242/2260/2280/22110 (Single; AHCI Not Supported)
Rating: 5

October 29, 2022

Big speed boost for dedicated database

Place a large (5+ billion rows) database on Windows 2019 Server. The database is an archive so I only need to read the data apart from the temp tables created during the query. This card has a dedicated 4TB internal NVME for database files, including all temporary tables. Queries that used to take minutes in a disk-based RAID now take seconds.

Pros