Lenovo ThinkSystem SR650ã¯ãDBMSãä»®æ³åãšã¯ã©ãŠããä»®æ³ãã¹ã¯ãããã€ã³ãã©ã¹ãã©ã¯ãã£ïŒVDIïŒãããŸããŸãªãšã³ã¿ãŒãã©ã€ãºã¢ããªã±ãŒã·ã§ã³ãããžãã¹ã€ã³ããªãžã§ã³ã¹ãªã©ãããŸããŸãªäžå°äŒæ¥ã«é©ãã2U2ãœã±ããã©ãã¯ãµãŒããŒã§ãããšããã°ããŒã¿ã
ã¹ããŒããä¿¡é Œæ§ãå®å šæ§ã管çã®ãããã
SR650ã«ã¯ãçç£æ§ãé«ããããã®å€ãã®æ©èœããããŸããããã¯äž»ã«ãããã»ããµãããæå€§28ã³ã¢ã®ç¬¬2äžä»£IntelXeonã¹ã±ãŒã©ãã«ããã»ããµãââã¡ããªã䜿çšããããšã§å®çŸãããŸããåèšã§ããµãŒããŒã¯2ã€ã®ããã»ããµãŒããµããŒããããããã£ãп倧56ã³ã¢ããµããŒãããŸãã
ãµãŒããŒã«ã¯RAMçšã®24ã¹ããããããããµãŒããŒãããã®æå€§å®¹éã¯æå€§3 TBã§ãã¡ã¢ãªåšæ³¢æ°ã¯æå€§2933MHzã§ãã
SR650ãã£ã¹ã¯ãµãã·ã¹ãã ã¯ãããã©ãŒãã³ã¹ãæé©åãããæ§æã®å Žåã¯24åã®2.5 "ããã³23.5"ãã©ã€ãã容éãæé©åãããæ§æã®å Žåã¯æå€§14åã®3.5 "ãã©ã€ããåãããã©ãŒã ãã¡ã¯ã¿ã§ãæè»ã§ã¹ã±ãŒã©ãã«ãªå éšã¹ãã¬ãŒãžãæäŸããå¹ åºãSAS / SATA HDD / SSDããã³PCIenNVMeSSDã®éžæãéèŠãªå©ç¹ã¯ãåãAnyBayãã©ã€ããã€ã§SASãSATAããŸãã¯NVMePCIeãã©ã€ãã䜿çšã§ããããšã§ãã
é»åãšå·åŽã®å¯çšæ§ã®èгç¹ãããSR650ã«ã¯åé·ãªãããã¹ã¯ããå¯èœãªé»æºãšãããã¹ã¯ããå¯èœãªãã¡ã³ãæèŒãããŠããŸãã
ãµãŒããŒã®èé¢ããã«ã«ã¯ãæå€§5ã€ã®PCI-eãã€ã³ã¹ããŒã«ããæ©èœãããããã®ãã¡ã®2ã€ã¯ãã°ã©ãã£ãã¯ã¹VDIãç·šæããããã®ã°ã©ãã£ãã¯ã¹ã¢ããã¿ãŒã«äœ¿çšã§ããŸãã
ããã«ã1ãŸãã¯10ã®ã¬ãããã€ãŒãµãããã®ããŒããããã«4ã€æäŸã§ããLOMã«ãŒããæäŸãããŸãã
ãŸããSR650ãµãŒããŒã¯æ¹é ãã¡ã³ããã³ã¹ã®é¢ã§éåžžã«äŸ¿å©ã§ããã©ã€ããŒã䜿ããã«ãµãŒããŒã«ããŒãå€ããã®ã§ã管çè ã®æéãå€§å¹ ã«ç¯çŽã§ããŸãã
XClarity管çãœãããŠã§ã¢ã¹ã€ãŒãã«åºã¥ã匷åãªç®¡çæ©èœã«ãããSR650ã®ããŒã«ã«ç®¡çãšãªã¢ãŒã管çã®äž¡æ¹ãç°¡çŽ åãããŸãã
XClarity Controllerã¯ãé«åºŠãªç®¡çãç£èŠãããã³ã¢ã©ãŒãæ©èœãæäŸããŸãã
XClarity Controllerã䜿çšãããšãã·ã¹ãã ãã©ã¡ãŒã¿ãç¶ç¶çã«ç£èŠããã¢ã©ãŒããèªåçã«ããªã¬ãŒããŠãé害ãçºçããå Žåã«å埩ã¢ã¯ã·ã§ã³ãå®è¡ã§ããŸãã
çµã¿èŸŒã¿ã®XClarityProvisioning Managerã¯ãã·ã¹ãã ã®ã»ããã¢ãããæ§æãããã³æŽæ°ãç°¡çŽ åããŸãã
å€§èŠæš¡ãªãµãŒããŒçŸ€ã管çããããã«ãLenovo XClarity AdministratorããµããŒããããŠããŸããããã«ãããã³ã³ãã¥ãŒã¿ãŒã ãã§ãªããLenovo XClarityã¢ãã€ã«ã¢ããªã±ãŒã·ã§ã³ã䜿çšããŠãã©ãããã§ãå æ¬çãªéäžç®¡çãå¯èœã«ãªããŸãã
ä»ã®äžè¬çãªç®¡çã·ã¹ãã ãšã®çµ±åã«ã¯ãVMwarevCenterããã³MicrosoftSystemCenterããµããŒãããLenovoXClarity Integratorsãå©çšå¯èœã§ãããXClarity Administratoræ©èœãä»®æ³å管çãœãããŠã§ã¢ããŒã«ã«æ¡åŒµãã管çè ãã€ã³ãã©ã¹ãã©ã¯ãã£ãæåããæåŸãŸã§å±éããã³ç®¡çã§ããããã«ããŸãã
ãã¡ã€ããã§ãã¯ããã¹ãçµæã®ããŒã
2019幎3æãTPC Benchmark-EïŒTPC-EïŒã¯ãé«è² è·ã®MS SQL ServerDBMSã®ãµãŒããŒãšããŠSR650ãµãŒããŒã®ã¹ãã¬ã¹ãã¹ãã宿œããŸããã
TPC-Eã«ã€ããŠ
TPCãã³ãããŒã¯EïŒTPC-EïŒã¯ããªã³ã©ã€ã³ãã©ã³ã¶ã¯ã·ã§ã³åŠçïŒOLTPïŒã¯ãŒã¯ããŒãã§ããããã¯ãè€éãªOLTPã¢ããªã±ãŒã·ã§ã³ç°å¢ãæš¡å£ãããèªã¿åããšæŽæ°ãå€çšãããã©ã³ã¶ã¯ã·ã§ã³ã®æ··åè² è·ã§ããããŒã¿ããŒã¹ã¹ããŒããããŒã¿ããã¥ã¬ãŒã·ã§ã³ããã©ã³ã¶ã¯ã·ã§ã³ãããã³ãã¹ãå®è£ ã«ãŒã«ã¯ãææ°ã®OLTPã·ã¹ãã ã®ã¯ãŒã¯ããŒãã®æŠèŠãæäŸããããã«èšèšãããŠããŸãããã³ãããŒã¯ã§ã¯ããã®ãããªç°å¢ã«é¢é£ããããŸããŸãªã·ã¹ãã ã³ã³ããŒãã³ãã調ã¹ãŸãããããã®ã³ã³ããŒãã³ãã®ç¹åŸŽã¯æ¬¡ã®ãšããã§ãã
- ããŸããŸãªè€éãã®ããã€ãã®ã¿ã€ãã®ãã©ã³ã¶ã¯ã·ã§ã³ã®åæå®è¡ã
- - ;
- ;
- ;
- , , .
ãã®ãã¹ãã§ã¯ãTPC-Eãã¹ãã¯èšŒåžäŒç€Ÿã®OLTPã¯ãŒã¯ããŒããã·ãã¥ã¬ãŒãããŸãããã³ãããŒã¯ã¯ãäŒç€Ÿã®é¡§å®¢ã¢ã«ãŠã³ãã«é¢é£ãããã©ã³ã¶ã¯ã·ã§ã³ãå®è¡ããäžå€®ããŒã¿ããŒã¹ã«çŠç¹ãåãããŠããŸããããŒã¿ããŒã¹ã·ã¹ãã ã®ããã©ãŒãã³ã¹ç¹æ§ã枬å®ããç®çã§ããã³ãããŒã¯ã¯ãå®éã®ç°å¢ã«ååšããå¯èœæ§ã®ããè€æ°ã®ã¢ããªã±ãŒã·ã§ã³ã·ã¹ãã éã®è€éãªããŒã¿ãããŒã枬å®ããããšã¯ããŸããã
ããŸããŸãªã¿ã€ãã®ãã©ã³ã¶ã¯ã·ã§ã³ããäŒæ¥ãšãã®é¡§å®¢ããã³ããžãã¹ããŒãããŒãšã®çžäºäœçšãã·ãã¥ã¬ãŒãããŸãããã©ã³ã¶ã¯ã·ã§ã³ã®çš®é¡ãç°ãªãã°ãå®è¡æéã®èŠä»¶ãç°ãªããŸãã
ãã¹ãã¯ä»¥äžã決å®ããŸãïŒ
- 顧客ããäŒæ¥ãžã®ãã©ã³ã¶ã¯ã·ã§ã³ãšäŒæ¥ããäŒæ¥ãžã®ãã©ã³ã¶ã¯ã·ã§ã³ïŒã€ãŸããããžãã¹ããŒãããŒéã®çžäºäœçšïŒãã·ãã¥ã¬ãŒãããããã®2çš®é¡ã®ãã©ã³ã¶ã¯ã·ã§ã³ã
- ãã©ã³ã¶ã¯ã·ã§ã³ã®ã¿ã€ãããšã«ããã€ãã®ãã©ã³ã¶ã¯ã·ã§ã³ã
- ãã©ã³ã¶ã¯ã·ã§ã³ã®ã¿ã€ãããšã«ç°ãªãå®è¡ãããã¡ã€ã«ã
- å®çŸ©ããããã¹ãŠã®ãã©ã³ã¶ã¯ã·ã§ã³ã®å®è¡æéã®ç¹å¥ãªçµã¿åããã
ããšãã°ãããŒã¿ããŒã¹ã¯ã顧客ãšããåãããã·ã¹ãã ã«ãã£ãŠçæããããã©ã³ã¶ã¯ã·ã§ã³ãšãéèåžå Žããã³ç®¡çã·ã¹ãã ãšããåãããã·ã¹ãã ã«ãã£ãŠçæããããã©ã³ã¶ã¯ã·ã§ã³ãåæã«å®è¡ããŸãããã³ãããŒã¯ã·ã¹ãã ã¯ãããŸããŸãªãã©ã³ã¶ã¯ã·ã§ã³ãœãŒã¹ãã·ãã¥ã¬ãŒãããäžé£ã®ã¢ããªã±ãŒã·ã§ã³ãšçžäºäœçšããŸãã
TPC-Eããã©ãŒãã³ã¹ã¡ããªãã¯ã¯ããããžãã¹ã¹ã«ãŒããããã®å°ºåºŠã§ããã1ç§ãããã«åŠçãããããžãã¹ïŒååŒïŒã¢ã¯ãã£ããã£ã®çµæãå«ãå®äºãããã©ã³ã¶ã¯ã·ã§ã³ã®æ°ãšã1ãã©ã³ã¶ã¯ã·ã§ã³ã®ã³ã¹ãããã«ã§åæ ããŸããè€æ°ã®ãã©ã³ã¶ã¯ã·ã§ã³ã䜿çšããŠããžãã¹ãã©ã³ã¶ã¯ã·ã§ã³åŠçãã·ãã¥ã¬ãŒãããåãã©ã³ã¶ã¯ã·ã§ã³ã«ã¯å¿çãå¿ èŠã§ãããã³ãããŒã¯ã®ããã©ãŒãã³ã¹ã¡ããªãã¯ã¯ãTransactions Per Second-EïŒtpsEïŒã§è¡šãããŸãã
ãã¹ããã³ãæ§æ
ãµãŒããŒ-ã¯ã©ã€ã¢ã³ãDBMSïŒLenovo ThinkSystem SR650ïŒ
- 2xXeon Platinum 8168 2.7 GHzïŒ2 CPU / 48ã³ã¢/ 96ã¹ã¬ããïŒ
- 96 GB RAM
- 2x300GB SAS HDD RAID-1
DBMSãµãŒããŒïŒLenovo ThinkSystem SR650ïŒ
- 2xXeon Platinum 8260 2.7 GHzïŒ2 CPU / 56ã³ã¢/ 112ã¹ã¬ããïŒ
- 1536 GB RAM
- 2x800GB SAS SSD RAID-1
- 6x800GB SAS SSD RAID-10
- 4xLenovoã¹ãã¬ãŒãžD1224ïŒ12 Gbs SASãã£ã¹ã¯ã·ã§ã«ãã2ã€ã®RAIDã°ã«ãŒãã§æ§æããã74x800 GB SAS SSDïŒ4x17 RAID-5ã1x6 RAID-10ïŒ
ãµãŒããŒã¯ã4ã€ã®10GbEãªã³ã¯ã䜿çšããŠçžäºæ¥ç¶ãããŠããŸãã
ã¹ã¿ã³ãã®æ§æã®è©³çްã以äžã«ç€ºããŸãã
ããŒããŠã§ã¢æ§æããœãããŠã§ã¢ãããã³ãã¹ãæ¹æ³ã«é¢ãã詳现ããŒã¿ã¯ããããªãã¯ãã¡ã€ã³ã«ããTPC-Eã¬ããŒãã§çŽæ¥è¡šç€ºã§ããŸããtpc.org / 4084ãã¹ã
çµæãã¹ã
çµæã¯ã次ã®3ã€ã®ãã¹ãã°ã«ãŒãã§æ§æãããŸãã
- éåžžã®åäœã¢ãŒã
- ããŒã¿ã®å¯çšæ§
- çœå®³ããã®å埩
éåžžã¢ãŒãéåžžã¢ãŒãã§ã®
ãã¹ãã¯ã2ã€ã®æ®µéã§æ§æãããŸããæåã®æ®µéã§ã¯ãã·ã¹ãã ãããŠã©ãŒã ã¢ããããããŠå®å®ããã¯ãŒã¯ããŒãã®ç¶æ ã«ãªãããã®æž¬å®ã宿çãªãã¹ãã®ç®æšã«ãªããŸãã
å®åžžç¶æ ã®ãã³ãããŒã¯çµæã§ã¯ãSR650ã¯æ¯ç§7000ãã©ã³ã¶ã¯ã·ã§ã³ããããã«è¶ ããã¬ãŒããç¶æããŠããŸã-Eã
ã«ãŒãã³ãã¹ãã®çµæãäžã®ã°ã©ãã«ç€ºããŸãã
ããŒã¿ã®å¯çšæ§ããŒã¿ã®å¯çšæ§ã®
枬å®ã«ã¯ããã£ã¹ã¯ãµãã·ã¹ãã ã®é害ãã·ãã¥ã¬ãŒãããããŸããŸãªæäœã®å®è¡ãå«ãŸããŸãã
ããŒã¿ã®å¯çšæ§ã¯ãããŒã¿ããŒã¹ããŒãã«ããªã«ããªãã°ããŒã¿ããŸãã¯ããŒã¿ããŒã¹ã¡ã¿ããŒã¿ãå«ãåäžã®ãã£ã¹ã¯ã®æ°žç¶çãªèŽåœçãªé害ã®åŸã«ãã¢ããªã±ãŒã·ã§ã³ãå®å šãªããŒã¿ã¢ã¯ã»ã¹ã§ããŒã¿ããŒã¹æäœããµããŒãã§ãããšããäºå®ã«ãã£ãŠå®èšŒãããŸãã
ããŒã¿å¯çšæ§ãã¹ãã¯ãã¢ããªã±ãŒã·ã§ã³ã«ããããŒã¿ãžã®ã¢ã¯ã»ã¹ãç£èŠããªãããããŸããŸãªã¿ã€ãã®ããŒã¿ãæ ŒçŽãããã£ã¹ã¯ãç¡å¹ã«ããããšã«ãã£ãŠå®è¡ãããŸãã
以äžã¯ãããŸããŸãªã¿ã€ãã®ããŒã¿ãæ ŒçŽãããã£ã¹ã¯ã¢ã¬ã€ã®ã¿ã€ãã§ãã
ããŒã¿å¯çšæ§ãã¹ãäžã«ãæ¬¡ã®æé ãå®è¡ãããŸããã
- ããŒã¿ããŒã¹ãã°ã¢ã¬ã€ã§ãã£ã¹ã¯é害ãçºçããŸããïŒãã£ã¹ã¯ããµãŒããŒããç©ççã«åé€ãããŸããïŒã
- 5 , tempdb.
- 5 , .
ãã¹ãŠã®ã¢ã¬ã€ãç°ãªãRAIDã¬ãã«ã§ä¿è·ãããŠãããããããŒã¿ã¢ã¯ã»ã¹ã忢ããããšã¯ãªããçæéã®ããã©ãŒãã³ã¹ã®äœäžãé€ãã°ã圱é¿ã¯ãããŸããã§ããã
æ°ååŸããé害ãçºçããããã£ã¹ã¯ã眮ãæããããã«3ã€ã®æ°ãããã£ã¹ã¯ãé£ç¶ããŠã€ã³ã¹ããŒã«ãããããŒã¿ã¢ã¬ã€ã埩å ããããã»ã¹ãéå§ãããŸãããåæ§ç¯ããã»ã¹ã«ãããããã©ãŒãã³ã¹ãå€§å¹ ã«äœäžããŸããããã¹ãŠã®ããŒã¿ã»ãããå®å šã«å埩ããããŸã§ãI / OãªãœãŒã¹ã®äžéšã¯ãDBMSæäœã§ã¯ãªãåæ§ç¯ã«è²»ãããããããããã¯æ£åžžãªåäœã§ãã
以äžã¯ãããŒã¿ã®å¯çšæ§ããã¹ãããããã®ã°ã©ãã§ãã
çœå®³ããã®å埩
æåŸã®çœå®³åŸ©æ§ãã¹ãã¯ãDBMSãµãŒããŒãå®å šã«ç¡å¹ã«ããé倧ãªçœå®³ã®åŸã«ã·ã¹ãã å šäœã埩å ããããã»ã¹ã§ããã¯ãŒã¯ããŒããéåžžã®çŽ7000tpsEã«æ»ããšãçœå®³åŸ©æ§ã¯æåãããšèŠãªãããŸãã
çœå®³åŸ©æ§ããã¹ãããããã«ãæ¬¡ã®æé ãå®è¡ãããŸããã
- ãã¹ãŠã®é»æºã³ãŒããDBMSãµãŒããŒããåãå€ããããããããã«ã·ã£ããããŠã³ããŸãããã¡ã€ã³ã¡ã¢ãªãšãµãŒããŒãã£ãã·ã¥ã®ãã¹ãŠã®å 容ã倱ãããŸããããµãŒããŒå ã®ãã¹ãŠã®RAIDãã£ã¹ã¯ã³ã³ãããŒã©ãŒã¯ããããªãŒãªãã§å®è¡ãããŠããããããã¹ãŠã®ãã£ã¹ã¯ã³ã³ãããŒã©ãŒã®ãã£ãã·ã¥ã³ã³ãã³ãã倱ãããŸããã
- 黿ºã±ãŒãã«ãæ¥ç¶ãããDBMSãµãŒããŒã®é»æºããªã³ã«ãªã£ãŠããŸãã
- tempdbã®ãã¹ãŠã®ããŒã¿ãšãã°ãã¡ã€ã«ãåé€ããŸããã
- SQL Server. . SQL Server , tpce , .
- SQL Server « » . 15 .
ããŒã¿ããŒã¹ã®ãªã«ããªãçµäºããŠãããã¹ãŠã®ã¢ããªã±ãŒã·ã§ã³ã®ãªã«ããªãéå§ããããŸã§ã«æéééãããã倿°ã®ãã©ã³ã¶ã¯ã·ã§ã³ãåèµ·åããå¿ èŠããã£ãããïŒç¶ç¶ããã ãã§ãªãïŒããããã®ãã©ã³ã¶ã¯ã·ã§ã³ã¯ããŒã¿ããŒã¹ã埩å ãããåŸã«ã®ã¿å®è¡ããå§ããŸããïŒã°ã©ãã®èµ€ãç·ãåç §ïŒãçŽ10åã
ãããã£ãŠãçœå®³åŸ©æ§ã®çµããã¯ããã¹ãŠã®ã¢ããªã±ãŒã·ã§ã³ã®ã¯ãŒã¯ããŒãã®å®å šãªåŸ©æ§ã§ããéãšèµ€ã®ç·ãå ¬ç§°å€ã®çŽ7000tpsEã«éããã°ã©ãäžã®æç¹ã
åèšïŒ
- ããŒã¿ããŒã¹ã埩å ããæéã¯00:15:33ã§ãã
- ã¢ããªã±ãŒã·ã§ã³ã®å埩æéã¯00:10:06ã§ãã
- å®å šãªçœå®³åŸ©æ§æéã¯00:25:39ã§ãã
- ãã©ã³ã¶ã¯ã·ã§ã³ã¿ã€ãããšã«åé¡ãããã¬ããŒãã®æŠèŠã以äžã«ç€ºããŸãã
tpsEã®ã¹ã³ã¢ãš1åã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ã³ã¹ãã«é¢ããæçµçãªçµè«ã以äžã«ç€ºããŸãã
ãã©ã³ã¶ã¯ã·ã§ã³ã³ã¹ãã90.99ãã«ã®7012.53tpsEã®ææšã¯ãããããµãŒããŒã®Lenovo ThinkSystem SR860V2ã1äœã§ããTPC-Eã®ãããããã©ãŒãã³ã¹çµæè©äŸ¡ã§2äœã«ãªããŸããã ïŒ tpc.org/tpce/results/tpce_perf_results5.asp?resulttype=allïŒãããã³TPC-Eããããã©ã€ã¹/ããã©ãŒãã³ã¹çµæè©äŸ¡ã§3äœãSR860ã1äœãç«¶åä»ç€Ÿã®ãœãªã¥ãŒã·ã§ã³ã¯2äœ ã§ãã
ããã¯éåžžã«ãŸãšããªææšã§ãããã®çµæãä»ã®Lenovo補åãšåæ§ã«ãæé ãªäŸ¡æ Œã®åŒ·åã§æè»æ§ãããã管çãããããä¿¡é Œæ§ã®é«ããµãŒããŒãå®çŸããŸããLenovo ThinkSystem SR650ãäžçã§æã売ããŠããLenovoãµãŒãââãŒã«ããã®ã¯ããã®å質ã®çµã¿åããã§ããLenovo ThinkSystem SR650ãµãŒããŒã®ãªã¯ãšã¹ããæ®ãã«ã¯ããªã³ã¯ããã©ã£ãŠ ãã ããã