Lenovo SR650 V4 Optimizing Microsoft SQL Server
Specifications
- Khoom siv: Lenovo ThinkSystem SR650 V4
- Database Solution: Microsoft SQL Server 2022
- Processor: 2x Intel Xeon 6787P 86 core 3.8 GHz processors
- Nco: 2TB
- Cia: Micron 3.8TB NVMe tsav
Cov lus qhia siv khoom
Cov ntaub ntawv loj hlob kev sib tw thiab kev daws teeb meem
- Nyob rau niaj hnub no cov ntaub ntawv-nplua nuj ib puag ncig, cov koom haum ntawm txhua qhov ntau thiab tsawg tau hais txog cov ntaub ntawv nrawm nrawm, ua kom cov ntaub ntawv zoo thiab cov cuab yeej tswj hwm tseem ceeb heev.
- Kev lag luam ntawm txhua qhov ntau thiab tsawg tau raug dej nyab los ntawm cov ntaub ntawv ntawm kev nce nrawm. Nws yog ib qho tseem ceeb uas yuav tau xaiv ib qho kev daws teeb meem uas haum rau cov kev xav tau ntawm lub tuam txhab, ua rau muaj txiaj ntsig zoo tshaj plaws.
- Lenovo Solutions rau Microsoft SQL Server ntawm ThinkSystem SR650 V4 tau ua kom zoo rau ob qho tib si Online Transaction Processing (OLTP) thiab Analytics / Data Warehouse (DW). Qhov kev qhia luv luv no nta Microsoft SQL Server 2022 Enterprise khiav ntawm qhov ua tau zoo Lenovo dual-socket 2u khib mount tuam txhab server.
- Cov neeg rau zaub mov tau teeb tsa nrog 6th Generation Intel® Xeon® Scalable processors, DDR5 6400MHz nco thiab kev ua haujlwm siab NVMe tsav ntawm ntau yam kev xaiv cia, suav nrog kev txhawb nqa rau PCIe 5.0 tus qauv khoom siv rau I/O.
- Cov txheej txheem tshiab no los ntawm Intel kuj tseem muaj kev txhawb nqa rau MRDIMMs thiab CXL 2.0 nco Lub SR650 V4 server yog ib qho kev cia-ntub muab, nrog rau 40 2.5 ″ tsav bays nyob rau hauv pem hauv ntej, nruab nrab-bays thiab nram qab ntawm lub server.
- Txhawb NVMe tsav lossis SAS tsav siv ntau yam 12 Gb RAID controllers thiab SAS HBAS. Txhawb 36x NVMe tsav yam tsis muaj kev tshaj tawm ntawm PCIe txoj kab. Kev siv NVMe drives maximizes tsav I/O kev ua tau zoo nyob rau hauv cov nqe lus ntawm throughput thiab latency.
- Cov neeg rau zaub mov kuj tseem txhawb nqa M.2 tsav rau kev ua haujlwm yooj yim ntawm kev ua haujlwm khau raj lossis cov ntaub ntawv khaws cia. Lawv tuaj yeem raug ntsia sab hauv lossis tuaj yeem txuas rau pem hauv ntej lossis tom qab ntawm tus neeg rau zaub mov raws li kev sib pauv kub.
Kev lag luam database kev daws teeb meem nrog nrawm dua lub sijhawm-rau-tus nqi
Lenovo SR650 V4 cov tshuab tau sim nruj thiab kho kom txuag tau koj lub hlis ntawm kev teeb tsa, teeb tsa, kuaj, thiab kho. Nrog cov servers tshiab no, koj tau txais cov advan hauv qab notages
- Intel Xeon 6 tshiab tuaj txog nrog kev txhim kho vaj tse uas txhim kho kev ua haujlwm thiab txo nqi ua haujlwm.
- Los ntawm kev siv cov cores tseem ceeb tshaj plaws thiab cov cores uas tsis tshua muaj qhov tseem ceeb tshaj qhov kev ua kom zoo dua ntawm kev siv hluav taws xob tau ua thaum lub sij hawm ncov thiab lub sijhawm tsis nco qab.
- Txhawm rau txhawb nqa qhov ua tau zoo SQL neeg rau zaub mov, Lenovo SR650 V4 systems txhawb DDR5 nco ua haujlwm ntawm qhov nrawm mus txog 6400 MHz.
- Txhim kho qhov ceev thiab txhawb nqa ntau dua thiab loj dua databases ib tus tswv tsev
Microsoft SQL Server 2022
SQL Server 2022 suav nrog kev hloov tshiab rau cov yam ntxwv uas twb muaj lawm xws li Kev Tshawb Fawb Kev Tshawb Fawb Ntxiv rau kev tswj hwm, platform lossis lus. Pib nrog SQL 2022, runtimes rau R, Python, thiab Java tsis tau teeb tsa nrog SQL Setup. Hloov chaw, nruab ib qho kev xav tau kev cai runtime (s) thiab pob khoom. Nov yog qee qhov kev ua tau zoo hauv SQL Server 2022:
- Kev txhim kho tau ua rau tag nrho cov columnstore indexes uas tau txais txiaj ntsig los ntawm kev txhim kho ntu tshem tawm los ntawm hom ntaub ntawv.
- Kev hloov kho tam sim no rau cov nplooj ntawv thoob ntiaj teb faib cov nplooj ntawv txo cov nplooj ntawv sib cav sib ceg.
- Kev txhim kho nyob rau hauv buffer pas scan ua hauj lwm nyob rau hauv loj-nco systems los ntawm kev siv ntau CPU cores rau parallel scans
- Kev txhim kho rau Clustered ColumnStore Indices los txheeb xyuas cov ntaub ntawv uas twb muaj lawm hauv lub cim xeeb ua ntej tus tsim ntsuas ntsuas compresses cov ntaub ntawv
- Kev them nyiaj yug rau Intel QuickAssist Technology (QAT) backup compression nrog software lossis hardware acceleration (tsuas yog software compression muaj nyob rau hauv SQL Standard)
- Tempdb kev ua tau zoo txhim khu kev qha rau scalability
- Shrink database siv cov txheej txheem ua ntej qis kom txo qhov cuam tshuam rau kev ua haujlwm.
- Hauv-nco OLTP txhim kho
Nov yog qee qhov kev txhim kho kev tswj hwm
- Ntxiv Azure kev koom ua ke
- Txuas rau Azure SQL Managed Instance
- Accelerated Database Recovery (ADR)
- Ib txwm On Availability Group txhim kho
Lenovo ThinkSystem SR650 V4 muab yog qhov zoo tshaj plaws rau kev kho koj cov keeb kwm SQL Server daim ntawv thov vim lawv cov nqi qis thiab muaj peev xwm ua tau zoo. Lawv yog kev lag luam-txheej txheem x86 servers muab kev suav nqi thiab ceev ceev, siab ceev hauv zos cia. Lenovo ThinkSystem SR650 V4 servers muab qhov tsim nyog ua haujlwm rau liab qab hlau lossis virtualised SQL Servers. Kev ua haujlwm siab tuaj yeem ua tiav siv Hyper-V thiab Storage Spaces Direct thev naus laus zis, uas tau tsim rau hauv Windows Server. Ntau lub thev naus laus zis xws li NVMe cia thiab Chaw Taws Teeb Direct Memory Access (RDMA) kev sib txuas lus yog ib txwm muaj kev txhawb nqa hauv Windows Server kom ua tau zoo tshaj plaws.
Qhov kev teeb tsa no nta cov ntsiab lus hauv qab no.s
- Server: Lenovo ThinkSystem SR650 V4
- Processor: 2x 6th Gen Intel Xeon, 6787P mus txog 3.8Ghz (2.00 Ghz puag) 86 core
- Nco: 2TB ntawm DDR5 6400 MHz nco
- Cia: 8 x Micron 3.8TB NVMe
- OS Storage: 2x 960GB M.2 NVMe (RAID 1)
- Software:
- Microsoft lub Windows Server 2025
- Microsoft SQL Server 2022 Enterprise Edition
Kev teeb tsa tswv cuab ntawm ThinkSystem SR650 V4
Hauv peb qhov kev sim, peb tau siv ntau lub tshuab Hyper-V virtual ntxiv rau kev kuaj hlau liab qab. Txhua lub tshuab virtual khiav Windows Server 2022 thiab SQL Server 2022 Enterprise Edition.
Rau kev ua tau zoo SQL Server kev daws teeb meem, siv cov kev coj ua zoo tshaj plaws hauv qab no ntawm tus tswv tsev:
- Configure UEFI (BIOS) nqis rau sthe thiab Kev Ua Haujlwm hom kom ua tau zoo tshaj plaws.
- Qhib Hyper-threading hauv BIOS
- Configure lub hwj chim profile hauv Windows OS mus rau 'Kev ua haujlwm siab'.
Daim duab 1. Lenovo ThinkSystem SR650 V4
Cov ntsiab lus ntawm Kev Ntsuas Kev Ua Haujlwm thiab cov txiaj ntsig
HammerDB Configuration
Hammerdb yog qhov qhib-qhov chaw kuaj xyuas / ntsuas ntsuas rau cov ntaub ntawv muaj nyob ntawm:
- http:///www.hammerdb.com.
- Nws muaj cov cuab yeej rau kev ntsuas kev ua tau zoo ntawm OLTP thiab Analytics ua haujlwm. OLTP kev ua haujlwm yog raws li TPC-C benchmark los ntawm http://www.tpc.org, thiab Analytics workload yog raws li CH benchmark los ntawm tpc.org.
- Hammerdb 4.3 tau khiav ntawm ib qho chaw thauj khoom sib cais. Hauv qab no yog cov ntsiab lus ntawm kev sim thiab cov txiaj ntsig.
| Processor Tiam | SR650 V4 - 6th Gen Intel Xeon |
| Hardware Configuration | ThinkSystem SR650 V4, 2x Intel Xeon 6787p 86-core 3.8 GHz processors, 2TB nco, Micron
3.8TB NVMe tsav |
| Database xeem | MS SQL Server 2022 Enterprise |
| Cov cim simulated | TPC-C & TPC-H
Bare Hlau thiab Virtual |
| Database loj: TPC-C | 100 GB 800 warehouse |
| Database loj: TPC-H | 1TB - 1000 teev |
| Cov ntaub ntawv tshuab Virtual | 8 VMS nrog 64 vcpu thiab 80GB RAM |
| Lub sijhawm ua haujlwm: TPC-H | |
| Cov neeg siv virtual | 7 |
| Lub sijhawm ua haujlwm: TPC-C | |
| Cov neeg siv virtual | 400 liab qab hlau |
| Cov neeg siv virtual | 150 Virtual tshuab |
| Cov neeg siv ncua sijhawm | 1ms ib |
| TPC-C cov txiaj ntsig | |
| TPM | Bare Hlau - 6.6 lab Kev Lag Luam ib feeb (TPM) Virtualised - Cov txiaj ntsig yuav los sai sai. |
| TPC_H cov txiaj ntsig | |
| Cov lus nug ib teev QpH | Cov txiaj ntsig yuav los sai sai |
Daim Ntawv Pov Thawj
| 7 DGDCTO1W W | Server: ThinkSystem SR650 V4 - 3yr Warranty | 1 |
| C3QK | ThinkSystem SR650 V4 24 × 2.5 "Chassis | 1 |
| c9u9 ua | ThinkSystem Virtualization – Max Performance | 1 |
| BVGL | Data Center Ib puag ncig 30 Degree Celsius / 86 Degree Fahrenheit | 1 |
| C5QM | Intel Xeon 6787P 86C 350W 2.0GHz processor | 2 |
| C3QR | ThinkSystem V4 2U Performance Heatsink | 2 |
| C0 TQ | ThinkSystem 64GB TruDDR5 6400MHz (2Rx4) RDIMM | 32 |
| 5977 | Xaiv Cov Khoom Siv Cia - tsis tas yuav tsum tau teeb tsa RAID | 1 |
| C0ZU | ThinkSystem 2.5 ″ U.2 VA 3.84TB Nyeem Intensive NVMe PCIe 5.0 x4 HS SSD | 12 |
| C46 pab | ThinkSystem 2U V4 8 × 2.5 "NVMe Backplane | 2 |
| C0J | ThinkSystem M.2 B340i-2i NVMe Enablement Adapter | 1 |
| BKSR | ThinkSystem M.2 7450 PRO 960GB Nyeem Intensive NVMe PCIe 4.0 x4 NHS SSD | 2 |
| TIAB SA 4T | ThinkSystem Mellanox ConnectX-6 Lx 10/25GbE SFP28 2-port OCP Ethernet Adapter | 1 |
| AUZV | ThinkSystem Broadcom 5719 1GbE RJ45 4-Port PCIe Ethernet Adapter | 1 |
| C62D | ThinkSystem SR650/a V4 x16 Tsheb Direct Riser Qhov 5 | 1 |
| C0UB | ThinkSystem 2700W 230V / 115V Platinum CRPS Kub-Swap Power Supply v2.4. | 2 |
| ib 4l0 | 1.0m, 16A / 100-250V, C19 rau IEC 320-C20 Rack Fais Fab Cable | 2 |
| C3RQ ua | ThinkSystem V4 2U Standard Ntxuam Module | 6 |
| C2DH ua | ThinkSystem Toolless Slide Rail Kit V4 | 1 |
Yog vim li cas Lenovo
Lenovo yog $ 70 nphom nyiaj tau los Fortune Global 500 tuam txhab pabcuam cov neeg siv khoom hauv 180 lub khw thoob ntiaj teb. Kev tsom mus rau lub zeem muag siab kom xa cov thev naus laus zis thev naus laus zis rau txhua tus, peb tab tom tsim cov thev naus laus zis hloov pauv thoob ntiaj teb uas lub zog (los ntawm cov cuab yeej siv thiab kev tsim kho) thiab txhawb nqa (los ntawm kev daws teeb meem, kev pabcuam thiab software) ntau lab tus neeg siv khoom txhua hnub.
Yog xav paub ntxiv
Yog xav paub ntxiv txog cov tshuaj Lenovo no, hu rau koj tus khub lag luam Lenovo lossis mus ntsib:
https://www.lenovo.com/us/en/servers-storage/solutions/database/
Cov ntaub ntawv
Lenovo ThinkSystem SR650 V4: SR650 V4 Cov ncauj lus kom ntxaws
Microsoft SQL Server 2022: https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022? view= sql-server-ver16
Yam khoom tsev neeg
Cov tsev neeg cov khoom ntsig txog cov ntaub ntawv no yog cov hauv qab no:
- Microsoft Alliance
- Microsoft SQL Server
- Lenovo Servers thiab Storage
© Copyright Lenovo 2025. All rights reserved.
Cov cim lag luam
- Lenovo thiab Lenovo logo yog cov cim lag luam lossis cov cim lag luam ntawm Lenovo hauv Tebchaws Meskas, lwm lub tebchaws, lossis ob qho tib si.
- Cov npe tam sim no ntawm Lenovo cov cim lag luam muaj nyob rau ntawm Web at https://www.lenovo.com/us/en/legal/copytrade/.
- Cov lus hauv qab no yog cov cim lag luam ntawm Lenovo hauv Tebchaws Meskas, lwm lub tebchaws, lossis ob qho tib si:
- Lenovo® ua
- AnyBay®
- ThinkSystem®
- XClarity®
- Cov ntsiab lus hauv qab no yog cov cim lag luam ntawm lwm lub tuam txhab:
- Intel®, Intel Optane™, thiab Xeon® yog cov cim lag luam ntawm Intel Corporation lossis nws cov koom haum.
- Azure®, Hyper-V®, Microsoft®, SQL Server®, Windows Server®, thiab Windows® yog cov cim lag luam ntawm Microsoft Corporation hauv Tebchaws Meskas, lwm lub tebchaws, lossis ob qho tib si.
- TPC, TPC-C, thiab TPC-H yog cov cim lag luam ntawm Pawg Neeg Ua Haujlwm Kev Ua Haujlwm Zoo. Lwm lub tuam txhab, cov khoom lag luam, lossis cov npe kev pabcuam yuav yog cov cim lag luam lossis cov cim kev pabcuam ntawm lwm tus.
FAQs
Q: Dab tsi yog qhov tseem ceeb ntawm SQL Server 2022 ntawm Lenovo ThinkSystem SR650 V4?
A: SQL Server 2022 ntawm ThinkSystem SR650 V4 muaj kev txhim kho kev ua haujlwm, kev txhim kho kev tswj hwm, thiab kev txhawb nqa rau kev cai runtimes hauv R, Python, thiab Java.
Q: Lub hardware specifications ntawm ThinkSystem SR650 V4 yog dab tsi?
A: Lub ThinkSystem SR650 V4 yog nruab nrog 2x Intel Xeon 6787p processors, 2TB ntawm lub cim xeeb, thiab Micron 3.8TB NVMe drives.
Q: Kuv tuaj yeem ua kom zoo dua kuv cov kev daws teeb meem SQL Server ntawm ThinkSystem SR650 V4 li cas?
A: Siv cov kev coj ua zoo tshaj plaws ntawm tus tswv tsev teeb tsa, siv Hyper-V thiab Storage Spaces Direct thev naus laus zis, thiab siv NVMe cia rau kev ua haujlwm siab.
Cov ntaub ntawv / Cov ntaub ntawv
 |
Lenovo SR650 V4 Optimizing Microsoft SQL Server [ua pdf] Cov lus qhia SR650 V3, SR650 V4, SR650 V4 Optimizing Microsoft SQL Server, SR650 V4, Optimizing Microsoft SQL Server, Microsoft SQL Server, SQL Server |