![]()
These cards currently run about $4.00-5.00/GB, which is more expensive than most enterprise NAND flash storage, but not outrageously so. I have had some clients simply move all of their data, log, and tempdb files to Intel Optane SSD DC P4800X arrays. For example, you can have your tempdb files here, or perhaps your transaction log files. Once you have a couple of these cards, you can use them for pretty much anything you want for SQL Server usage. Install windows on optane dc persistent memory driver#You will want to make sure that you use the Intel Datacenter NVMe driver rather than the generic Microsoft NVMe driver with these drives. Install windows on optane dc persistent memory windows#These can be used with any version of SQL Server and any relatively recent version of Windows Server. ![]() It is common to use two of these cards in a Storage Spaces RAID 1 array for redundancy. Most existing servers will be able to use these in the HHHL AIC form factor in an available PCIe 3.0 x4 expansion slot. They all have a PCIe 3.0 x4 interface and use the NVMe protocol. They are available in HHHL AIC and U.2 15mm form factors. These are extremely high performance block storage devices that include 375GB, 750GB, and 1.5TB capacities. Here are some more details about Intel’s Optane Data Center products. Intel has a pyramid diagram that they like to show to explain where these data center products fit in the modern data access hierarchy. Intel Optane DC Persistent Memory (Apache Pass, Q2 2019) Install windows on optane dc persistent memory series#Intel Optane SSD DC D4800X Series (Q2 2019) Intel Optane SSD DC P4801X Series (Cold Stream, Q1 2019) Intel Optane SSD DC P4800X Series (Cold Stream, Q4 2017) Intel also has a number of different data center product lines under the Optane umbrella. Both the 900P and newer, faster 905P series products are a great choice for an OS drive for a developer or DBA desktop workstation. I have a couple of Intel Optane 900P PCIe NVMe storage cards in two of my personal desktop systems, and I have been very impressed with them over the past 18 months. There are also pure Optane SSD storage offerings such as the 800P, 900P, and 905P that give the best storage performance from the consumer line. These should give close to Optane SSD storage performance for less intense workloads at a lower cost than a 100% Optane SSD. They have 256GB, 512GB, or 1TB of usable capacity for storage. The Intel Optane Memory H10 with Solid State Storage series are hybrid storage M.2 2280 devices that combine Optane SSD storage as a cache in front of QLC NAND SSD storage on a single M.2 2280 card. ![]() Figure 1 shows an example of this.įigure 1: New Laptop with 24GB of “Memory” This is confusing to a typical consumer, and somewhat deceptive in my opinion. You will see new systems that claim to have 24GB of “Memory” that turns out to actually be 16GB of Intel Optane Memory and 8GB of DDR4 DRAM. These are useful for their intended purpose, but some systems vendors are making dubious marketing claims about them. ![]() These include the Intel Optane Memory and Intel Optane Memory M10 Series of products. Their consumer products include system accelerators that are a cache layer in front of a magnetic HDD or slow SATA NAND SSD. Intel Optane SSD 905P Series (Mansion Beach, Q3 2018) Intel Optane SSD 900P Series (Mansion Beach, Q4 2017) Intel Optane SSD 800P Series (Brighton Beach, Q1 2018) Intel Optane Memory H10 with Solid State Storage (Teton Glacier, Q2, 2019) Intel Optane Memory M10 Series (Stony Beach, Q1 2018) Intel Optane Memory Series (Stony Beach, Q1 2017) ![]() Intel also has Optane product offerings for the consumer market, which further confuses the issue.Īll of these different products use 3D-XPoint (pronounced 3D Cross Point) technology in different ways for different purposes. Unfortunately, Intel Optane is an overloaded marketing term that covers several different product categories and specific products. You may have heard of Intel Optane Technology, but perhaps you aren’t quite sure what that term actually refers to, and whether it is relevant for SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |