æ¬æ¥ã¯ãUnity XT ã¹ãã¬ãŒãž ã·ã¹ãã 㧠SQL Server 2019 ã䜿çšããæ©èœã玹ä»ããVMware ãã¯ãããžã䜿çšãã SQL Server ã®ä»®æ³åãDell EMC ã€ã³ãã©ã¹ãã©ã¯ãã£ã®åºæ¬ã³ã³ããŒãã³ãã®ã»ããã¢ãããšç®¡çã«é¢ããæšå¥šäºé ã玹ä»ããŸãã
2017 幎ãDell EMC ãš VMware ã¯ãSQL Server ã®ãã¬ã³ããšé²åã«é¢ãã調æ»çµæãSQL Server Transformation: Towards Agility and Resilienceã(
ãã®èª¿æ»ã®å®æœä»¥æ¥ãMicrosoft ã¯æ¬¡äžä»£ DBMS - SQL Server 2019 ããªãªãŒã¹ããŸããããªã¬ãŒã·ã§ãã« ãšã³ãžã³ãšããŒã¿ ã¹ãã¬ãŒãžã®åºæ¬æ©èœã®åäžã«å ããæ°ãããµãŒãã¹ãšæ©èœãç»å ŽããŸããã ããšãã°ãSQL Server 2019 ã«ã¯ãApache Spark ãš Hadoop åæ£ãã¡ã€ã« ã·ã¹ãã (HDFS) ã䜿çšããããã° ããŒã¿ ã¯ãŒã¯ããŒãã®ãµããŒããå«ãŸããŠããŸãã
Dell EMC ãšãã€ã¯ããœããã®ã¢ã©ã€ã¢ã³ã¹
Dell EMC ãš Microsoft ã¯ãSQL Server ã®ãœãªã¥ãŒã·ã§ã³ã®éçºã«ãããŠé·å¹Žååé¢ä¿ã«ãããŸãã Microsoft SQL Server ãªã©ã®å æ¬çãªããŒã¿ããŒã¹ ãã©ãããã©ãŒã ãé©åã«å®è£ ããã«ã¯ããœãããŠã§ã¢ã®æ©èœãšåºç€ãšãªã IT ã€ã³ãã©ã¹ãã©ã¯ãã£ã調æŽããå¿ èŠããããŸãã ãã®ã€ã³ãã©ã¹ãã©ã¯ãã£ã«ã¯ãããã»ããµã®åŠçèœåãã¡ã¢ãª ãªãœãŒã¹ãã¹ãã¬ãŒãžããããã¯ãŒã¯ ãµãŒãã¹ãå«ãŸããŸãã Dell EMC ã¯ãããããçš®é¡ã®ã¯ãŒã¯ããŒããšã¢ããªã±ãŒã·ã§ã³ã« SQL Server ãã©ãããã©ãŒã ã€ã³ãã©ã¹ãã©ã¯ãã£ãæäŸããŸãã
Dell EMC PowerEdge ãµãŒã㌠ã©ã€ã³ã§ã¯ãããŸããŸãªããã»ããµãšã¡ã¢ãªæ§æãæäŸãããŠããŸãã ãããã®æ§æã¯ãå°èŠæš¡ãšã³ã¿ãŒãã©ã€ãº ã¢ããªã±ãŒã·ã§ã³ããããšã³ã¿ãŒãã©ã€ãº ãªãœãŒã¹ ãã©ã³ãã³ã° (ERP)ãããŒã¿ ãŠã§ã¢ããŠã¹ãé«åºŠãªåæãé»ååååŒãªã©ã®å€§èŠæš¡ãªããã·ã§ã³ ã¯ãªãã£ã«ã« ã·ã¹ãã ã«è³ããŸã§ãå¹ åºãã¯ãŒã¯ããŒãã«é©ããŠããŸããã¹ãã¬ãŒãž ã©ã€ã³ã¯ã次ã®ããã«èšèšãããŠããŸããéæ§é åããŒã¿ãšæ§é åããŒã¿ãä¿åããŸãã
Dell EMC ã€ã³ãã©ã¹ãã©ã¯ãã£ã§ SQL Server 2019 ãå±éããã客æ§ã¯ãSQL Server ãš Apache Spark ã䜿çšããŠæ§é åããŒã¿ãšéæ§é åããŒã¿ãæäœã§ããŸãã SQL Server ã¯ãã¯ã©ã€ã¢ã³ã ã¢ã¯ã»ã¹ããµãŒããŒéãããã³ãµãŒããŒãšã¹ãã¬ãŒãžéã®éä¿¡ãã¯ãããžã®çµã¿åããããµããŒãããŠããŸãã Dell EMC ã®ããžã§ã³ã¯ããªãŒãã³ ãšã³ã·ã¹ãã ãæäŸããåæ£ã¢ãã«ã«åºã¥ããŠããŸãã çµç¹ã¯ãå¹ åºãæ¥çæšæºã®ãããã¯ãŒãã³ã° ã¢ããªã±ãŒã·ã§ã³ããªãã¬ãŒãã£ã³ã° ã·ã¹ãã ãããŒããŠã§ã¢ ãã©ãããã©ãŒã ããéžæã§ããŸãã ãã®ã¢ãããŒãã«ããããã¯ãããžãŒãšã¢ãŒããã¯ãã£ãæ倧éã«å¶åŸ¡ã§ããããã«ãªããå€§å¹ ãªã³ã¹ãåæžãšæè»æ§ãå®çŸããŸãã
VMware ã¯ãSQL Server ãé«ãããã©ãŒãã³ã¹ãšéçšã®äžè²«æ§ãå®çŸããããã«å¿ èŠãªãã¹ãŠã®éèŠãªã€ã³ãã©ã¹ãã©ã¯ã㣠ã³ã³ããŒãã³ããä»®æ³åããŸãã VMware ã¯çŸåšããã©ã€ããŒã ã¯ã©ãŠãã«å ããŠããã©ã€ããŒã ã¯ã©ãŠã ã¢ãŒããã¯ãã£ãšãããªã㯠ã¯ã©ãŠã ã¢ãŒããã¯ãã£ã«ãããã¯ãŒã¯ããŒãã®ãã€ããªãã ã¢ãã«ãæäŸããŠããŸãã
å€ãã®çµç¹ã¯ãã€ã³ãã©ã¹ãã©ã¯ãã£ã®ã³ã¹ããåæžããé«å¯çšæ§ãæäŸããçœå®³åŸ©æ§ãç°¡çŽ åããããã«ä»®æ³åã«æ³šç®ããŠããŸãã 調æ»å¯Ÿè±¡ãšãªã£ã SQL Server å°é家㮠94% ããèªåã®ç°å¢ã«ããçšåºŠã®ä»®æ³åãååšãããšå ±åããŠããŸãã ä»®æ³åã䜿çšããŠãããŠãŒã¶ãŒã® 70% ã VMware ãéžæããŸããã 60% ã 75% 以äžã® SQL Server ä»®æ³åã¬ãã«ãæã£ãŠããŸãã ããã«ã調æ»çµæã¯ãä»®æ³åå±€ã§å®è£ ãããé«å¯çšæ§ãšãã£ã¶ã¹ã¿ãŒ ãªã«ããªãŒããSQL Server ããŒã¿ããŒã¹ãä»®æ³åãã決å®ã«ãããéèŠãªèŠçŽ ãšãªã£ãããšã匷ã瀺åããŠããŸãã
SQL Server 2019 ã®æ°æ©èœ
SQL Server 2019 ããŒã¿ããŒã¹ ãã©ãããã©ãŒã ã«ã¯ãåæããšã³ã¿ãŒãã©ã€ãº ããŒã¿ããŒã¹ãããžãã¹ ã€ã³ããªãžã§ã³ã¹ (BI)ãã¹ã±ãŒã©ãã« ãã©ã³ã¶ã¯ã·ã§ã³åŠç (OLTP) ãªã©ã®ããã·ã§ã³ ã¯ãªãã£ã«ã«ãªã¢ããªã±ãŒã·ã§ã³ããµããŒãããå¹ åºããã¯ãããžãæ©èœããµãŒãã¹ãå«ãŸããŠããŸãã SQL Server ãã©ãããã©ãŒã ã¯ãããŒã¿çµ±åãããŒã¿ ãŠã§ã¢ããŠãžã³ã°ãã¬ããŒãäœæãšé«åºŠãªåæãã¬ããªã±ãŒã·ã§ã³æ©èœãåæ§é åããŒã¿åã®ç®¡çã管çããæ©èœãç²åŸããŸããã ãã¡ããããã¹ãŠã®ã¯ã©ã€ã¢ã³ããã¢ããªã±ãŒã·ã§ã³ããããã®æ©èœããã¹ãŠå¿ èŠãšããããã§ã¯ãããŸããã ããã«ãå€ãã®å Žåãä»®æ³åã䜿çšã㊠SQL Server ãµãŒãã¹ãåé¢ããããšãæšå¥šãããŸãã
ä»æ¥ãäŒæ¥ã¯å€ãã®å Žåãå¢ãç¶ããå¹
åºãããŒã¿ã»ããããã®å€§éã®ããŒã¿ã«äŸåããå¿
èŠããããŸãã SQL Server 2019 ã䜿çšãããšããã¹ãŠã®ããŒã¿ããã»ãŒãªã¢ã«ã¿ã€ã ã®æŽå¯ãåŸãããšãã§ããŸãã SQL Server 2019 ã¯ã©ã¹ã¿ãŒã¯ãæ©æ¢°åŠç¿ã人工ç¥èœæ©èœã®äœ¿çšãå«ãã倧èŠæš¡ãªããŒã¿ ã»ãããæäœããããã®æ¬æ Œçãªç°å¢ãæäŸããŸãã SQL Server 2019 ã®äž»ãªæ°æ©èœãšæŽæ°ã¯ã次ã®ãšããã§ãã
Dell EMC Unity XT ãããã¬ã³ãž ã¹ãã¬ãŒãž ã·ã¹ãã
Dell EMC Unity ã¹ãã¬ãŒãž ã·ãªãŒãºã¯çŽ 40 幎åã«çºå£²ãããããä»¥æ¥ 000 å°ãè¶ ããã·ã¹ãã ã販売ãããŠããŸãã ãã®ãããã¬ã³ãž ã¢ã¬ã€ã¯ããã®ã·ã³ãã«ããããã©ãŒãã³ã¹ãã³ã¹ãå¹çã®é«ãã§é¡§å®¢ã«é«ãè©äŸ¡ãããŠããŸãã Dell EMC Unity XT ãããã¬ã³ãž ãã©ãããã©ãŒã ã¯ãSQL Server ã¯ãŒã¯ããŒãã«å¯ŸããŠäœé 延ãé«ã¹ã«ãŒããããäœç®¡çãªãŒããŒããããå®çŸããå ±æã¹ãã¬ãŒãž ãœãªã¥ãŒã·ã§ã³ã§ãã ãã¹ãŠã® Unity XT ã·ã¹ãã ã¯ããã¥ã¢ã« ã¹ãã¬ãŒãž ããã»ããµ (SP) ã¢ãŒããã¯ãã£ã䜿çšããŠãI/O ããã³ã¢ã¯ãã£ã/ã¢ã¯ãã£ã ããŒã¿æäœãåŠçããŸãã Unity XT ãã¥ã¢ã« SP ã¯ãå®å šãªå éš 12Gbps SAS æ¥ç¶ãšç¬èªã®ãã«ãã³ã¢ ã¢ãŒããã¯ãã£ã䜿çšããŠãé«ãããã©ãŒãã³ã¹ãšå¹çãå®çŸããŸãã ãã£ã¹ã¯ ã¢ã¬ã€ã䜿çšãããšãè¿œå ã®ã·ã§ã«ãã䜿çšããŠã¹ãã¬ãŒãžå®¹éãæ¡åŒµã§ããŸãã
次äžä»£ã¢ã¬ã€ïŒãã€ããªããããã³ãªãŒã«ãã©ãã·ã¥ïŒã§ãã Dell EMC Unity XT ã¯ãããã©ãŒãã³ã¹ã倧å¹
ã«åäžãããå¹çãåäžããããã«ãã¯ã©ãŠãç°å¢åãã®æ°ããæ©èœãšãµãŒãã¹ãè¿œå ããŸãã
Unity XT ã¢ãŒããã¯ãã£ã䜿çšãããšãã¢ããªã±ãŒã·ã§ã³ã®ããã©ãŒãã³ã¹ãç ç²ã«ããããšãªããããŒã¿ã®åŠçãããŒã¿éã®åæžãã¬ããªã±ãŒã·ã§ã³ãªã©ã®ãµãŒãã¹ã®ãµããŒããåæã«è¡ãããšãã§ããŸãã åäžä»£ã®ãœãªã¥ãŒã·ã§ã³ãšæ¯èŒããŠãDell EMC Unity XT ã¹ãã¬ãŒãž ã·ã¹ãã ã®ããã©ãŒãã³ã¹ã¯ 75 åã«ãªããå¿çæé㯠XNUMX% éããªããŸãã ãããŠãã¡ãããDell EMC Unity 㯠NVMe æšæºããµããŒãããŸãã
NVMe ãã©ã€ããåããã¹ãã¬ãŒãž ã·ã¹ãã ã¯ãé 延ã®åœ±é¿ãåããããã¢ããªã±ãŒã·ã§ã³ã§æé«ã®ããã©ãŒãã³ã¹ãçºæ®ããŸãã ããšãã°ã倧èŠæš¡ããŒã¿ããŒã¹ãªã©ã®ã¢ããªã±ãŒã·ã§ã³ã§ã¯ãNVMe ã¯äœé 延ãšé«ãããŒã¯ ããŒã¿ ã¬ãŒããæäŸããŸãã ã¬ã€ãã³ã·ã®ççž®ãšåæå®è¡æ§ã®åäžã«ãããèªã¿åã/æžã蟌ã¿ããã©ãŒãã³ã¹ãå€§å¹ ã«åäžããŸãã IDC ã®äºæž¬ã«ããã°ã2021 幎ãŸã§ã« NVMe ããã³ NVMe-oF (NVMe over Fabric) æ¥ç¶ãåãããã©ãã·ã¥ ã¢ã¬ã€ããäžçäžã®å€éšã¹ãã¬ãŒãž ã·ã¹ãã ã®å£²äžé«ã®çŽååãå ããããã«ãªããšããã®ã¯å¶ç¶ã§ã¯ãããŸããã
ããŒã¿å§çž®ã¢ã«ãŽãªãºã ã«ãããã¹ãã¬ãŒãžå¹çãåäžããŸãã Dell EMC Unity XT ã¯ãããŒã¿éãæ倧 85 åã® XNUMX ã«åæžã§ããŸãã ãã XNUMX ã€ã®éèŠãªææšã¯ãã·ã¹ãã ã®å šäœçãªå¹çã§ãã Dell EMC Unity XT ã¯ãã·ã¹ãã 容éã® XNUMX% ã䜿çšããŸãã å§çž®ãšéè€æé€ã¯ã€ã³ã©ã€ã³ ã¢ãŒããã€ãŸãã³ã³ãããŒã©ãŒ ã¬ãã«ã§å®è¡ãããŸãã ããŒã¿ã¯å§çž®åœ¢åŒã§ä¿åãããŸãã ãã®ã·ã¹ãã ã¯ãããŒã¿ ã¹ãããã·ã§ããã®äœæ¥ãèªååããŸãã
çµ±åããã (ãããã¯ãšãã¡ã€ã«) ã¢ã¯ã»ã¹ãåãã䜿ãããã Unity ãã©ãã·ã¥ ã¢ã¬ã€ã¯ãå®å®ããå¿çæéãæäŸããã¯ã©ãŠã ã¹ãã¬ãŒãž ãµãŒãã¹ãšçµ±åããããŒã¿ç§»è¡ãªãã§ã¢ããã°ã¬ãŒãããµããŒãããŸãã ãã®å€çšéã¹ãã¬ãŒãž ã·ã¹ãã ã¯ãåºæ¬æ§æã§ã¯ 30 åã§èšçœ®ã§ããŸãã
ãåçããŒã«ããšåŒã°ããããŒã¿ ã¹ãã¬ãŒãž ãã¯ãããžã«ãããéçã¡ã¢ãªæ¡åŒµããåçã¡ã¢ãªæ¡åŒµãžã®ç§»è¡ãå¯èœã«ãªããéçšäžã®æè»æ§ãé«ããã·ã¹ãã 容éãç°¡åã«æ¡åŒµã§ããŸãã åçããŒã«ã¯å®¹éãšäºç®ãç¯çŽããåæ§ç¯ã«å¿ èŠãªæéãççž®ããŸãã Dell EMC Unity ã®å®¹éãšããã©ãŒãã³ã¹ãæ¡åŒµããã«ã¯ãããŒã¿ã®ç§»è¡ã¯å¿ èŠãããŸããã
çŸåšãå€ãã®äŒæ¥ãè€æ°ã®ãããªã㯠ã¯ã©ãŠã ãµãŒãã¹ããªã³ãã¬ãã¹ ã€ã³ãã©ã¹ãã©ã¯ãã£ãšçµã¿åãããŠäœ¿çšââããŠããŸãã Dell EMC Unity XT ã¯ãDell Technologies ã¯ã©ãŠãç°å¢ã®ã³ã³ããŒãã³ããšããŠæ©èœã§ããŸãã ãã®ã¹ãã¬ãŒãž ã·ã¹ãã ã¯ãããªã㯠ã¯ã©ãŠãã§äœ¿çšã§ããããŒã¿ã¯ãã©ã€ããŒã ã¯ã©ãŠãã«è»¢éã§ããŸãã ããã«ãDell EMC Unity XT ã¹ãã¬ãŒãžããµãŒãã¹ãšããŠå©çšã§ããŸãã ããã¯ãDell EMC ã¯ã©ãŠã ã¹ãã¬ãŒãž ãµãŒãã¹ã®ã¯ã©ãŠã ã¹ãã¬ãŒãž ãµãŒãã¹ã® XNUMX ã€ã§ãã
ã¯ã©ãŠã ã¹ãã¬ãŒãžã¯ãã€ã³ãã©ã¹ãã©ã¯ãã£ã®ã³ã¹ããåæžã㊠ROI ãåäžã§ããããããŸããŸã人æ°ãé«ãŸã£ãŠããŸãã ã¯ã©ãŠã ã¹ãã¬ãŒãž ãµãŒãã¹ã¯ãDell EMC ã¹ãã¬ãŒãžïŒãããªã㯠ã¯ã©ãŠã ãªãœãŒã¹ã«çŽæ¥æ¥ç¶ïŒããµãŒãã¹ãšããŠæäŸããããšã§ã顧客ã®ããŒã¿ ã»ã³ã¿ãŒãã¯ã©ãŠãã«æ¡åŒµããŸãã ãµãŒãããŒã㣠ãããã€ããŒã¯ã顧客ã®ããŒã¿ ã»ã³ã¿ãŒå
ã® Dell EMC UnityãPowerMaxãããã³ Isilon ã·ã¹ãã ã«é«é (äœé
延) ãããªã㯠ã¯ã©ãŠãæ¥ç¶ãçŽæ¥æäŸã§ããŸãã
Unity XT ãã¡ããªã«ã¯ãUnity XT ãªãŒã«ãã©ãã·ã¥ãUnity XT ãã€ããªãããUnityVSAãããã³ Unity Cloud Edition ã·ã¹ãã ãå«ãŸããŸãã
çµ±åããããã€ããªããããã³ãã©ãã·ã¥ ã¢ã¬ã€
Intel ããŒã¹ã® Unity XT ãã€ããªããããã³ Unity XT ãªãŒã«ãã©ãã·ã¥ ã¹ãã¬ãŒãž ã·ã¹ãã ã¯ãããã㯠ã¢ã¯ã»ã¹ããã¡ã€ã« ã¢ã¯ã»ã¹ãããã³ãããã¯ãŒã¯æ¥ç¶ã¹ãã¬ãŒãž (NAS)ãiSCSIãããã³ãã¡ã€ã㌠ãã£ãã« (FC) ãããã³ã«ããµããŒããã VMware VVol ã®ããã®çµ±åã¢ãŒããã¯ãã£ãæäŸããŸãã Unity XT Hybrid ããã³ Unity XT ãªãŒã«ãã©ãã·ã¥ ãã©ãããã©ãŒã 㯠NVMe 察å¿ã§ãã
Unity XT ãã€ããªãã ã·ã¹ãã ã¯ããã«ãã¯ã©ãŠãç°å¢ããµããŒãããŸãã ãã«ãã¯ã©ãŠããšã¯ãã¹ãã¬ãŒãžãã¯ã©ãŠãã«æ¡åŒµããããšããŸãã¯æè»ãªãªãœãŒã¹å©çšãªãã·ã§ã³ãåããã¯ã©ãŠãã«å±éããããšãæå³ããŸãã ãã«ãã¯ã©ãŠã ã¹ãã¬ãŒãžã¯ããã©ã€ããŒããšãããªãã¯ã®è€æ°ã®ã¯ã©ãŠã ãã©ãããã©ãŒã éã§ã®ã¢ããªãã£ãšããŒã¿ã®ããŒã¿ããªãã£ã確ä¿ããããã«èšèšãããŠããŸãã ããã¯ãããŒã¿ç§»åã®ããã»ã¹ã ãã§ãªããããã€ãã®ãããªã㯠ã¯ã©ãŠãå ã®ããŒã¿ãžã®ã¢ããªã±ãŒã·ã§ã³ ã¢ã¯ã»ã¹ã®æ§æã«ã圱é¿ããŸãã
ãããã®ãã€ããªãã ã¢ã¬ã€ã¯æ¬¡ã®æ©èœãæäŸããŸãã
- 16 PB ã®ç容éãŸã§æ¡åŒµå¯èœã
- ãã¹ãŠã®ãã©ãã·ã¥ ããŒã«ã«çµã¿èŸŒãŸããããŒã¿åæžæ©èœã
- ã€ã³ã¹ããŒã«ãšæ§æã¯è¿ éã§ã (å¹³å㧠25 åããããŸã)ã
SSD ãã¯ãããžãŒã¯æ¥éã«é²æ©ããŠãããä»åŸæ°å¹Žéã§æ°ããé©æ°çãªè£œåãåžå Žã«æå ¥ãããã§ãããã ãããŸã§ã®éãçµç¹ã¯ããã©ãŒãã³ã¹ã®åäžã管çã®å®¹æãããšãã«ã®ãŒç¯çŽãç®çãšããŠãåŸæ¥ã® HDD ã SSD ã«çœ®ãæãç¶ããã§ãããã æ°äžä»£ã®ãªãŒã«ãã©ãã·ã¥ ã¢ã¬ã€ã¯ãããé«åºŠãªã¹ãã¬ãŒãžèªååããããªã㯠ã¯ã©ãŠãçµ±åãçµ±åããŒã¿ä¿è·ãåããŠããŸãã
Unity XT ãªãŒã«ãã©ãã·ã¥ ã·ã¹ãã ã¯ãé床ãå¹çããã«ãã¯ã©ãŠã ãµããŒããæäŸããŸãã 圌ãã®ç¹åŸŽ:
- çç£æ§ã XNUMX åã«ãªããŸãã
- æ倧 7:1 ãŸã§ã®ããŒã¿åæžã
- è¿ éãªã€ã³ã¹ããŒã«ãšæ§æ (ããã»ã¹ã«ãããæé㯠30 åæªæº)ã
UnityVSA
UnityVSA ã¯ããµãŒããŒãå ±æããŸãã¯ã¯ã©ãŠã ã¹ãã¬ãŒãžå®¹éã䜿çšãããVMware ESXi ä»®æ³ç°å¢çšã®ãœãããŠã§ã¢ ããã¡ã€ã³ã ã¹ãã¬ãŒãžã§ãã UnityVSA HA ã¯ããã¥ã¢ã« ã¹ãã¬ãŒãž UnityVSA æ§æã§ãããè¿œå ã®ãã©ãŒã«ã ãã¬ã©ã³ã¹ãæäŸããŸãã UnityVSA ã¹ãã¬ãŒãžã¯ä»¥äžãæäŸããŸãã
- æ倧 50 TB ã®ãã«æ©èœã®çµ±åã¹ãã¬ãŒãžå®¹éã
- Unity XT ã·ã¹ãã ããã³æ©èœãšäºææ§ããããŸãã
- é«å¯çšæ§ã·ã¹ãã (UnityVSA HA) ã®ãµããŒãã
- NASããã³iSCSIãšããŠæ¥ç¶ããŸãã
- ä»ã® Unity XT ãã©ãããã©ãŒã ããã®ããŒã¿ã®ã¬ããªã±ãŒã·ã§ã³ã
Unityã¯ã©ãŠãç
ã¯ã©ãŠãã䜿çšãããã¡ã€ã«åæãšçœå®³åŸ©æ§æäœã®ããã«ãUnity XT ãã¡ããªã«ã¯ä»¥äžãæäŸãã Unity Cloud Edition ãå«ãŸããŠããŸãã
- ã¯ã©ãŠãã«å±éããããœãããŠã§ã¢ ããã¡ã€ã³ã ã¹ãã¬ãŒãž (SDS) ã䜿çšããããã«æ©èœã®ã¹ãã¬ãŒãžæ©èœã
- VMware Cloud on AWS ã䜿çšãããšãããã㯠ã¹ãã¬ãŒãžãšãã¡ã€ã« ã¹ãã¬ãŒãžãç°¡åã«ãããã€ã§ããŸãã
- ãã¹ããããŒã¿åæãå«ãçœå®³åŸ©æ§ãµããŒãã
SQL Server çš Unity XT ãªãŒã« ãã©ãã·ã¥
Unisphere Research ã® 2017 幎ã¬ããŒããSQL Server ã®å€é©: ä¿ææ§ãšå埩åã«åããŠã(
SQL Server ã§äœ¿çšãããã©ãã·ã¥ ã¹ãã¬ãŒãžã®æ¥éãªå°å ¥ã¯ãUnity XT ãªãŒã«ãã©ãã·ã¥ ã¢ã¬ã€ã SQL Server ã®éçºè ã管çè ã«ç¹ã«é©ããŠããããšãæå³ããŸãã Unity XT ãªãŒã«ãã©ãã·ã¥ ã·ã¹ãã ã¯ãSQL Server éçºè ãšç®¡çè ã«ãäžè¬çãªã¹ãã¬ãŒãž ãšãªã¢ ãããã¯ãŒã¯ (SAN) ãæäŸãããã®ãè¶ ããæ©èœãšããã©ãŒãã³ã¹ãæäŸããŸãã
Unity XT ãªãŒã«ãã©ãã·ã¥ ã·ã¹ãã ã¯ãNVMe å¯Ÿå¿ (ããã«é«ãããã©ãŒãã³ã¹ãšäœé
延ãå®çŸ) ã§ã2U ãã©ãŒã ãã¡ã¯ã¿ãåãããã¥ã¢ã«ã³ã¢ ããã»ããµãã¢ã¯ãã£ã/ã¢ã¯ãã£ã ã¢ãŒãã® XNUMX ã€ã®ã³ã³ãããŒã©ããµããŒãããŸãã
Unity XT ãªãŒã«ãã©ãã·ã¥ ã¢ãã«
ãŠããã£XT
ããã»ããµãŒ
ã¡ã¢ãª (ããã»ããµããš)
æ倧ã ãã©ã€ãã®æ°
æ倧ã ãçã容é (PB)
380F
1 ã€ã³ãã« E5-2603 v4
6c/1.7GHz
64
500
2.4
480F
2 ã€ã³ãã« Xeon ã·ã«ããŒ
4108 8c/1.8GHz
96
750
4.0
680F
2 ã€ã³ãã« Xeon ã·ã«ããŒ
4116 12c/2.1GHz
192
1,000
8.0
880F
2 ã€ã³ãã« Xeon ãŽãŒã«ã 6130
16c/2.1GHz
384
1,500
16.0
詳现ã«ã€ããŠã¯ãé
åã®ä»æ§ (
ã¹ãã¬ãŒãžããŒã«
å€ãã® SQL Server å°é家ã¯ãææ°ã®ã¹ãã¬ãŒãž ã¢ã¬ã€ã¯ãã¹ãŠãåºå®ã¬ãã«ã® RAID ä¿è·ãåãããã倧ããªã¹ãã¬ãŒãž ãŠãããã«ãã£ã¹ã¯ãã°ã«ãŒãåããæ©èœãåããŠããããšãç¥ã£ãŠããŸãã RAID ä¿è·ãåããåã ã®ãã£ã¹ã¯ ã°ã«ãŒãã¯ãåŸæ¥ã®ã¹ãã¬ãŒãž ããŒã«ã§ãã Unity XT ãã€ããªãã ã·ã¹ãã ã¯åŸæ¥ã®ããŒã«ã®ã¿ããµããŒãããŸãããUnity XT ãªãŒã«ãã©ãã·ã¥ ã¢ã¬ã€ã¯åçã¹ãã¬ãŒãž ããŒã«ãæäŸããŸãã åçã¹ãã¬ãŒãž ããŒã«ã䜿çšãããšãRAID ä¿è·ã¯ãã£ã¹ã¯ ãšã¯ã¹ãã³ã (ãã£ã¹ã¯å šäœããå°ããã¹ãã¬ãŒãžåäœ) ã«é©çšãããŸãã åçããŒã«ã«ããããã£ã¹ã¯ ããŒã«ã®ç®¡çãšæ¡åŒµãããæè»ã«ãªããŸãã
Dell EMC ã¯ãæå°éã®è€éãã§æ倧ã®ããã©ãŒãã³ã¹ãå®çŸããã¹ãã¬ãŒãž ããŒã«ç®¡çã®ãã¹ã ãã©ã¯ãã£ã¹ãæäŸããŸãã ããšãã°ãè€éãã軜æžããæè»æ§ãé«ããããã«ãUnity XT ã¹ãã¬ãŒãž ããŒã«ã®æ°ãæå°éã«æããããšããå§ãããŸãã ãã ããè¿œå ã®ã¹ãã¬ãŒãž ããŒã«ã®ã»ããã¢ããã¯ã次ã®ãããªå Žåã«éåžžã«äŸ¿å©ã§ãã
- ç°ãªã I/O ãããã¡ã€ã«ã䜿çšããåå¥ã®ã¯ãŒã¯ããŒãããµããŒãããŸãã
- ç¹å®ã®ããã©ãŒãã³ã¹ ãã©ã¡ãŒã¿ãéæããããã«ãªãœãŒã¹ãå²ãåœãŠãŸãã
- ãã«ãããã³ãå°çšã®å¥ã®ãªãœãŒã¹ãçšæããŸãã
- é害ããä¿è·ããããã«å°ããªãã¡ã€ã³ãäœæãã
ã¹ãã¬ãŒãžããªã¥ãŒã ïŒLUNïŒ
ã¢ã¬ã€å ã®ããªã¥ãŒã ã®æ°ãéžæãããšãã«ãå¶åŸ¡ãšæè»æ§ã®ãã©ã³ã¹ãã©ã®ããã«ãšããŸãã? Unity ãš SQL Server ã®æè»æ§ãæ倧éã«é«ããã«ã¯ãããŒã¿ããŒã¹ ãã¡ã€ã«ããšã«ããªã¥ãŒã ãäœæããããšããå§ãããŸãã å®éã«ã¯ãã»ãšãã©ã®çµç¹ã¯éå±€åã¢ãããŒãã䜿çšããŠãããéèŠãªããŒã¿ããŒã¹ã«ã¯æ倧éã®æè»æ§ãäžããããéèŠæ§ã®äœãããŒã¿ããŒã¹ ãã¡ã€ã«ã¯å°æ°ã®å€§ããªããªã¥ãŒã ã«ã°ã«ãŒãåãããŸãã ããŒã¿ä¿è·ãšç£èŠãã¯ãããžãŒã¯ãã¡ã€ã«ã®åé¢ãšé 眮ã«äŸåããŠãããããããŒã¿ããŒã¹ãšé¢é£ã¢ããªã±ãŒã·ã§ã³ã®ãã¹ãŠã®èŠä»¶ã確èªããããšããå§ãããŸãã
è€æ°ã®ããªã¥ãŒã ã¯ãç¹ã«ä»®æ³ç°å¢ã§ã¯ç®¡çãé£ããå ŽåããããŸãã ä»®æ³åããã SQL Server ç°å¢ã¯ãåäžããªã¥ãŒã äžã§è€æ°ã®ãã¡ã€ã« ã¿ã€ãããã¹ãããããšãåççã§ãã奜äŸã§ãã ããŒã¿ããŒã¹ç®¡çè ãŸãã¯ã¹ãã¬ãŒãžç®¡çè (ãããã¯ãã®äž¡æ¹) ã¯ãäœæããããªã¥ãŒã ã®æ°ã決å®ããéã«ãæè»æ§ãšä¿å®æ§ã®éã®é©åãªãã©ã³ã¹ãéžæããå¿ èŠããããŸãã
ãã¡ã€ã«ã¹ãã¬ãŒãž
NAS ãµãŒããŒã¯ãUnity XT ã¹ãã¬ãŒãžäžã®ãã¡ã€ã« ã·ã¹ãã ããã¹ãããŸãã ãã¡ã€ã« ã·ã¹ãã ã«ã¯ SMB ãŸã㯠NFS ãããã³ã«ã䜿çšããŠã¢ã¯ã»ã¹ã§ãããã«ããããã³ã« ãã¡ã€ã« ã·ã¹ãã ã§ã¯äž¡æ¹ã®ãããã³ã«ãåæã«äœ¿çšã§ããŸãã NAS ãµãŒããŒã¯ãä»®æ³ã€ã³ã¿ãŒãã§ã€ã¹ã䜿çšããŠããã¹ãã SMBãNFSãããã³ãã«ããããã³ã« ãã¡ã€ã« ã·ã¹ãã ã«å ããŠãVMware NFS ã¹ãã¬ãŒãžã VMware ä»®æ³ããªã¥ãŒã ã«æ¥ç¶ããŸãã ãã¡ã€ã« ã·ã¹ãã ãšä»®æ³ã€ã³ã¿ãŒãã§ã€ã¹ã¯åäžã® NAS ãµãŒããŒå ã§åé¢ãããŠãããããè€æ°ã® NAS ãµãŒããŒããã«ãããã³ãã«äœ¿çšã§ããŸãã ã¹ãã¬ãŒãž ããã»ããµã«é害ãçºçããå ŽåãNAS ãµãŒããŒã¯èªåçã«ãã§ã€ã«ãªãŒããŒããŸãã é¢é£ãããã¡ã€ã« ã·ã¹ãã ããã§ã€ã«ãªãŒããŒããŸãã
SQL Server 2012 (11.x) 以éã®ããŒãžã§ã³ã§ã¯ãã¹ãã¬ãŒãžçšã®ãããã¯ãŒã¯ ãã¡ã€ã«å ±æãå¯èœã«ãããµãŒã㌠ã¡ãã»ãŒãž ããã㯠(SMB) 3.0 ããµããŒããããŠããŸãã ã¹ã¿ã³ãã¢ãã³ ã¯ã©ã¹ã¿ãŒ ã€ã³ã¹ããŒã«ãšãã§ãŒã«ãªãŒã㌠ã¯ã©ã¹ã¿ãŒ ã€ã³ã¹ããŒã«ã®äž¡æ¹ã§ãSMB ã¹ãã¬ãŒãž ãªãã·ã§ã³ã䜿çšããŠã·ã¹ãã ããŒã¿ããŒã¹ (ãã¹ã¿ãŒãã¢ãã«ãmsdbãããã³ tempdb) ãšããŒã¿ããŒã¹ ãšã³ãžã³ ãŠãŒã¶ãŒ ããŒã¿ããŒã¹ãã€ã³ã¹ããŒã«ã§ããŸãã ãã¡ã€ã«å ±æã«ã¯å¯çšæ§ã®é«ããããã¯ãŒã¯ ãªãœãŒã¹ãžã®ã¢ã¯ã»ã¹ãå¿ èŠã§ãããããAlways On å¯çšæ§ã°ã«ãŒãã䜿çšããå Žåã¯ãSMB ã¹ãã¬ãŒãžã䜿çšããã®ãè¯ãéžæè¢ã§ãã
Unity XT ã¹ãã¬ãŒãžã䜿çšãã SQL Server å±éçšã® SMB ãã¡ã€ã«å
±æã®äœæã¯ãNAS ãµãŒããŒããã¡ã€ã« ã·ã¹ãã ãSMB å
±æãäœæãããšããåçŽãª XNUMX ã¹ãããã®ããã»ã¹ã§ãã Dell EMC Unisphere Storage Management ãœãããŠã§ã¢ã«ã¯ããã®ããã»ã¹ãå®äºããã®ã«åœ¹ç«ã€æ§æãŠã£ã¶ãŒããå«ãŸããŠããŸãã ãã ããSMB ãã¡ã€ã«å
±æ㧠SQL Server ã¯ãŒã¯ããŒãããã¹ãããå Žåã¯ãSMB ãã¡ã€ã«å
±æã®äœ¿çšã«å¿
ãããé©çšãããããã§ã¯ãªããçæãã¹ãéèŠãªèæ
®äºé
ãããã€ããããŸãã Microsoft ã¯ãã€ã³ã¹ããŒã«ããã³ã»ãã¥ãªãã£ã®åé¡ãšçŸåšæ¢ç¥ã®åé¡ã®ãªã¹ããäœæããŸããã 詳现ã«ã€ããŠã¯ããSMB ãã¡ã€ã« ã¹ãã¬ãŒãžã䜿çšãã SQL Server ã®ã€ã³ã¹ããŒã«ããåç
§ããŠãã ããã
ããŒã¿ã®ã¹ãããã·ã§ãã
ããŒã¿ã¯äŒæ¥ã«ãšã£ãŠæãéèŠãªãªãœãŒã¹ãšãªã£ãŠãããä»æ¥ã®ããã·ã§ã³ã¯ãªãã£ã«ã«ãªç°å¢ã«ã¯åãªãåé·æ§ä»¥äžã®ãã®ãå¿ èŠã§ãã ã¢ããªã±ãŒã·ã§ã³ã¯åžžã«ãªã³ã©ã€ã³ã§ãããäžæã®ãªãæäœãšæŽæ°ãæäŸãããå¿ èŠããããŸãã ãŸããããŒã«ã« ã¹ãããã·ã§ãã ã¬ããªã±ãŒã·ã§ã³ããªã¢ãŒã ã¬ããªã±ãŒã·ã§ã³ãªã©ã®ãªãã·ã§ã³ã䜿çšãããé«ãããã©ãŒãã³ã¹ãšããŒã¿å¯çšæ§ãå¿ èŠã§ãã
Unity XT ã¹ãã¬ãŒãž ã¢ã¬ã€ã¯ãå ±éã®ã¯ãŒã¯ãããŒãæäœãã¢ãŒããã¯ãã£ãå ±æããããã㯠ã¹ãããã·ã§ããæ©èœãšãã¡ã€ã« ã¹ãããã·ã§ããæ©èœãæäŸããŸãã Unity ã®ã¹ãããã·ã§ããææ³ã¯ãããŒã¿ãä¿è·ããããã®ã·ã³ãã«ãã€å¹æçãªæ¹æ³ãæäŸããŸãã ã¹ãããã·ã§ããã䜿çšãããšãããŒã¿ã®åŸ©å ãç°¡åã«ãªããŸãã以åã®ã¹ãããã·ã§ããã«ããŒã«ããã¯ãããã以åã®ã¹ãããã·ã§ããããéžæããããŒã¿ãã³ããŒãããã§ããŸãã 次ã®è¡šã¯ãUnity XT ã·ã¹ãã ã®ã¹ãããã·ã§ããã®ä¿åæéã瀺ããŠããŸãã
ããŒã¿ã¹ãããã·ã§ããã®ããŒã«ã«ããã³ãªã¢ãŒãã¹ãã¬ãŒãž
åçã®çš®é¡
CLI
UI
REST
æåã§
äºå®ãããŠãã
æåã§
äºå®ãããŠãã
æåã§
äºå®ãããŠãã
ããŒã«ã«
1幎
1幎
5幎
4é±
100幎
å¶éãªã
ãªã¢ãŒã
5幎
255é±é
5幎
255é±é
5幎
255é±é
ã¹ãããã·ã§ããã¯ãããã¯ã¢ãããªã©ã®ä»ã®ããŒã¿ä¿è·æ¹æ³ãçŽæ¥çœ®ãæãããã®ã§ã¯ãããŸããã ãããã¯ãäœ RTO ã·ããªãªã®é²åŸ¡ã®ç¬¬äžç·ãšããŠåŸæ¥ã®ããã¯ã¢ãããè£å®ããããšããã§ããŸããã
Dell EMC Unity ã¹ãããã·ã§ããæ©èœã«ã¯ãããŒã¿åæžãšé«åºŠãªéè€æé€ãå«ãŸããŠããŸãã ã¹ãããã·ã§ããã¯ãå ã®ã¹ãã¬ãŒãž ãªãœãŒã¹ã§å®çŸãããã¹ããŒã¹ã®ç¯çŽãããæ©æµãåããŸãã ããŒã¿åæžæ©èœããµããŒãããã¹ãã¬ãŒãž ãªãœãŒã¹ã®ã¹ãããã·ã§ãããäœæãããšããœãŒã¹ã®ããŒã¿ãå§çž®ãŸãã¯éè€æé€ã§ããŸãã
SQL Server ããŒã¿ããŒã¹ã§ã¹ãããã·ã§ããã䜿çšããå Žåã®ããŒã¿ããŒã¹ã®å埩ã«é¢ãã泚æäºé ãããã€ã瀺ããŸãã
- SQL Server ããŒã¿ããŒã¹ã®ãã¹ãŠã®ã³ã³ããŒãã³ãã¯ããŒã¿ ã»ãããšããŠä¿è·ããå¿ èŠããããŸãã ããŒã¿ ãã¡ã€ã«ãšãã° ãã¡ã€ã«ãç°ãªã LUN äžã«ããå Žåããããã® LUN ã¯æŽåæ§ã°ã«ãŒãã®äžéšã§ããå¿ èŠããããŸãã äžè²«æ§ã®ããã°ã«ãŒãã§ã¯ãã°ã«ãŒãå ã®ãã¹ãŠã® LUN ã§ã¹ãããã·ã§ãããåæã«äœæãããããšãä¿èšŒãããŸãã ããŒã¿ ãã¡ã€ã«ãšãã° ãã¡ã€ã«ãè€æ°ã® SMB ãã¡ã€ã«å ±æäžã«ããå Žåããããã®å ±æã¯åããã¡ã€ã« ã·ã¹ãã äžã«ããå¿ èŠããããŸãã
- ãããã¯ããŒã¹ã®ã¹ãããã·ã§ãããã SQL Server ããŒã¿ããŒã¹ããªã¹ãã¢ãããšãã«ãSQL Server ã€ã³ã¹ã¿ã³ã¹ãæ¥ç¶ãããŸãŸã«ããå¿ èŠãããå Žåã¯ãUnisphere ãã¹ãçµåã䜿çšããŸãã ãã¡ã€ã«ããŒã¹ã®ãªã«ããªã®å Žåãã¹ãããã·ã§ããããœãŒã¹ãšããŠäœ¿çšããŠè¿œå ã® SMB å ±æãäœæãããŸãã ããªã¥ãŒã ãããŠã³ããããããããŒã¿ããŒã¹ãå¥ã®ååã§æ¥ç¶ããããæ¢åã®ããŒã¿ããŒã¹ã埩å ãããããŒã¿ããŒã¹ã«çœ®ãæãããããããšãã§ããŸãã
- Unisphere ã§ã¹ãããã·ã§ãã ãªã¹ãã¢æ¹æ³ã䜿çšããŠãªã¹ãã¢ãå®è¡ããå Žåã¯ãSQL Server ã€ã³ã¹ã¿ã³ã¹ããªãã©ã€ã³ã«ããŸãã SQL Server ã¯åŸ©å æäœãèªèããŸããã ã€ã³ã¹ã¿ã³ã¹ããªãã©ã€ã³ã«ãããšããªã«ããªåã«ããŒã¿ããŒã¹ã®æžã蟌ã¿ã«ãã£ãŠããªã¥ãŒã ãæå·ããããšããªããªããŸãã ã€ã³ã¹ã¿ã³ã¹ãåèµ·åããããšãSQL Server ãã£ã¶ã¹ã¿ãŒ ãªã«ããªãŒã«ãã£ãŠããŒã¿ããŒã¹ãäžè²«ããç¶æ ã«ãªããŸãã
- è€æ°ã®ã¹ãã¬ãŒãž ãªããžã§ã¯ãã®ã¹ãããã·ã§ãããåæã«æå¹ã«ããè¿œå ã®ã¹ãããã·ã§ãããæå¹ã«ããåã«ã·ã¹ãã ãæšå¥šåäœã¢ãŒãã«ãªã£ãŠããããšã確èªããŸãã
ã·ã§ããã®èªååãšã¹ã±ãžã¥ãŒã«èšå®
Unity XT ã®ã¹ãããã·ã§ããã¯èªååã§ããŸãã Unisphere ã¹ãã¬ãŒãžç®¡çã§ã¯ãããã©ã«ãã®ã¹ãããã·ã§ãã ãªãã·ã§ã³ãããã©ã«ãã®ä¿è·ãããçãä¿åæéã®ä¿è·ãããã³ããé·ãä¿åæéã®ä¿è·ã䜿çšã§ããŸãã åãªãã·ã§ã³ã¯æ¯æ¥ã¹ãããã·ã§ãããååŸããããããããŸããŸãªæéã«ããã£ãŠä¿åããŸãã
ã¹ã±ãžã¥ãŒã« ãªãã·ã§ã³ã®ãããã (ãŸãã¯äž¡æ¹)ãx æéããš (1 ïœ 24)ãããã³æ¯æ¥/æ¯é±ãéžæã§ããŸãã æ¯æ¥/æ¯é±ã®ã¹ãããã·ã§ããã®ã¹ã±ãžã¥ãŒã«èšå®ã«ãããã¹ãããã·ã§ãããååŸããç¹å®ã®æéãšææ¥ãæå®ã§ããŸãã éžæãããªãã·ã§ã³ããšã«ãããŒã«ãèªåçã«åé€ãããäžæçã«ä¿åããããã«æ§æã§ããä¿æããªã·ãŒãèšå®ããå¿ èŠããããŸãã
Unity ã¹ãããã·ã§ããã®è©³çŽ°ã«ã€ããŠã¯ã次㮠URL ãåç
§ããŠãã ããã
ã·ã³ ã¯ããŒã³
ã·ã³ ã¯ããŒã³ã¯ã芪ãªãœãŒã¹ãšãããã¯ãå ±æãããããªã¥ãŒã ãã³ã³ã·ã¹ãã³ã·ãŒ ã°ã«ãŒããVMware VMFS ããŒã¿ã¹ãã¢ãªã©ã®ã·ã³ ããã㯠ã¹ãã¬ãŒãž ãªãœãŒã¹ã®èªã¿åã/æžã蟌ã¿ã³ããŒã§ãã ã·ã³ ã¯ããŒã³ã¯ãSQL Server ããŒã¿ããŒã¹ã®ã³ããŒãè¿ éãã€ã³ã³ãã¯ãã«æäŸããåªããæ¹æ³ã§ãããããã¯åŸæ¥ã® SQL Server ããŒã«ã§ã¯å®çŸã§ããŸããã§ããã ã·ã³ ã¯ããŒã³ããã¹ãã«æäŸããããšãããªã¥ãŒã ããªã³ã©ã€ã³ã«ããããšãã§ããSQL Server ã® DB Attach ã¡ãœããã䜿çšããŠããŒã¿ããŒã¹ãæ¥ç¶ãããŸãã
ã·ã³ ã¯ããŒã³ã§ã¢ããã°ã¬ãŒãæ©èœã䜿çšããå Žåã¯ãã·ã³ ã¯ããŒã³äžã®ãã¹ãŠã®ããŒã¿ããŒã¹ããªãã©ã€ã³ã«ããŸãã ããã¯æŽæ°æäœã®åã«è¡ãå¿ èŠããããŸãã ã¢ããã°ã¬ãŒããå®è¡ããåã«ããŒã¿ããŒã¹ããªãã©ã€ã³ã«ããªããšãSQL Server äžã§ããŒã¿ã®äžæŽåãšã©ãŒãäžæ£ãªããŒã¿çµæãçºçããå¯èœæ§ããããŸãã
ããŒã¿è€è£œ
ã¬ããªã±ãŒã·ã§ã³ã¯ãåããµã€ããŸãã¯å¥ã®å Žæã«ãããªã¢ãŒã ã·ã¹ãã ãšããŒã¿ãåæãããœãããŠã§ã¢æ©èœã§ãã Unity ã®ã¬ããªã±ãŒã·ã§ã³ãšæ§æã®ãªãã·ã§ã³ã䜿çšãããšãããã©ãŒãã³ã¹ãšã¹ã«ãŒãããã®ãã©ã³ã¹ããšããªãããSQL Server ããŒã¿ããŒã¹ã® RTO/RPO èŠä»¶ãæºããå¹ççãªæ¹æ³ãéžæã§ããŸãã
Dell EMC Unity ã¬ããªã±ãŒã·ã§ã³ã䜿çšããŠè€æ°ã®ããªã¥ãŒã äžã® SQL Server ããŒã¿ããŒã¹ãä¿è·ããå Žåã¯ãããŒã¿ããŒã¹å ã®ãã¹ãŠã®ããŒã¿ ããªã¥ãŒã ãšãã° ããªã¥ãŒã ãåäžã®æŽåæ§ã°ã«ãŒããŸãã¯ãã¡ã€ã« ã·ã¹ãã ã«å¶éããå¿ èŠããããŸãã ãã®åŸãã°ã«ãŒããŸãã¯ãã¡ã€ã« ã·ã¹ãã äžã§ã¬ããªã±ãŒã·ã§ã³ãèšå®ãããè€æ°ã®ããŒã¿ããŒã¹ã®ããªã¥ãŒã ãŸãã¯å ±æãå«ããããšãã§ããŸãã ç°ãªãã¬ããªã±ãŒã·ã§ã³ ãªãã·ã§ã³ãå¿ èŠãšããããŒã¿ããŒã¹ã¯ãå¥åã® LUNãæŽåæ§ã°ã«ãŒãããŸãã¯ãã¡ã€ã« ã·ã¹ãã äžã«ååšããå¿ èŠããããŸãã
ã·ã³ ã¯ããŒã³ã¯ãåæã¬ããªã±ãŒã·ã§ã³ãšéåæã¬ããªã±ãŒã·ã§ã³ã®äž¡æ¹ãšäºææ§ããããŸãã ã·ã³ ã¯ããŒã³ãå®å ã«ã¬ããªã±ãŒãããããšãããªã¥ãŒã ãæŽåæ§ã°ã«ãŒãããŸã㯠VMFS ã¹ãã¬ãŒãžã®ãã« ã³ããŒã«ãªããŸãã ã¬ããªã±ãŒã·ã§ã³åŸã®ã·ã³ ã¯ããŒã³ã¯ãç¬èªã®èšå®ãæã€å®å šã«ç¬ç«ããããªã¥ãŒã ã«ãªããŸãã
ãœãŒã¹ ã·ã¹ãã ãšã¿ãŒã²ãã ã·ã¹ãã éã®ã·ã³ ã¯ããŒã³ ã¬ããªã±ãŒã·ã§ã³ã®ããã»ã¹ã
SQL Server ã®åèµ·åæã«ãã¡ã€ã«ãåæ§ç¯ããããããã¡ã¿ããŒã¿ãä»ã® SQL Server ã€ã³ã¹ã¿ã³ã¹ã®æ¹æ³ãšäžèŽããªããããtempdb ããŒã¿ããŒã¹ã®ã¬ããªã±ãŒã·ã§ã³ã¯å¿ èŠãããŸããã ã¬ããªã±ãŒãããããªã¥ãŒã ãšãããã®ããªã¥ãŒã ã®å 容ãæ éã«éžæãããšãäžå¿ èŠãªã¬ããªã±ãŒã·ã§ã³ ãã©ãã£ãã¯ãæé€ãããŸãã
çµ±åããã Microsoft SQL Server ããŒã¿ã³ããŒç®¡ç
ææ°ã®ã¹ãã¬ãŒãžè£œå (ãã¹ãŠã® Dell EMC 補åãå«ã) ã®ã»ãšãã©ã¯ã次ã®æ¹æ³ã§ããããçš®é¡ã®ãã¡ã€ã«ã®ããªãã¬ãŒãã£ã³ã° ã·ã¹ãã ãšæŽåæ§ã®ãããã³ããŒãäœæã§ããŸãã
- ãã¹ããããã©ã€ããŸã§ããã¹ãŠã®ã¬ãã«ã§ãªãã¬ãŒãã£ã³ã° ã·ã¹ãã ã«ããäžè²«ããæžã蟌ã¿é åºã
- ããªã¥ãŒã ãã°ã«ãŒãåããŠãç°ãªãããªã¥ãŒã äžã®è€æ°ã®ãã¡ã€ã«ãæžã蟌ã¿é åºãç¶æã§ããããã«ããŸãã
ã¹ã±ãŒã©ãã«ãªã¹ãã¬ãŒãž ããã€ã¹ã®æ®åã«äŒŽããMicrosoft ã¯ã¹ãã¬ãŒãž ãããã€ããŒåãã® API ãéçºããŸããã ãã® API ã䜿çšãããšãã¹ãã¬ãŒãž ãããã€ããŒã¯ SQL Server ããŒã¿ããŒã¹ ãœãããŠã§ã¢ãšé£æºããŠãããªã¥ãŒã ã·ã£ã㊠ã³ã㌠ãµãŒãã¹ (VSS) ã䜿çšããŠãã¢ããªã±ãŒã·ã§ã³æŽåæ§ã®ããã³ããŒããäœæã§ããŸãã ãããã®ã³ããŒã¯ãSQL Server ã®ã¹ã±ãžã¥ãŒã«ãããã·ã£ããããŠã³äžããã³ SQL Server ã®ã·ã£ããããŠã³äžã® SQL Server ãšãªãã¬ãŒãã£ã³ã° ã·ã¹ãã éã®å¯Ÿè©±ãã·ãã¥ã¬ãŒãããŸãã ãã¹ãŠã®ãã£ã¹ã¯ãæŽæ°ãããç¹å®ã®æç¹ã§æŽåæ§ãä¿ããããŸã§ããã¹ãŠã®æžã蟌ã¿ãããã¡ããã©ãã·ã¥ããããã©ã³ã¶ã¯ã·ã§ã³ã¯äžæåæ¢ãããŸãããã㯠SQL ãã°ã«èšé²ãããŸãã
Unity XT ã¹ãããã·ã§ãããšçµ±åããã Dell EMC AppSync ãœãããŠã§ã¢ã¯ãã¢ããªã±ãŒã·ã§ã³ãšæŽåæ§ã®ããäœæ¥ããŒã¿ã®ã³ããŒãäœæã䜿çšã管çããããã»ã¹ãç°¡çŽ åããã³èªååããŸãã ãã®ãœãããŠã§ã¢ã¯ãããŒã¿ããŒã¹ã®å埩ãšåå©çšã®ããã®ã³ããŒå¶åŸ¡ã·ããªãªã§ã®äœ¿çšãç®çãšããŠããŸãã
AppSync ãœãããŠã§ã¢ã¯ãã¢ããªã±ãŒã·ã§ã³ ããŒã¿ããŒã¹ãèªåçã«æ€åºããããŒã¿ããŒã¹æ§é ãåŠç¿ããããŒããŠã§ã¢ãŸãã¯ä»®æ³åã¬ã€ã€ãŒãä»ããŠãã¡ã€ã«æ§é ãåºç€ãšãªã Unity XT ã¹ãã¬ãŒãžã«ãããã³ã°ããŸãã ã³ããŒã®äœæãšæ€èšŒãããã¿ãŒã²ãã ãã¹ãã§ã®ã¹ãããã·ã§ããã®ããŠã³ããããŒã¿ããŒã¹ã®èµ·åãŸãã¯åŸ©å ãŸã§ãå¿ èŠãªãã¹ãŠã®æé ã調æŽããŸãã AppSync ã¯ãéçšããŒã¿ããŒã¹ã®æŽæ°ãšåŸ©å ãå«ã SQL Server ã¯ãŒã¯ãããŒããµããŒãããç°¡çŽ åããŸãã
ããŒã¿åæžãšé«åºŠãªéè€æé€
Dell EMC Unity ãã¡ããªã®ã¹ãã¬ãŒãž ã·ã¹ãã ã¯ãæ©èœãè±å¯ã§äœ¿ããããããŒã¿åæžãµãŒãã¹ãæäŸããŸãã æ§ææžã¿ã®ãã©ã€ã㪠ã¹ãã¬ãŒãž ãªãœãŒã¹ã ãã§ãªãããããã®ãªãœãŒã¹ã®ã¹ãããã·ã§ãããã·ã³ ã¯ããŒã³ã§ãç¯çŽãå®çŸãããŸãã ã¹ãããã·ã§ãããšã·ã³ ã¯ããŒã³ã¯ãœãŒã¹ ã¹ãã¬ãŒãžã®ããŒã¿åæžèšå®ãç¶æ¿ããããã容éã®ç¯çŽãåäžããŸãã
ããŒã¿åæžæ©èœã«ã¯éè€æé€ãå§çž®ããŒã ãããã¯æ€åºã¢ã¯ãã£ããã£ãå«ãŸããŠããããŠãŒã¶ãŒ ãªããžã§ã¯ããå éšäœ¿çšã«äœ¿çšã§ããã¹ãã¬ãŒãžå®¹éãå¢å ããå¯èœæ§ããããŸãã Unity XT ããŒã¿åæžæ©èœã¯ãUnity OE 4.3 以éã®å§çž®æ©èœã眮ãæããŸãã å§çž®ã¯ãããŒã¿ã»ããã®ä¿åã«å¿ èŠãªå®¹éã®ç©ççãªå²ãåœãŠãåæžã§ããããŒã¿åæžã¢ã«ãŽãªãºã ã§ãã
Unity XT ã·ã¹ãã ã¯ãããŒã¿åæžãæå¹ãªå Žåã«æå¹ã«ã§ããé«åºŠãªéè€æé€æ©èœãæäŸããŸãã é«åºŠãªéè€æé€ã§ã¯ãUnity ããŒã¿ ãããã¯ã®å°æ°ã®ã³ã㌠(é垞㯠XNUMX ã€ã®ã³ããŒã®ã¿) ã®ã¿ãä¿åããããšã§ããŠãŒã¶ãŒ ããŒã¿ã«å¿ èŠãªå®¹éãåæžããŸãã éè€æé€é å㯠XNUMX ã€ã® LUN ã§ãã ã¹ãã¬ãŒãžã¹ããŒã ãéžæãããšãã¯ããããèæ ®ããŠãã ããã LUN ãå°ãªãã»ã©éè€æé€ã¯åäžããŸãããLUN ãå€ãã»ã©ããã©ãŒãã³ã¹ãåäžããŸãã
é«åºŠãªéè€æé€ã«ãã容éã®ç¯çŽã¯ãã»ãšãã©ã®ç°å¢ã§æ倧ã®ã¡ãªããããããããŸãããUnity ã¢ã¬ã€ ããã»ããµã®äœ¿çšãå¿
èŠã«ãªããŸãã OE 5.0 ã§ã¯ãé«åºŠãªéè€æé€ãæå¹ã«ãããšãããããããã㯠(å§çž®ãŸãã¯éå§çž®) ãéè€æé€ãããŸãã 詳现ã«ã€ããŠã¯ããããåç
§ããŠãã ããã
次ã®è¡šã¯ãããŒã¿åæžãšé«åºŠãªéè€æé€ã§ãµããŒããããŠããæ§æã瀺ããŠããŸãã
Unity ã§ã®ããŒã¿åæž (ãã¹ãŠã®ã¢ãã«) ãšåŒ·åãããéè€æé€ãµããŒã
Unity OE ããŒãžã§ã³
Ð¢ÐµÑ ÐœÐŸÐ»ÐŸÐ³ÐžÑ
ãµããŒããããŠããããŒã«ã®çš®é¡
察å¿æ©çš®
4.3 / 4.4
ããŒã¿åæž
ãã©ãã·ã¥ ã¡ã¢ãª ããŒã« - åŸæ¥åãŸãã¯åç
300ã400ã500ã600ã300Fã400Fã500Fã600Fã350Fã450Fã550Fã650F
4.5
ããŒã¿åæž
300ã400ã500ã600ã300Fã400Fã500Fã600Fã350Fã450Fã550Fã650F
ããŒã¿åæžãšé«åºŠãªéè€æé€*
450Fã550Fã650F
5
ããŒã¿åæž
300ã400ã500ã600ã300Fã400Fã500Fã600Fã350Fã450Fã550Fã650Fã380ã480ã680ã880ã380Fã480Fã680Fã880F
ããŒã¿åæžãšé«åºŠãªéè€æé€
450Fã550Fã650Fã380ã480ã680ã880ã380Fã480Fã680Fã880F
* ããŒã¿åæžã¯ããã©ã«ãã§ç¡å¹ã«ãªã£ãŠãããé«åºŠãªéè€æé€ãªãã·ã§ã³ãå©çšå¯èœã«ãªãåã«æå¹ã«ããå¿ èŠããããŸãã ããŒã¿åæžãæå¹ã«ãããšãé«åºŠãªéè€æé€ã䜿çšå¯èœã«ãªããŸãããããã©ã«ãã§ã¯ç¡å¹ã«ãªã£ãŠããŸãã
Unity ã§ã®ããŒã¿åæžãš SQL Server ã§ã®ããŒã¿å§çž®
SQL Server 2008 Enterprise Edition ã¯ããã€ãã£ã ããŒã¿å§çž®æ©èœãæäŸããæåã®ãªãªãŒã¹ã§ããã SQL Server 2008 ã®è¡ã¬ãã«ããã³ããŒãž ã¬ãã«ã®å§çž®ã§ã¯ãSQL Server ã®å éšããŒã¿ããŒã¹ ããŒãã«åœ¢åŒã®ç¥èã䜿çšããŠãããŒã¿ããŒã¹ ãªããžã§ã¯ãã«ãã£ãŠæ¶è²»ãããé åãåæžããŸãã ã¹ããŒã¹ãåæžãããšã8 ããŒãžãããã®è¡æ°ãå¢ãããããã¡ãŒ ããŒã«ã«ããå€ãã®ããŒãžãä¿åã§ããããã«ãªããŸãã NVARCHAR(MAX) ãªã©ã®è¡å€ããŒã¿ãªã©ãXNUMXK ããŒã¿ ããŒãžåœ¢åŒã§æ ŒçŽãããŠããªãããŒã¿ã¯è¡ãŸãã¯ããŒãžã®å§çž®æ¹æ³ã䜿çšããªããããMicrosoft 㯠Transact-SQL COMPRESS é¢æ°ãš DECOMPRESS é¢æ°ãå°å ¥ããŸããã
ãããã®é¢æ°ã¯ãå§çž®ãŸãã¯è§£åããããŒã¿ã®ã»ã¯ã·ã§ã³ããšã«åŒã³åºãå¿ èŠãããåŸæ¥ã®ããŒã¿å§çž®ã¢ãããŒã (GZIP ã¢ã«ãŽãªãºã ) ã䜿çšããŸãã
Unity XT å§çž®ã¯ SQL Server ã«éå®ããããã®ã§ã¯ãªãããœãããŠã§ã¢ ã¢ã«ãŽãªãºã ã䜿çšããŠã¹ãã¬ãŒãž ããŒã¿ãåæããã³å§çž®ããŸãã Unity OE 4.1 ã®ãªãªãŒã¹ä»¥æ¥ããã©ãã·ã¥ ããŒã«å ã®ããã㯠ã¹ãã¬ãŒãž ããªã¥ãŒã ãš VMFS ããŒã¿ ã¹ãã¢ã§ Unity ããŒã¿å§çž®ãå©çšã§ããããã«ãªããŸããã Unity OE 4.2 以éããã¡ã€ã« ã·ã¹ãã ãšãã©ãã·ã¥ ã¹ãã¬ãŒãž ããŒã«ã® NFS ããŒã¿ ã¹ãã¢ã§ãå§çž®ãå©çšã§ããããã«ãªããŸããã
SQL Server ã®ããŒã¿å§çž®æ¹æ³ã®éžæã¯ãããã€ãã®èŠå ã«ãã£ãŠæ±ºãŸããŸãã ãããã®èŠçŽ ã«ã¯ãããŒã¿ããŒã¹ ã³ã³ãã³ãã®ã¿ã€ããã¹ãã¬ãŒãžãšããŒã¿ããŒã¹ ãµãŒããŒã®äž¡æ¹ã§å©çšå¯èœãª CPU ãªãœãŒã¹ãSLA ãç¶æããããã«å¿ èŠãª I/O ãªãœãŒã¹ãå«ãŸããŸãã äžè¬ã«ãSQL Server ã䜿çšããŠå§çž®ãããããŒã¿ã§ã¯ãããªãã¹ããŒã¹ã®ç¯çŽãæåŸ ã§ããŸãããTSQL ã® GZIP å§çž®æ©èœã䜿çšããŠå§çž®ãããããŒã¿ã§ã¯ãå©ç¹ã®ã»ãšãã©ãåè ã«ãããã®ã§ãããããUnity XT ã®å§çž®æ©èœã«ããå€§å¹ ãªè¿œå ã¹ããŒã¹ã®ç¯çŽã¯æåŸ ã§ããŸãããã¢ã«ãŽãªãºã ã
ã¹ãã¬ãŒãž ãªããžã§ã¯ãäžã®ããŒã¿ãå°ãªããšã 25% å§çž®ãããŠããå ŽåãUnity å§çž®ã«ããã¹ããŒã¹ãç¯çŽãããŸãã ã¹ãã¬ãŒãž ãªããžã§ã¯ãã®å§çž®ãæå¹ã«ããåã«ãå§çž®å¯èœãªããŒã¿ãã¹ãã¬ãŒãž ãªããžã§ã¯ãã«å«ãŸããŠãããã©ããã確èªããŠãã ããã 容éãç¯çŽããå Žåãé€ããã¹ãã¬ãŒãž ãªããžã§ã¯ãã®å§çž®ãæå¹ã«ããªãã§ãã ããã
Unity ããŒã¿åæžãSQL Server ããŒã¿ããŒã¹ ã¬ãã«ã®å§çž®ããŸãã¯ãã®äž¡æ¹ã䜿çšãããã©ããã決å®ãããšãã¯ã次ã®ç¹ãèæ ®ããŠãã ããã
- Unity ã·ã¹ãã ã«æžã蟌ãŸããããŒã¿ã¯ãã·ã¹ãã ãã£ãã·ã¥ã«ä¿åãããåŸããã¹ãã«ãã£ãŠæ€èšŒãããŸãã ãã ããå§çž®ããã»ã¹ã¯ãã£ãã·ã¥ãã¯ãªã¢ããããŸã§éå§ãããŸããã
- å§çž®ã®ç¯çŽã¯ãUnity XT ã¹ãã¬ãŒãž ãªãœãŒã¹ã ãã§ãªãããªãœãŒã¹ã®ã¹ãããã·ã§ãããã·ã³ ã¯ããŒã³ã§ãå®çŸãããŸãã
- å§çž®ããã»ã¹äžããµã³ããªã³ã° ã¢ã«ãŽãªãºã ã䜿çšããŠè€æ°ã®ãããã¯ãéçŽãããããŒã¿ãå§çž®ã§ãããã©ãããå€æãããŸãã ãµã³ããªã³ã° ã¢ã«ãŽãªãºã ã«ãã£ãŠæå°éã®ç¯çŽããéæã§ããªããšå€æãããå Žåãå§çž®ã¯ã¹ããããããããŒã¿ãããŒã«ã«æžã蟌ãŸããŸãã
- ããŒã¿ãã¹ãã¬ãŒãž ã¡ãã£ã¢ã«æžã蟌ãåã«å§çž®ãããšãããŒã¿ã®åŠçéãå€§å¹ ã«åæžãããŸãã ãããã£ãŠãå§çž®ã«ããããã©ã€ãã«æžã蟌ãŸããç©ççãªããŒã¿éãæžãããã©ãã·ã¥ ã¡ã¢ãªã®æ¶èã軜æžãããŸãã
SQL Server ã§ã®ããŒãã«ãšã€ã³ããã¯ã¹ã®è¡ãšããŒãžã®å§çž®ã®è©³çŽ°ã«ã€ããŠã¯ã次ãåç
§ããŠãã ããã
å§çž®ã«ã¯ CPU ãªãœãŒã¹ãå¿ èŠã§ããããšãå¿ããªãã§ãã ããã 垯åå¹ èŠä»¶ãé«ãå Žåãå§çž®ã¯ããã©ãŒãã³ã¹ã«å€§ããªåœ±é¿ãäžããå¯èœæ§ããããŸãã OLAP ã¯ãŒã¯ããŒãã®æžã蟌ã¿çãé«ããšãSQL Server ããŒã¿ããŒã¹ã®å§çž®ã®å©ç¹ãæžå°ããå¯èœæ§ããããŸãã
Dell EMC ã¯ãUnity ã¢ã¬ã€ã§ã®å®éã®ããŒã¿åæžçã䜿çšããŠãæœåšçãªç¯çŽéã調æ»ããŸããã ããŒã ã¯ãVMware ä»®æ³ãã·ã³ããã¡ã€ã«å ±æãSQL Server ããŒã¿ããŒã¹ãMicrosoft Hyper-V ä»®æ³ãã·ã³ãªã©ã«é¢ããããŒã¿ãåéããŸããã
調æ»çµæã«ãããšãSQL Server ãã° ãã¡ã€ã«ã®ãµã€ãºã¯ããŒã¿ ãã¡ã€ã«ã®çŽ 10 åã® XNUMX ã«çž®å°ãããŸãã
- ããŒã¿ããŒã¹ ãµã€ãº = 1,49:1 (32,96%)
- ãã°ããªã¥ãŒã = 12,9:1 (92,25%)
SQL Server ããŒã¿ããŒã¹ã«ã¯ XNUMX ã€ã®ããªã¥ãŒã ãæäŸãããŸããã ããŒã¿ããŒã¹ ãã¡ã€ã«ã¯ XNUMX ã€ã®ããªã¥ãŒã ã«ä¿åããããã©ã³ã¶ã¯ã·ã§ã³ ãã°ã¯å¥ã®ããªã¥ãŒã ã«ä¿åãããŸãã ããŒã¿ããŒã¹ ããªã¥ãŒã ã§ããŒã¿åæžãã¯ãããžãŒã䜿çšãããšãã¹ãã¬ãŒãžãç¯çŽã§ããŸãã ãã ããããŒã¿ããŒã¹ ããªã¥ãŒã ã§éè€æé€ãæå¹ã«ãããã©ããã決å®ãããšãã¯ãããã©ãŒãã³ã¹ãžã®åœ±é¿ãèæ
®ããå¿
èŠããããŸãã å®éã®ããŒã¿ããŒã¹ ãµã€ãºã®åæžã¯ãä¿åãããŠããããŒã¿ã«ãã£ãŠç°ãªããŸããã調æ»çµæã«ãããšãSQL Server ã®ãã©ã³ã¶ã¯ã·ã§ã³ ãã°ã®ä¿åã¹ããŒã¹ã¯ã
ããŒã¿åæžã®ãã¹ã ãã©ã¯ãã£ã¹
ã¹ãã¬ãŒãž ãªããžã§ã¯ãã®ããŒã¿åæžãæå¹ã«ããåã«ã次ã®ã¬ã€ãã©ã€ã³ãèæ ®ããŠãã ããã
- ã¹ãã¬ãŒãž ã·ã¹ãã ã®ç£èŠã䜿çšããŠãããŒã¿åæžããµããŒãããããã«å©çšå¯èœãªãªãœãŒã¹ãããããšã確èªããŸãã
- è€æ°ã®ã¹ãã¬ãŒãž ãªããžã§ã¯ãã®ããŒã¿åæžãäžåºŠã«æå¹ã«ããŸãã è¿œå ã®ã¹ãã¬ãŒãž ãµã€ãã§ã·ã¹ãã ãæå¹ã«ããåã«ãã·ã¹ãã ãç£èŠããŠæšå¥šåäœæ¡ä»¶ã«ããããšã確èªããŸãã
- Unity XT x80F ã¢ãã«ã§ã¯ãã¹ãã¬ãŒãž ãŠãããå ã®ããŒã¿ãå°ãªããšã 1% å§çž®ãããŠããå ŽåãããŒã¿åæžã«ãã容éãç¯çŽãããŸãã
OE 80 ãå®è¡ããŠãã以åã® Unity x5.0F ã¢ãã«ã§ã®ããŒã¿åæžã«ãããããŒã¿ãå°ãªããšã 25% å§çž®å¯èœã§ããéããããŒã¿ãç¯çŽã§ããŸããã
- ã¹ãã¬ãŒãž ãªããžã§ã¯ãã®ããŒã¿åæžãæå¹ã«ããåã«ããªããžã§ã¯ãã«å§çž®å¯èœãªããŒã¿ãå«ãŸããŠãããã©ããã確èªããŠãã ããã ãããªããªãŒãã£ãªãç»åããã€ã㪠ããŒã¿ãªã©ã®ç¹å®ã®ããŒã¿ ã¿ã€ãã¯ãéåžžãå§çž®ã«ããã¡ãªãããã»ãšãã©ãããŸããã ã¹ããŒã¹ãç¯çŽã§ããªãå Žåã¯ãã¹ãã¬ãŒãž ãªããžã§ã¯ãã®ããŒã¿åæžãæå¹ã«ããªãã§ãã ããã
- éåžžã¯é©åã«å§çž®ããããã¡ã€ã« ããŒã¿ã®ããªã¥ãŒã ãéžæçã«å§çž®ããããšãæ€èšããŠãã ããã
VMwareã®ä»®æ³å
VMware vSphere ã¯ãä»®æ³åããã³ã¯ã©ãŠãç°å¢ã®ããã®å¹ççã§å®å šãªãã©ãããã©ãŒã ã§ãã vSphere ã®ã³ã¢ ã³ã³ããŒãã³ãã¯ãVMware vCenter Server ãš VMware ESXi ãã€ããŒãã€ã¶ãŒã§ãã
vCenter Server ã¯ãvSphere ç°å¢çšã®çµ±å管çãã©ãããã©ãŒã ã§ãã å°å ¥ã¯ç°¡åã§ããªãœãŒã¹ãç©æ¥µçã«æé©åããŸãã ESXi ã¯ãç©çãµãŒããŒã«çŽæ¥ã€ã³ã¹ããŒã«ããããªãŒãã³ ãœãŒã¹ã®ãã€ããŒãã€ã¶ãŒã§ãã ESXi ã¯ã³ã¢ ãªãœãŒã¹ã«çŽæ¥ã¢ã¯ã»ã¹ã§ãããµã€ãºã 150 MB ãšå°ãããããã¡ã¢ãªèŠä»¶ãæå°éã«æããããŸãã ããŸããŸãªã¢ããªã±ãŒã·ã§ã³ ã¯ãŒã¯ããŒãã«å¯ŸããŠä¿¡é Œæ§ã®é«ãããã©ãŒãã³ã¹ãæäŸããæ倧 128 åã® vCPUã6 TB ã® RAMãããã³ 120 å°ã®ããã€ã¹ãšãã匷åãªä»®æ³ãã·ã³æ§æããµããŒãããŸãã
SQL Server ãææ°ã®ããŒããŠã§ã¢ã§å¹æçã«å®è¡ããã«ã¯ãSQL Server ãªãã¬ãŒãã£ã³ã° ã·ã¹ãã (SQLOS) ãããŒããŠã§ã¢èšèšãç解ããŠããå¿ èŠããããŸãã ãã«ãã³ã¢ããã³ãã«ãããŒãã® Non-Uniform Memory Access (NUMA) ã·ã¹ãã ã®åºçŸã«ãããã³ã¢ãè«çããã»ããµãããã³ç©çããã»ããµéã®é¢ä¿ãç解ããããšãç¹ã«éèŠã«ãªã£ãŠããŸããã
ããã»ããµãŒ
ä»®æ³åŠçè£ çœ® (vCPU) ã¯ãä»®æ³ãã·ã³ã«å²ãåœãŠãããä»®æ³äžå€®åŠçè£ çœ®ã§ãã å²ãåœãŠããã vCPU ã®åèšæ°ã¯æ¬¡ã®ããã«èšç®ãããŸãã
Total vCPU = (кПлОÑеÑÑвП вОÑÑÑалÑÐœÑÑ
ÑПкеÑПв) * (кПлОÑеÑÑвП вОÑÑÑалÑÐœÑÑ
ÑÐŽÐµÑ ÐœÐ° ÑПкеÑ)
äžè²«ããããã©ãŒãã³ã¹ãéèŠãªå ŽåãVMware ã§ã¯ããã¹ãŠã®ä»®æ³ãã·ã³ã«å²ãåœãŠããã vCPU ã®åèšæ°ããESXi ãã¹ãã§äœ¿çšå¯èœãªç©çã³ã¢ã®åèšæ°ãè¶ ããªãããã«ããããšãæšå¥šããŠããŸãããæªäœ¿çšã® CPU ãªãœãŒã¹ãç£èŠã«ãã£ãŠç€ºãããå Žåã¯ãå²ãåœãŠããã vCPU ã®æ°ãå¢ããããšãã§ããŸãããå©çšããã ããŸãã
ã€ã³ãã« ãã€ã㌠ã¹ã¬ããã£ã³ã° ãã¯ãããžãŒãæå¹ã«ãªã£ãŠããã·ã¹ãã ã§ã¯ãè«çã³ã¢ (vCPU) ã®æ°ã¯ç©çã³ã¢ã®æ°ã® XNUMX åã«ãªããŸãã ãã®å ŽåãvCPU ã®åèšæ°ãå²ãåœãŠãªãã§ãã ããã
äžäœå±€ã® SQL Server ã¯ãŒã¯ããŒãã¯ãé 延ã®å€åã®åœ±é¿ãããŸãåããŸããã ãããã£ãŠããããã®ã¯ãŒã¯ããŒãã¯ãç©ç CPU ã«å¯Ÿãã vCPU ã®æ¯çãé«ããã¹ãäžã§å®è¡ã§ããŸãã é©å㪠CPU 䜿çšçã¬ãã«ã«ãããã·ã¹ãã å šäœã®ã¹ã«ãŒããããåäžããã©ã€ã»ã³ã¹ã®ç¯çŽãæ倧åãããé©åãªããã©ãŒãã³ã¹ãç¶æãããŸãã
Intel ãã€ããŒã¹ã¬ããã£ã³ã°ã¯éåžžããã¹ãå šäœã®ã¹ã«ãŒãããã 10% ïœ 30% åäžãããŸããããã¯ãvCPU ãšç©ç CPU ã®æ¯çã 1,1 ïœ 1,3 ã§ããããšã瀺åããŠããŸãã VMware ã§ã¯ãESXi ããã®ãã¯ãããžãŒãå©çšã§ããããã«ãå¯èœãªéã UEFI BIOS ã§ãã€ã㌠ã¹ã¬ããã£ã³ã°ãæå¹ã«ããããšããå§ãããŸãã ãŸããVMware ã§ã¯ãSQL Server ã¯ãŒã¯ããŒãã«ãã€ã㌠ã¹ã¬ããã£ã³ã°ã䜿çšããå Žåã培åºçãªãã¹ããšç£èŠãæšå¥šããŠããŸãã
ã¡ã¢ãª
ææ°ã®ãµãŒããŒã®ã»ãšãã©ã¯ãã¡ã€ã³ ã¡ã¢ãªãšããã»ããµéã®éä¿¡ã« Non-Uniform Memory Access (NUMA) ã¢ãŒããã¯ãã£ã䜿çšããŠããŸãã NUMA ã¯ãç©çããã»ããµéã§ã®ç©çã¡ã¢ãªã®ãããã¯ã®åå²ãå®è£ ããå ±æã¡ã¢ãªçšã®ããŒããŠã§ã¢ ã¢ãŒããã¯ãã£ã§ãã NUMA ããŒãã¯ãå²ãåœãŠãããã¡ã¢ãªã®ãããã¯ãåãã XNUMX ã€ä»¥äžã® CPU ãœã±ããã§ãã
NUMA ã¯ãéå» XNUMX 幎éã«ããã£ãŠåºãè°è«ãããŠãããããã¯ã§ãã NUMA ãæ¯èŒçè€éãªã®ã¯ãããŸããŸãªãã³ããŒã«ããå®è£ ãåå ã® XNUMX ã€ã§ãã ä»®æ³åç°å¢ã§ã¯ãNUMA ã®è€éãã¯ãããŒããŠã§ã¢ãããã€ããŒãã€ã¶ãŒãã²ã¹ã ãªãã¬ãŒãã£ã³ã° ã·ã¹ãã ããããŠæçµçã« SQL Server ã¢ããªã±ãŒã·ã§ã³ã«è³ããŸã§ã®æ§æãªãã·ã§ã³ãšã¬ã€ã€ãŒã®æ°ã«ãã£ãŠã決ãŸããŸãã ä»®æ³åããã SQL Server ã€ã³ã¹ã¿ã³ã¹ãå®è¡ãã SQL Server DBA ã«ãšã£ãŠãNUMA ããŒããŠã§ã¢ ã¢ãŒããã¯ãã£ãããç解ããããšã¯å¿ é ã§ãã
å€æ°ã®ã³ã¢ãåãããµãŒããŒã§ããé«ãå¹çãå®çŸããããã«ãMicrosoft 㯠SoftNUMA ãå°å ¥ããŸããã SoftNUMA ãœãããŠã§ã¢ã䜿çšãããšãåäžã® NUMA å ã§å©çšå¯èœãª CPU ãªãœãŒã¹ãè€æ°ã® SoftNUMA ããŒãã«åå²ã§ããŸãã VMware ã«ãããšãSoftNUMA 㯠VMware ã®ä»®æ³ NUMA (vNUMA) ããããžãšäºææ§ããããã»ãšãã©ã®ã¯ãŒã¯ããŒãã«å¯ŸããŠããŒã¿ããŒã¹ ãšã³ãžã³ã®ã¹ã±ãŒã©ããªãã£ãšããã©ãŒãã³ã¹ãããã«æé©åã§ããŸãã
SQL Server ã䜿çšã㊠VMware ãä»®æ³åããå Žåã¯ã以äžã䜿çšããŸãã
- ä»®æ³ãã·ã³ãç£èŠããŠãSQL Server ããŒã¿ããŒã¹ ãšã³ãžã³ã®ã¡ã¢ãª ãªãœãŒã¹ã®äžè¶³ãæ€åºããŸãã ãã®åé¡ã«ãããI/O æäœãå¢å ããããã©ãŒãã³ã¹ãäœäžããŸãã
- ããã©ãŒãã³ã¹ãåäžãããã«ã¯ãESXi ãã¹ã ã¬ãã«ã§ã¡ã¢ãªã®éè² è·ãåé¿ããä»®æ³ãã·ã³éã®ã¡ã¢ãªç«¶åãé²ããŸãã
- ããŒããŠã§ã¢ NUMA ç©çã¡ã¢ãªå²ãåœãŠããã§ãã¯ããŠãç©ç NUMA å¢çå ã§ä»®æ³ãã·ã³ã«å²ãåœãŠãããã¡ã¢ãªã®æ倧éã決å®ããããšãæ€èšããŠãã ããã
- é©åãªããã©ãŒãã³ã¹ãéæããããšãäž»ãªç®æšã§ããå Žåã¯ãå²ãåœãŠãããã¡ã¢ãªãšåãã¡ã¢ãªãäºçŽããããšãæ€èšããŠãã ããã ãã®ãã©ã¡ãŒã¿èšå®ã«ãããä»®æ³ãã·ã³ãç©çã¡ã¢ãªã®ã¿ãåãåãããã«ãªããŸãã
ä»®æ³åã¹ãã¬ãŒãž
ä»®æ³åç°å¢ã§ã¹ãã¬ãŒãžãèšå®ããã«ã¯ãã¹ãã¬ãŒãž ã€ã³ãã©ã¹ãã©ã¯ãã£ã«é¢ããç¥èãå¿ èŠã§ãã NUMA ãšåæ§ã«ãããŸããŸãªã¬ãã«ã® I/O ãã©ã®ããã«æ©èœããããç解ããå¿ èŠããããŸãããã®å ŽåãVM å ã®ã¢ããªã±ãŒã·ã§ã³ããæ°žç¶ã¹ãã¬ãŒãž ã¡ãã£ã¢äžã®æ å ±ã®ç©ççãªèªã¿åãããã³æžã蟌ã¿ãŸã§ã§ãã
vSphere ã«ã¯ãã¹ãã¬ãŒãžãæ§æããããã®å€æ°ã®ãªãã·ã§ã³ãçšæãããŠãããUnity XT ã¢ã¬ã€ã䜿çšãã SQL Server ã®å®è£ ã«äŸ¿å©ãªã¢ããªã±ãŒã·ã§ã³ãå«ãŸããŠããŸãã FS VMFS ã¯ãUnity XT ãªã©ã®ããã㯠ã¹ãã¬ãŒãž ã·ã¹ãã ã§æãåºã䜿çšãããŠããããŒã¿ ã¹ãã¬ãŒãžæ¹æ³ã§ãã Unity XT ã¢ã¬ã€ã¯ãvSphere ã«ãã£ãŠè«çãã£ã¹ã¯ (ããªã¥ãŒã ) ãšããŠå ¬éãããç©çãã©ã€ãã§æ§æãããæäžå±€ã§ãã Unity XT ããªã¥ãŒã ã¯ãESXi ãã€ããŒãã€ã¶ã«ãã£ãŠ VMFS ããªã¥ãŒã ãšããŠãã©ãŒããããããŸãã VMware 管çè ã¯ãã²ã¹ã ãªãã¬ãŒãã£ã³ã° ã·ã¹ãã ã«æäŸããã XNUMX ã€ä»¥äžã®ä»®æ³ãã£ã¹ã¯ (VMDK) ãäœæããŸãã RDM ã䜿çšãããšãVMFS ããã©ãŒãããããã«ãä»®æ³ãã·ã³ã Unity XT ããã㯠ã¹ãã¬ãŒãž (FC ãŸã㯠iSCSI çµç±) ã«çŽæ¥ã¢ã¯ã»ã¹ã§ããããã«ãªããŸãã VMFS ããªã¥ãŒã ãš RDM ããªã¥ãŒã ã¯ãåããã©ã³ã¶ã¯ã·ã§ã³ ã¹ã«ãŒããããæäŸã§ããŸãã
ESXi çšã® NFS ããŒã¹ã®ã¹ãã¬ãŒãžã®å ŽåãDell EMC ã¯ãæ±çš NFS ãã¡ã€ã« ã·ã¹ãã ã§ã¯ãªã VMware NFS ã䜿çšããããšãæšå¥šããŸãã SQL Server äžã§å®è¡ãããNFS ããŒã¿ ã¹ãã¢äžã® VMDK ã䜿çšããä»®æ³ãã·ã³ã¯ãåºç€ãšãªã NFS ã¬ã€ã€ãŒãèªèããŸããã ã²ã¹ã ãªãã¬ãŒãã£ã³ã° ã·ã¹ãã ã¯ãä»®æ³ãã·ã³ã Windows Server ããã³ SQL Server ãå®è¡ããç©çãµãŒããŒãšããŠæ±ããŸãã NFS ããŒã¿ã¹ãã¢äžã®ãã§ãŒã«ãªãŒã㌠ã¯ã©ã¹ã¿ãŒ ã€ã³ã¹ã¿ã³ã¹æ§æã®å ±æãã£ã¹ã¯ã¯ãµããŒããããŠããŸããã
VMware vSphere Virtual Volumes (VVol) ã¯ãåºç€ãšãªãç©çã¡ã¢ãªè¡šçŸ (ããªã¥ãŒã ããã¡ã€ã« ã·ã¹ãã ãªã©) ã«é¢ä¿ãªããä»®æ³ãã·ã³ ã¬ãã«ã§ãã詳现ãªå¶åŸ¡ãæäŸããŸãã VVol ã䜿çšããã¢ã¬ã€ããŒã¹ã®ã¬ããªã±ãŒã·ã§ã³ã¯ãVVol 2.0 (vSphere 6.5) 以éã§ãµããŒããããŠããŸãã RDM ãã£ã¹ã¯ã®ä»£ããã« VVol ãã£ã¹ã¯ã䜿çšããŠãæ°žç¶ç㪠SCSI ããã¯ã¢ããããµããŒããã vSphere 6.7 以éã® SQL ãã§ãŒã«ãªãŒã㌠ã¯ã©ã¹ã¿ãŒ ã€ã³ã¹ã¿ã³ã¹ã«ãã£ã¹ã¯ ãªãœãŒã¹ãæäŸã§ããŸãã
ä»®æ³åãããã¯ãŒã¯
ä»®æ³äžçã®ãããã¯ãŒãã³ã°ã¯ãç©çäžçãšåãè«çæŠå¿µã«åŸããŸãããç©ççãªã±ãŒãã«ãã¹ã€ããã§ã¯ãªããœãããŠã§ã¢ã䜿çšããŸãã SQL Server ã¯ãŒã¯ããŒãã«å¯Ÿãããããã¯ãŒã¯é 延ã®åœ±é¿ã¯ã倧ããç°ãªãå¯èœæ§ããããŸãã æ¢åã®ã¯ãŒã¯ããŒããŸãã¯é©åã«å®è£ ããããã¹ã ã·ã¹ãã ã®ãããã¯ãŒã¯ ããã©ãŒãã³ã¹ ã¡ããªãã¯ã代衚çãªæéã«ããã£ãŠç£èŠãããšãä»®æ³ãããã¯ãŒã¯ã®äœæã«åœ¹ç«ã¡ãŸãã
SQL Server 㧠VMware ä»®æ³åã䜿çšããå Žåã¯ã次ã®ç¹ãèæ ®ããŠãã ããã
- æšæºä»®æ³ã¹ã€ãããšåæ£ä»®æ³ã¹ã€ããã¯ã©ã¡ãããSQL Server ã«å¿ èŠãªæ©èœãæäŸããŸãã
- 管çãvSphere vMotionãããã³ãããã¯ãŒã¯ ã¹ãã¬ãŒãž ãã©ãã£ãã¯ãè«ççã«åé¢ããã«ã¯ãVLAN ã¿ã°ä»ããšä»®æ³ã¹ã€ãã ããŒã ã°ã«ãŒãã䜿çšããŸãã
- VMware ã§ã¯ãvSphere vMotion ãã©ãã£ãã¯ãŸã㯠iSCSI ãã©ãã£ãã¯ãæå¹ã«ãªã£ãŠããä»®æ³ã¹ã€ããã§å€§ããªãã¬ãŒã ãæå¹ã«ããããšã匷ããå§ãããŸãã
- äžè¬ã«ãã²ã¹ã ãªãã¬ãŒãã£ã³ã° ã·ã¹ãã ãšããŒããŠã§ã¢ã®ãããã¯ãŒã¯ ã¬ã€ãã©ã€ã³ã«åŸã£ãŠãã ããã
ãŸãšã
SQL Server ããŒã¿ããŒã¹ç°å¢ã¯ããŸããŸã倧èŠæš¡ãã€è€éã«ãªã£ãŠããŸãã SQL Server 2019 ã§ã¯ãMicrosoft 㯠SQL Server ã®ã³ã¢æ©èœãæ¹åããApache Spark ã HDFS ã«ããããã° ããŒã¿ ã¯ãŒã¯ããŒãã®ãµããŒããªã©ã®æ°ããæ©èœãè¿œå ããŸããã Dell EMC ã¯ãMicrosoft ãšææºããŠãSQL Server ç°å¢ã«å¿ èŠãªã€ã³ãã©ã¹ãã©ã¯ã㣠ã³ã³ããŒãã³ã (ãµãŒããŒãã¹ãã¬ãŒãžããããã¯ãŒã¯) ãæäŸãç¶ããŸãã
ã¹ãã¬ãŒãžãšããŒã¿ããŒã¹ã®å°é家ãååããŠå ±æã¹ãã¬ãŒãž ãã©ãããã©ãŒã äžã« SQL Server ã®ã€ã³ãã©ã¹ãã©ã¯ã㣠ãœãªã¥ãŒã·ã§ã³ãäœæãããšã皌åæéã®å€§å¹ ãªå¢å ãšç·ææã³ã¹ã (TCO) ã®åæžãèŠãããŸãã Dell EMC Unity XT ãªãŒã«ãã©ãã·ã¥ ã¢ã¬ã€ã¯ãé«ãããã©ãŒãã³ã¹ãšäœé 延ãå¿ èŠãšãã SQL Server éçºè ããã³ç®¡çè ã«é©ãããããã¬ã³ãž ãœãªã¥ãŒã·ã§ã³ã§ãã ãã¹ãŠã®ãã©ãã·ã¥ ãã©ã€ãã§å®è¡ããããã«èšèšããã Unity XT ãªãŒã«ãã©ãã·ã¥ã¯ããã¥ã¢ã« CPUããã¥ã¢ã« ã³ã³ãããŒã©ãŒæ§æãããã³ãã«ãã³ã¢ã®æé©åããµããŒãããŸãã
SQL Server ç°å¢ãä»®æ³åããçµç¹ãå¢ããŠããŸãã ä»®æ³åã«ããã¢ãŒããã¯ã㣠ã¹ã¿ãã¯ã«å¥ã®èšèšå±€ãè¿œå ãããŸããã倧ããªå©ç¹ãåŸãããŸãã äžèšã§çŽ¹ä»ããæãäžè¬çã«äœ¿çšãããŠãã VMware ã®æ©èœãšããŒã«ã®ããã€ãã SQL Server ç°å¢ã§åœ¹ç«ã€ããšãããã£ãŠããã ããã°å¹žãã§ãã ããã«è©³çŽ°ãªæ å ±ãåŸãããã«ããªãœãŒã¹ãžã®ãªã³ã¯ããå§ãããŸãã
䟿å©ãªãªã³ã¯é
Dell EMC
ããã«äœ¿ãããœãªã¥ãŒã·ã§ã³ã®ããã® Microsoft SQL Info Hub Microsoft SQL Serverã䜿çšããDell EMC Unityã¹ãã¬ãŒãž Dell EMC Unity: ãã¹ã ãã©ã¯ãã£ã¹ ã¬ã€ã Dell EMC Unity: å§çž®ã«é¢ãããã¯ã€ã ããŒã㌠Dell EMC Unity: ã¹ãããã·ã§ãããšã·ã³ ã¯ããŒã³ã®ãã¯ã€ã ããŒã㌠Dell EMC Unity: ããŒã¿åæžåæ Dell EMC Unity: ããŒã¿åæžã«é¢ãããã¯ã€ã ããŒã㌠Dell EMC Unity XT ã¹ãã¬ãŒãž ã·ãªãŒãºä»æ§ã·ãŒã Dell EMC XT Unity ãªãŒã«ãã©ãã·ã¥ ãŠããã¡ã€ã ã¹ãã¬ãŒãž ïŒååããŒãžïŒKaushik Ghosh ã䜿çšãã Dell EMC Unity 補åã®æŠèŠãšã¢ãŒããã¯ã㣠ïŒãŠãŒãã¥ãŒãïŒDell EMC å°æ¥æ§ã®ãããã€ã€ã«ã㣠ããã°ã©ã
ãŽã€ãšã ãŠã§ã¢
SQL ãµãŒããŒã®ããã° VMware vSphere ã§ã® Microsoft SQL ã®ä»®æ³å VMware vSphere ã§ã® Microsoft SQL Server ã®èšèš - ãã¹ã ãã©ã¯ãã£ã¹ ã¬ã€ã VMware vSphere 6.5 äžã® Microsoft SQL Server ã®ããã©ãŒãã³ã¹ç¹æ§è©äŸ¡
Microsoft
Microsoft SQL Server 2019 ãã¯ãã«ã« ãã¯ã€ã ããŒããŒ
SQL ãµãŒããŒã®ããã°
MicrosoftããŒã¿ãã©ãããã©ãŒã
SQL Server 2019 ã®çŽ¹ä»
SQL Server 2019 CTP çºè¡šã¢ãŒã«ã€ã
åºæïŒ habr.com